Issue 103343 - macro must be saved first --or lost
Summary: macro must be saved first --or lost
Status: CONFIRMED
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:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
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: ---

Attachments
file with macro to change (7.45 KB, text/plain)
2009-07-08 19:01 UTC, tab 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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.

@tab:
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
macros
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.