Bug 146083 - Not able to save macro in calc
Summary: Not able to save macro in calc
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.7.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-12-06 19:32 UTC by Hardik
Modified: 2022-09-25 02:00 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Hardik 2021-12-06 19:32:48 UTC
Description:
Hi there,

Myself Hardik Balwani, I am not able to save my macros in calc
my master file is just 4-5 MB and it is in .xlsm format

whenever i add macro i record it and save it and make few changes in that particular macro. then save the file and close it.

everytime i reopen that file i see my macros have gone. Tried 100 times. nothing worked.

Please help . 
Note: I record macro and save it inside my file only. which means that macros should work in that particular worksheet only. I make new Library under that file name then save it.
there should be option to add keyboard shortcut to run macro. But first we should be able to save it. 
Please someone suggest how can i save my macro code in that file..

One more thing this LibreOffice calc . crashes a lot of time while working with autofilter with multiple sheets. 

Works very slow as compared to microsoft excel.

In that excel calculations works slowly but processor lets you change the sheet and let your cursor to move here and there. but in libreoffice calc , we have to wait until processor complete all the calculations going in background Formulae. 




Actual Results:
Macros should be saved under my file name whenever i reopen my file. 

Here all macros are deleted whenever i reopen my file

Expected Results:
Macros should be saved under my file name whenever i reopen my file


Reproducible: Always


User Profile Reset: No



Additional Info:
Very slow also and crashes alot
Comment 1 Ezinne 2021-12-13 05:43:34 UTC
This issue seems very similar to TDF#139938

*** This bug has been marked as a duplicate of bug 139938 ***
Comment 2 Timur 2022-03-21 15:31:43 UTC

*** This bug has been marked as a duplicate of bug 117266 ***
Comment 3 Justin L 2022-09-25 02:00:38 UTC
No attached example, too unfocused, and no value added. I don't think it is a duplicate of the others, so just mark as INVALID to make it disappear.