https://bz.apache.org/bugzilla/show_bug.cgi?id=61638
Bug ID: 61638
Summary: Incorrect result from DataFormatter.formatCellValue
for format 60#########
Product: POI
Version: 3.17-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 35444
--> https://bz.apache.org/bugzilla/attachment.cgi?id=35444&action=edit
Screenshot of data within the excel file
Greetings, first of all I shall say thank you to show my appreciation for this
great product, it really helped a lot on projects I've involved throughout my
career.
However recently I've found an issue with the result returned from function
DataFormatter.formatCellValue(Cell cell).
I have this excel sheet filled with "166609647" in one of the cell, and I
applied format "60#########" on it. "60166609647" appears on my Excel program
afterwards, as screenshot attached.
Using below code I'm trying to get what's appeared on the screen:
Cell cell = getTheCell();
DataFormatter df = new DataFormatter();
String displayValue = df.formatCellValue(cell);
What I captured in displayValue is only "166609647", the leading "60" is
nowhere to be found.
If I change the format to "60000000000", the code above works fine, I can get
"60166609647".
I'm already using latest library 3.17 and this issue still occurs.
--
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]
