The string in the cell is "5" without the "'". The single quote is
added in the input line, and when editing, to allow editing of the
string instead of the number 5.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
Well,my problem is, that methods like String.equals() don't understand
that behaviour. Of course, in the GUI(at least while not looking at the
actual formula) it's shown correctly as a normal "5".
But if I'm calling cell.getFormula().equals("5") it's returning false.
Because actually in the formula there is a leading single quote.
Is XCell.getFormula() the wrong way to get a cells content/String? When
yes, which method should be used?
Is it possible to disable the leading single quote before inserting?
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
