You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/02/21 07:34:41 UTC
DO NOT REPLY [Bug 118942] New: Can't read more than 6 Columns
https://issues.apache.org/ooo/show_bug.cgi?id=118942
Bug #: 118942
Issue Type: DEFECT
Summary: Can't read more than 6 Columns
Classification: Application
Product: Spreadsheet
Version: OOo 3.4 Beta
Platform: PC
OS/Version: Windows XP
Status: UNCONFIRMED
Severity: critical
Priority: P3
Component: programming
AssignedTo: ooo-issues@incubator.apache.org
ReportedBy: woodcncmetal@hotmail.com
Created attachment 77234
--> https://issues.apache.org/ooo/attachment.cgi?id=77234
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.
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
[Bug 118942] Can't read more than 6 Columns
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118942
Wang Lei <le...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |leiw@apache.org
--- Comment #4 from Wang Lei <le...@apache.org> ---
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!
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 118942] Can't read more than 6 Columns
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118942
--- Comment #5 from Wang Lei <le...@apache.org> ---
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.
--
You are receiving this mail because:
You are the assignee for the bug.
DO NOT REPLY [Bug 118942] Can't read more than 6 Columns
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118942
zhao xia <do...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Flags| |3.4_release_blocker?
--- Comment #2 from zhao xia <do...@hotmail.com> 2012-03-12 09:30:18 UTC ---
Propose as release blcoker candidate
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
3.4_release_blocker requested: [Bug 118942] Can't read more than 6
Columns
Posted by bu...@apache.org.
zhao xia <do...@hotmail.com> has asked for 3.4_release_blocker:
Bug 118942: Can't read more than 6 Columns
https://issues.apache.org/ooo/show_bug.cgi?id=118942
------- Additional Comments from zhao xia <do...@hotmail.com>
Propose as release blcoker candidate
3.4_release_blocker canceled: [Bug 118942] Can't read more than 6
Columns
Posted by bu...@apache.org.
zhao xia <do...@hotmail.com> has canceled zhao xia
<do...@hotmail.com>'s request for 3.4_release_blocker:
Bug 118942: Can't read more than 6 Columns
https://issues.apache.org/ooo/show_bug.cgi?id=118942
------- Additional Comments from zhao xia <do...@hotmail.com>
Verified, it is only sample file related. Not RC blocker
DO NOT REPLY [Bug 118942] Can't read more than 6 Columns
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118942
zhao xia <do...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Flags|3.4_release_blocker? |
--- Comment #3 from zhao xia <do...@hotmail.com> 2012-03-12 09:37:17 UTC ---
Verified, it is only sample file related. Not RC blocker
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
DO NOT REPLY [Bug 118942] Can't read more than 6 Columns
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118942
zhao xia <do...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |doudou1976@hotmail.com
Ever Confirmed|0 |1
--- Comment #1 from zhao xia <do...@hotmail.com> 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
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.