BUG: Read of ODS limited to One NULL column before non-null content

Topics: Project Management Forum
Jul 17, 2012 at 2:23 PM

I was just testing some stuff, and saw that XLS and ODS versions of the same file get displayed differently.

I am on PHP 5.3.5 with phpExcel 1.7.7.Using the sampleData provided for the Readers in the download, I saved an ods version of the "example1.xls" file ("example1.ods") and tested it with the exampleReader01.php as provided.

In exampleReader01.php, I compared the xls vs. ods.  For the xls, only sheet 1/3 prints.  For the ods, only sheet 3/3 prints.  I was curious what other differences there might be, so I saved a version of the "example1" sample data with only sheet 2 in both xls and ods.

The xls file seems to load fine, but in the ods version each row seems to be limited to only ONE cell with a NULL value before non-null cell content.  As such, it re-organizes the columns of each row, and the tabular nature of the content is dissolved/lost.

~ Mo

Jul 17, 2012 at 4:32 PM

Have you tried this with the latest github develop branch code, this issue should already have been resolved