This has happened to me once before on an older version of Openoffice but it just happened to me again in 3.2.
So, say I have a Calc spreadsheet and write a few user functions in the Basic module that is attached to the spreadsheet document. I switch between the Basic window and the spreadsheet window in test/modify cycles. Eventually I get everything working the way I want. I close the Basic window, keep working in the spreadsheet (or not), and then when I'm done I hit the Save button on the spreadsheet and close that window too. Done for the night, shutdown the computer and all that. Next day I start up my computer, open the spreadsheet and it is the way I left it, as expected. This time, as that time before, I open the spreadsheet and get a face full of macro errors. After being forced to click through _all_ of them (hundreds, btw), I open the Basic module and I find myself looking at the code, as it existed, halfway through yesterday's editing. The rest is gone like it never happened. Functions are incomplete or missing (the source of the errors). I guess I am a bit puzzled by what is going on since I'm not even sure what the correct procedure is when saving a document -- it is very ambiguous. Am I supposed to save the Basic module separately by clicking on the Save icon in the Basic window? If so, why does the document seem to save the macros automatically most of the time, and why is there no warning whatsoever, when closing either the Basic or Calc window, that the macros aren't saved? Otherwise I would have to guess that this is a nasty bug that happens once in a while where the Basic module does not get saved when the spreadsheet is saved. But I'd appreciate clarification on this to minimize the chances of it happening again. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
