Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Can't read more than 6 Columns|
|Product:||Calc||Reporter:||M Zero <woodcncmetal>|
|Component:||programming||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Version:||3.4.0 Beta (OOo)|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
Description M Zero 2012-02-21 06:34:41 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.
Comment 1 zhao xia 2012-02-27 08:27:17 UTC
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
Comment 2 zhao xia 2012-03-12 09:30:18 UTC
Propose as release blcoker candidate
Comment 3 zhao xia 2012-03-12 09:37:17 UTC
Verified, it is only sample file related. Not RC blocker
Comment 4 Wang Lei 2012-07-27 03:18:11 UTC
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!
Comment 5 Wang Lei 2012-07-27 03:22:26 UTC
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.