https://bz.apache.org/bugzilla/show_bug.cgi?id=61858
Bug ID: 61858
Summary: Getting double value from the method "cell" of
interface "SheetContentsHandler" of
"XSSFSheetXMLHandler" class
Product: POI
Version: unspecified
Hardware: PC
OS: Linux
Status: NEW
Severity: enhancement
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 35586
--> https://bz.apache.org/bugzilla/attachment.cgi?id=35586&action=edit
Changes that give the double value of the cell to output
Hi.
There are two things I think will be helpful with this patch:
1) When in Excel the cell date format and the system date format are same, the
underlying cell format is not considered when reading and the value.Value is
generated based on the local system date format where we are reading the Excel
file.In such a case if I get the cell value in the string format, there is
nothing much I can do to get the value in the format which I required as
output.This can be possible If I have the double value of that cell.
2) When the cell is Number say with format(5,000).If I get the value as String,
I will get it as 5,000. If I want to convert it into a Double by parsing the
value 5,000 It will throw an error. If I have a double value in this case
things can be done easily.
--
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]
