Here are two lines from a macro I wrote to remove ' from cells in cell
ranges, for example if a cell formula is '20 my macro will convert it to
20.
Selection=ThisComponent.CurrentSelection
Data=Selection.getFormulaArray
I tested the macro and all seemed to work perfectly until I tried it on a
spreadsheet with floating points. The points is actually a comma, since
that is Swedish standard.
So I look at a cell, which contains '0,06253
Of course 0,06253 is shown in the cell. The ' can only be seen in the cell
formula field.
However, in my macro, getFormulaArray seems to return 0,06253 in this
example and it seems like as soon there is a comma involved, the ' can not
be detected with getFormulaArray.
Any suggestions for solutions for this problem?
I am going to experiment with it myself, but I thought that if someone
already know the answer, I don't have to invent the wheel again.
Thanks!
--
Johnny
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
