I'm using trying to use HSSF to create an excel spreadsheet, and the user
wants some columns to be prepended with an apostrophe. This forces
left-alignment, and generally does not appear in the spreadsheet display.
Unfortunately, the sheet I created with HSSF does display the apostrophe.
When I click on a cell to edit, and then tab out without actually editing,
the display of the apostrophe is suppressed, although it is still there in
the cell.
The code I using is fairly straightforward:
pCell.setCellValue("'" + asCells[sh]);
Is there some escaping I'm supposed to do?
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>