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'm not sure if this also occurs with built-in functions, but so far I haven't seen it happen with them. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
