dpk22dev / php-excel-reader

Automatically exported from code.google.com/p/php-excel-reader
0 stars 0 forks source link

Column widths - wrapping text doesn't wrap, turning off extended info (no col_letters) skips width #55

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1.  Try a spreadsheet with wrapped text set to General format (due to TEXT 
data type limitation of 1,024 character display in Excel itself). 
2. "if ($col_letters)" routine calls colwidth calculation so without 
col_letters set, width is not calc'd? (there's no THEAD section in html 
output when letters are turned off).  
3. Colwidth calculation seems flawed:  colwidth seems to depend on how 
many characters there are in the cell versus reading the column width set 
in XLS (??? could not validate as I don't have a good debugger to step 
through code but appears so based on the comment in the colwidth 
calculation that the calc is based on the "width of 0").  Note: column 
widths are set for all columns in attached XLS and the routine does not 
seem to read it based on the XLS setting but calculates the width to match 
the max number of characters in the column.

What is the expected output? What do you see instead?

Expect to see wordwrapping with column width set to the same as the col 
widths in the original XLS. In a word: WYSIWYG would be the goal (?)

Please provide any additional information below.

Original issue reported on code.google.com by gandalf...@gmail.com on 19 Dec 2009 at 6:29

Attachments: