Apache OpenOffice (AOO) Bugzilla – Issue 118942
Can't read more than 6 Columns
Last modified: 2017-05-20 11:55:37 UTC
Created attachment 77234 [details] Sheet Made in excel where You can see all of the columns not working Made a Spread Sheet in Excel and added more columns but after 6 columns Open Office can't make any more calculations and just gives a #VALUE answer.
Try the same scenario in Impress itself,no problem. But tried against excel and then open by AOO 3.4 dev, I can reproduce this issue. So does OO 3.3. Confirm this is one defect. My system is Windows XP SP3. The build is AOO-Dev Rev. 1240836
Propose as release blcoker candidate
Verified, it is only sample file related. Not RC blocker
More clear description about this bug 1)Open attached sample file MARCO O.O.xls in AOO3.4 2)a lot of cell show #VALUE!, such as G17, G19 ... Open this xls file in Excel 2003, all cell show correct value. Another method to reproduce this bug is 1)New a Spreadsheet doc in AOO3.4 2)Change cell A1 number format from Number/General to Text 3)input 0.1 in cell A1 4) input formula "=A1+1" in cell B3 check the result of cell B3. Expect result is 1.1. Actual result is #VALUE!
The reason is related with String content to numeric value. AOO now only support convert string content to numeric, which is integer numbers including exponent, and ISO 8601 dates and times in their extended formats with separators.