You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2008/10/31 16:00:40 UTC
DO NOT REPLY [Bug 46136] New: Add an ignore warning for cells with
Numbers as Text
https://issues.apache.org/bugzilla/show_bug.cgi?id=46136
Summary: Add an ignore warning for cells with Numbers as Text
Product: POI
Version: unspecified
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: enhancement
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: joe.knudsen@gmail.com
To avoid the warning given by Excel 2002 and greater when a number is stored in
a Text cell. When stored as numbers Excel makes change like removing leading
zeros. From the Excel GUI you can ignore the warning on a per cell basis. I
will attach two files one with the warning (green corner in the cell) and one
where that one cell has been set to ignore. Here is the Biff output of the two
files after a diff on the output.
$ diff biffNormal.txt biffIgnoreError.txt
1690a1691,1702
> recordid = 0x867, size = 19
> [UNKNOWN RECORD:867]
> .id = 867
> [/UNKNOWN RECORD]
>
> Offset 0x6f3 (1779)
> recordid = 0x868, size = 39
> [UNKNOWN RECORD:868]
> .id = 868
> [/UNKNOWN RECORD]
>
> Offset 0x71e (1822)
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 46136] Add an ignore warning for cells with Numbers as Text
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46136
Anjul Tyagi <an...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |anjultyagi@gmail.com
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46136] Add an ignore warning for cells with
Numbers as Text
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46136
Nick Burch <ni...@alfresco.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #4 from Nick Burch <ni...@alfresco.com> 2010-01-03 13:55:14 UTC ---
Most of the record support should now be in SVN
However, I'm not sure of the best way to expose it to the usermodel.
As best as I can tell, each sheet can have a number of FeatHdr+Feat record
pairs. Within each FeatRecord is an array of cell ranges that it applies to,
then a particular shared feature.
For example, it seems you can have:
* range = a1 -> b1, type = formula ignore, set = number as text, empty cell ref
* range = c1 -> c4 + c7 -> c8, type = formulas ignore, set = number as text
* range = a1 -> b1, type = protection, title + type + password hash
Any suggestions on where we've got something vaguely similar in the usermodel
to copy the structure from greatly appreciated!
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46136] Add an ignore warning for cells with
Numbers as Text
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46136
--- Comment #2 from Joe Knudsen <jo...@gmail.com> 2008-10-31 08:02:56 PST ---
Created an attachment (id=22815)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=22815)
Cell where a number is stored as text and the waring is ignored
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 46136] Add an ignore warning for cells with Numbers as Text
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46136
emercoyle@hotmail.com changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |emercoyle@hotmail.com
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46136] Add an ignore warning for cells with
Numbers as Text
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46136
--- Comment #1 from Joe Knudsen <jo...@gmail.com> 2008-10-31 08:02:19 PST ---
Created an attachment (id=22814)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=22814)
A number is stored as text and has the warning
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46136] Add an ignore warning for cells with
Numbers as Text
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46136
--- Comment #3 from Nick Burch <ni...@torchbox.com> 2009-11-06 16:36:27 UTC ---
0x867 = 2151 = FeatHdr = Page 278 of the binary documentation
0x868 = 2152 = Feat = Page 277 of the binary documentation
First we'll need to implement the records, then we can look at hooking them
into the usermodel
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org