Mar 1, 2011 at 7:12 PM
Edited Mar 1, 2011 at 7:18 PM
Hi. I have tried the above code w/1.7.6 reading a client's XLSX with all columns set to width 20 in Excel, but the value returned is -1..?
I have also tried this code...
...and the value returned is 10..? When I write an XLSX with this code...
...the value Excel sees is 19.29...
It would help to either
- ship PHPExcel with a test file that correctly reads and echoes column widths in the format PHPExcel wants from an inputted file
- some function that auto-converts an inputted Excel width (like 20)
I am migrating from Spreadsheet_Excel_Writer which I think PHPExcel uses too but don't recall this issue with it..?
I guess adding .71 to setWidth() mostly works though.