Apache OpenOffice (AOO) Bugzilla – Issue 56399
Macro and libraries saved with file disappear after page preview
Last modified: 2013-08-07 15:31:33 UTC
Create a new document or open one, for example a spreadsheet 1. Create a new macro (ANY macro), e.g. one that perform a simple ordering 2. Save it with the FILE (NOT as Personal macros or OOo macros) 3. Close and save the document 4. Reopen the file and activate the page preview, then close it 5. Try again to execute the macro created accessing it through Tools > Macro > Execute Macro: you'll not find the file library anymore, just the Personal and OOo libraries, so your macro is disappeared You can still find the library and your macro if you go to Tools > Macro > Organize Macros, and you can execute it, but not through the "Execute Macro" window, anymore Someone else in free.it.comp.software.openoffice (Message-ID: <43592b33$0$20503$4fafbaef@reader4.news.tin.it>) found this bug but with OOo giving an error executing the macro, without the macro disappears.
Using Win XP Pro SP2 OOo 2.0.0 final worksforme / NOT Confirmed I followed your detailed steps and the macro I saved in the file was there and correctly executed w/out incident. In the Macro Selector window, my macro was called Main which was under the module name i gave it, and that was under Standard, and that was under the file name of the spreadsheet.
Sorry, but i have to insist I refered my steps to the italian version of OOo2.0 (a Calc file), so i thought i could have got some different behaviour that eng version; so i installed the english version and repeated the steps; i confirm the same exact result: the macro i saved with the FILE is hidden after you activate and close the page preview, because the entire library is hidden. After closing the page preview if you go to Tools > Macros > Run Macro you can see that in the left panel (the "Library" panel) only "My Macros" and "OpenOffice.org Macros" are listed, while the library named as the file is not listed anymore. You can find it only if you access through Tools > Macros > Organize Macros > OpenOffice.org Basic. If effect what is hidden is the entire library, not the macro(s) itself If you save and close the document and re-open it everything is restored, and if you don't activate the page preview you can see the library "of the file" (e.g. myspreadsheet1.ods->Library1->Module1->Macro1) in Tools > Macros > Run Macro. Go in Page Preview and close it and you will see the library is missing from this window. I tried on different systems (win 2000, XP, 2003 Server, with different hardware) and i got always these results.
Confirmed in Calc and Writer, BUT the steps you listed and their order are wrong. Other applications may have this issue. ! Changed Priority from P2 to P3 since no data is lost ! Changed Subcomponent to ui Other platforms should be checked for this These are the correct steps and in correct order: 1. Create a new Calc or Writer document 1. Create a new macro (ANY macro), e.g. one that performs a simple ordering 2. Save it with the FILE (NOT as Personal macros or OOo macros) under a new module 3. Save the document 4. Activate the page preview, then close it by clicking Close Preview 5. Try to execute the macro created by accessing it through Tools > Macros > Run Macro... : you'll not find the file's library anymore, just the Personal and OOo libraries You can still find the file's library and your macro if you: Go to Tools > Macros > Organize Macros, and you can execute it, but not through "Run Macro..." OR By closing the document and re-opening it, it will be under Tools > Macros > Run Macro... cianoz : For future issues, please re-check your steps to ensure they are correct and in the right order.
I can confirm that behaviour and stumbled upon that problem on Windows XP and SuSE 9.3, OOo 2.0 as well as on a 1.9 Version. Strangewise the makros will work after you save and reopen the document.
->ab
I couldn't reproduce the problem using a src680 m159 in Windows. -> For now: WORKSFORME
The Issue you raised has been marked as 'Resolved' and not updated within the last 1 year+. I am therefore setting this issue to 'Verified' as the first step towards Closing it. If you feel this is incorrect, please re-open the issue and add any comments. Many thanks, Andrew Cleaning-up and Closing old Issues ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html
As per previous posting: Verified -> Closed. A Closed Issue is a Happy Issue (TM). Regards, Andrew