https://issues.apache.org/bugzilla/show_bug.cgi?id=52349
Bug #: 52349
Summary: FormulaEvaluator formats month of dates different than
Excel and cell.getStringCellValue()
Product: POI
Version: unspecified
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Classification: Unclassified
Created attachment 28080
--> https://issues.apache.org/bugzilla/attachment.cgi?id=28080
Class + xlsx file that demonstrates bug described above.
If you have a spreadsheet containing date formatting formulas such as:
=TEXT(A1, "mmddyyyy")
the value displayed using a FormulaEvaluator will be different for the Month
than what Excel and cell.getStringCellValue().
For example, if you have "12/16/2011" in A1, the formula above will return
"00162011" using a FormulaEvaluator while Excel and cell.getStringCellValue()
will return "12162011".
Attached is a simple class and example Excel file that demonstrates the issue.
Found under java version "1.6.0_24" and "1.7.0" using poi-3.8-beta4
--
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]
