https://issues.apache.org/bugzilla/show_bug.cgi?id=48070
Summary: Preserving leading and trailing spaces XSSFCell
Product: POI
Version: 3.5-FINAL
Platform: All
OS/Version: Windows Vista
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
I would like to have a string value in a cell that maintains the leading and
trailing spaces. If I set a String value in a cell with leading and trailing
spaces, the value seems to be preserved in the XML, but does not display in
Excel.
For example:
XSSFCell cell = row.createCell(0);
cell.setCellValue(" XYZ ");
Yields <si><t> XYZ </t></si> in sharedStrings.xml but does not display the
spaces in Excel.
If you just type the value in Excel you get
<si><t xml:space="preserve"> XYZ </t></si>
POI should have some way of preserving these spaces.
Thanks
--
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]
