Hi,
I am currently using apache poi 3.8 and have a little problem with String
values set to a XSSFCell using setCellValue().
If the String starts with - or another character used in Excel formulas,
the text is not formatted as text in Excel (like, when I am entering a '
before a numeric value to format them as text). So if I am trying to edit
the text field in Excel, it is interpreted as a formula whats is not really
what I want.
Is it possible to build something like the manually entered ' when setting
the cellValue?
Here's the code I am using:
cell = row.createCell(ID);
cell.setCellType(Cell.CELL_TYPE_STRING);
cell.setCellValue("-Test");
Can anybody help me?
Best regards
