https://issues.apache.org/bugzilla/show_bug.cgi?id=55265
Bug ID: 55265
Summary: Unable to set cell format to #'##0
Product: POI
Version: 3.9
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Created attachment 30593
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30593&action=edit
Excel cell format including examples
To set a cell to a numeric format showing a single quote every 3 digits (as
usual in Europe), the cell format should be set to #'##0:
cellStyle.setDataFormat(format.getFormat("#'##0"));
But opening the Excel shows the format like this: #\'##0
This results in displaying a single quote even if there's only a value of zero.
Please remove the escaping backslash. Or is there another option to set this
format correctly?
--
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]
