Issue 103343 - macro must be saved first --or lost
Summary: macro must be saved first --or lost
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.1
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2009-07-05 23:32 UTC by tab
Modified: 2013-01-29 21:54 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

file with macro to change (7.45 KB, text/plain)
2009-07-08 19:01 UTC, tab
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description tab 2009-07-05 23:32:29 UTC
From a spreadsheet, open the macro editor; add a macro. Close the editor, then
the spreadsheet. OK.
But, if you close the spreadsheet first (which is easy), the macro is not saved
--no warning. Nasty (unless you enjoy wasting 2 hours of work).
This may be issue 73521, which is 'Fixed'.
Comment 1 Rainer Bielefeld 2009-07-06 07:17:07 UTC
I checked with "Ooo 3.1.0 WIN XP multilingual version German UI activated 
[OOO310m11 (Build 9399)]" and can NOT confirm the reported effect.

please contribute a clear step by step instruction containing all observations
(error messages ...), _every_key_press_and_every_mouse_click_ how to reproduce
the problem, and explain why you believe that your results are unexpected.
That means (for example): 
 do not write something like „I am not able to ...“, but
 „6. left mouse click on …
     expected: …, colour of … changes, … 
     actual: no …., colour remains white, no …

Comment 2 tab 2009-07-08 18:59:33 UTC
Sorry,the problem description was incorrect. Try this:
Open TstBas.ods; in cell A1, add 'new stuff'
hit ~f11 to open Basic; Edit TstBas:ModA module: change 'Jim' to 'Bob'
Try Tools>ExtensionMgr ; no response -- BugEMgr, not in question here
^q: OO closes without any dialog; or: it crashes --because of BugEMgr;
restart: OO offers to recover TstBas
recovery successful
TstBas.ods opens with 'new stuff' in cell A1 --OK, that was saved
But: macro edit was lost; 'Jim' is back.
Conclusion: it seems that that autosave saves the document but forgets to save
Comment 3 tab 2009-07-08 19:01:48 UTC
Created attachment 63442 [details]
file with macro to change
Comment 4 kpalagin 2009-07-11 12:15:13 UTC
Can't repro with 3.1 on WinXP. Steps:
1. open tstbas.ods, enabling macros.Type random text in A1.
2. Tools-Macros-Organize-OO Basic - Macro from tstbas.ods:ModA - Edit.
3. Jim->Bob, close macro editor.
4. Wait 15mins for autosave to do it's job and end soffice.bin via TaskMan.
5. Start OO, enable recovery - both text in A1 and Bob are where they are 
supposed to be.
Comment 5 tab 2009-07-11 20:20:57 UTC
3. Jim->Bob, close macro editor.
That saves the macro. Skip this step, to check if autosave does its job.
End TstBas.ods (Calc; not Basic) with TaskMgr
Comment 6 Mechtilde 2010-01-23 21:01:40 UTC
I can confirm it as the reporter described
Comment 7 Rainer Bielefeld 2010-01-24 09:02:17 UTC
I still can't reproduce any problem, Auto-Backup stores the macro. I did not
find any way to loose the macro except crashing OOo before autosave to loose
latest edit of the macro contents.
Comment 8 tab 2010-01-25 14:39:16 UTC
I will try to give a better description of the problem if it recurs. Meanwhile,
set this issue aside --low priority.