https://issues.apache.org/bugzilla/show_bug.cgi?id=50841
Summary: DataFormatter, DateUtil, and ExcelStyleDateFormatter
issues
Product: POI
Version: 3.7
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: POI Overall
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=26697)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=26697)
Modified versions of files with my changes in them and description of changes
I sent in item 48872 last year and did not get a chance to look into it until
recently. Nick Burch worked on my previous comments and did a great job
integrating changes into the libraries. I have a new round of bug fixes and
improvements I'd like to "share".
1. Added an option to support text extraction similar to Excel's CSV with
regards to spacing, invalid dates, scientific notation + sign.
2. Corrected bug with getting format for values = 0 and format expression in 4
parts.
3. Better elapsed time processing, now handling [h], [m], and [s] and more
correct rounding.
4. Milliseconds support: s.0, s.00, and s.000.
I have attached 4 files,
a: modified version of org.apache.poi.ss.usermodel.DataFormatter called
NcoDataFormatter.java
b: modified version of org.apache.poi.ss.usermodel.ExcelStyleDateFormatter
called NcoExcelStyleDateFormatter.java
c: modified version of org.apache.poi.ss.usermodel.TestDataFormatter.java
called NcoTestDataFormatter.java
d: Details of what I changed in Differences.txt
This was done in this way as it's an easy way for me to have access to the
original POI code and access to my "fixed" version of the code, so I can use
both at the same time, if needed. Please use a diff tool to compare the code
between the 3.7 version and mine to see the exact details of code changes.
--
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]
