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: [email protected]
ReportedBy: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
