On 10/22/09 14:52, Steffen Boersig wrote:
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?
Use getString from the com.sun.star.text.XTextRange interface (base of
XText). For getFormula/setFormula, "5" is a value cell.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
