At 21:30 15/03/2009 -0700, Kev Noname wrote:
When I have a Calc spreadsheet open and there is an abnormal
termination, OpenOffice brings up the recovery dialog when I reopen
the document. In my document I have some user-defined functions. I
notice that about 50% of the time, the recovered document will have
these function calls converted to literal strings, like so:
Original document cell: =USERFUNC()
Recovered document cell: ='USERFUNC'()
(In case it isn't obvious, the function no longer works with this
syntax, you get #REF or Err 509, not sure how this is determined.)
Since the Find/Replace function also parses the quotations, it isn't
possible to automatically restore the cell contents, I have to
manually redo these cells. That is, searching for 'USERFUNC' will be
treated the same as USERFUNC, so replacing the string just puts it
back in between the quotation marks.
I can't comment on your substantive problem: the occurrence of the
quotes in the first place. But in my 3.0.1 for Windows XP, locale:
English (UK), I can simply search for single quote marks and replace
them with nothing - though it needs two replaces for the two quote
marks. Alternatively, I can search for
'USERFUNC'
and replace with
USERFUNC
If you want to do this for a number of user-defined functions, you
could try a regular expression, perhaps something like replacing
'([:alnum:]+)'
(that's *including* those apostrophes, of course) with
$1
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
