Issue 118942

Summary: Can't read more than 6 Columns
Product: Calc Reporter: M Zero <woodcncmetal>
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: doudou1976, leiw
Version: 3.4.0 Beta (OOo)   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
Sheet Made in excel where You can see all of the columns not working none

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.