Issue 118942 - Can't read more than 6 Columns
Summary: Can't read more than 6 Columns
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: 3.4.0 Beta (OOo)
Hardware: PC Windows XP
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2012-02-21 06:34 UTC by M Zero
Modified: 2017-05-20 11:55 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Sheet Made in excel where You can see all of the columns not working (64.50 KB, application/
2012-02-21 06:34 UTC, M Zero
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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.