Bug 147159 - macro was not saved
Summary: macro was not saved
Status: RESOLVED DUPLICATE of bug 148806
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.8.1 release
Hardware: All macOS (All)
: low normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-02-03 16:14 UTC by montergon
Modified: 2022-04-26 19:20 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Dialog box (32.64 KB, image/png)
2022-02-16 19:01 UTC, montergon
Details

Note You need to log in before you can comment on or make changes to this bug.
Description montergon 2022-02-03 16:14:59 UTC
Description:
I have created a macro which runs well but only during the current session. the macro disappears once the computer is off. 
when I try to use the shortcut for the macro, I receive this alarm : 
"Une erreur de structure de script s'est produite lors de l'exécution du script vnd.sun.star.script:Standard.Module1.Orange?language=Basic&location=application en Basic.

Message : The following Basic script could not be found:
library: 'Standard'
module: 'Module1'
method: 'Orange'
location: 'application'"


Actual Results:
a macro is created
a keyboard shortcut is associated

Expected Results:
All works well in the current session. The macro works with the shortcut.
But, at the next session, the macro has disappeared and does not appear in the list of macro. The shortcut does not operate…


Reproducible: Always


User Profile Reset: No



Additional Info:
should have saved the macro
Comment 1 Regina Henschel 2022-02-04 00:01:00 UTC
(In reply to montergon from comment #0)
> Description:
> I have created a macro which runs well but only during the current session.
> the macro disappears once the computer is off.

How do you have created the macro?

Into which library do you have stored the macro?

Do you see your macro in the Object Catalog in the Basic IDE (Tools > Macros > Edit Macros)?

What is the name of your macro?
Comment 2 montergon 2022-02-16 19:01:48 UTC
Created attachment 178316 [details]
Dialog box
Comment 3 montergon 2022-02-16 19:05:31 UTC
Sorry for the delay but I have answered your e-mail and waited for an answer unaware that replies to the e-mail was impossible (no warning in your message !)… 

Here attached is the message I get when I do the assigned keyboard shortcut to the macro, after closing and re-opening LibreOffice.

As a matter of fact, the macro is no more in the list of macros…

Answers to your questions are in your message below :

> How do you have created the macro? Through the menu "Outils/Macros/Enregistrer une macro"
>
> Into which library do you have stored the macro? Mes macros / standard / Module 1, like all the other macros I have created and which run well
> Do you see your macro in the Object Catalog in the Basic IDE (Tools > Macros >
> Edit Macros)? No, Not once I have closed my session
>
> What is the name of your macro? "Oranje"
Comment 4 QA Administrators 2022-02-17 03:40:52 UTC Comment hidden (obsolete)
Comment 5 montergon 2022-02-23 21:55:34 UTC Comment hidden (obsolete)
Comment 6 Timur 2022-03-21 13:39:45 UTC
Bug is still Unconfirmed and reporter is not allowed to confirm himself.
Just set Unconfirmed. 
This is either Mac specific or some local issue, not general one. 
User Profile Reset: indicates you should try with profile rename/delete.
Or you may repeat LO installation.
If nothing helps, you should also attach here macro content for a test.
Comment 7 Regina Henschel 2022-03-21 14:28:11 UTC
(In reply to montergon from comment #3)
> Sorry for the delay but I have answered your e-mail and waited for an answer
> unaware that replies to the e-mail was impossible (no warning in your
> message !)… 

The mail is only a notification.

Your description shows nothing special and working that way results in no problems for me.

Please investigate, whether your user profile is corrupted. Ways to do that are described on https://wiki.documentfoundation.org/UserProfile
Comment 8 Timur 2022-03-21 15:34:31 UTC
Did you assign macro to some event?
Comment 9 montergon 2022-03-21 17:12:19 UTC
I assigned macro to the color of the background in a cell.
Comment 10 QA Administrators 2022-03-22 03:57:34 UTC Comment hidden (obsolete)
Comment 11 Timur 2022-03-22 09:38:48 UTC
Please do User Profile Reset: as advised twice. Best to just rename user profile and keep it, since you will loose macros, and copy them beforehand. 
If problem persists, you should attach here macro content and try run without assigning macro. 
You should also write all instead of short replies. How exactly did you assigned macro to the color of the background?
Comment 12 Timur 2022-04-26 19:20:59 UTC
No response here. Let's assume the same issue as short but clear bug report.

*** This bug has been marked as a duplicate of bug 148806 ***