Well... No one has responded to my post. Which usually means it cannot
be done, or there is some incredibly obvious thing I am missing. If
someone could verify which is the case I would appreciate it.
Thanks
Dale Monti wrote:
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 ");
Yeilds <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>
How can I preserve these spaces using POI?
Thanks
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
__________ Information from ESET NOD32 Antivirus, version of virus
signature database 4515 (20091016) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
