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]>

Reply via email to