https://issues.apache.org/bugzilla/show_bug.cgi?id=52708
Bug #: 52708
Summary: [PATCH] Patch to CellFormat and related classes
Product: POI
Version: 3.8-dev
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: P2
Component: POI Overall
AssignedTo: [email protected]
ReportedBy: [email protected]
Classification: Unclassified
Created attachment 28354
--> https://issues.apache.org/bugzilla/attachment.cgi?id=28354
Patch svn diff
Attached patch fixes CellFormat (and related classes) so that the result of
CellFormat.apply(cell).text is the same as Excel for the following cases:
- negative numbers and formats with a single format section
- formats with multiple sections (and conditions)
- General/@ format for numbers
- boolean TRUE and FALSE returned in uppercase
(As an aside, my rationale for using CellFormat is that it does some things
correctly that DataFormatter doesn't support e.g. scaling commas,
quoted/escaped text in the format. I'm finding it easier to create patches for
CellFormat than for DataFormatter, and I agree with the comment on my previous
patch (issue 54328) that CellFormat and DataFormatter should be merged in the
longer term.)
--
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]
