Re: [libreoffice-users] Macros in spreadsheets

No computer access Right now so everything I say is going to be a guess.

If you are looking to cause functions to recalculate, I think that might be a setting not related 
to macros. Because you can turn off auto recalculation. Also, you can force a full update. I know 
it's on the menu. I don't remember the key strokes but I know it's there something like tools 
recalculator something or maybe it's update all I guess

That said, you can associate events to macros. I do believe. I don't do it often, but I believe you 
can. So you can set a macro to run when a document opens and maybe that's what you want.

I don't remember offhand how to get to events. You can associate a macro to run when an event 
occurs, but I have done it. I designed some macros for a company that wanted things to auto 
calculate when they opened a template.

For me, learning macros was easier by simply looking at examples and then modifying them for my own 
uses. But you're asking how to cause macros to run based on certain conditions, not how do you 
accomplish a specific task.

Best of luck.

⁣Get BlueMail for Android ​

On Dec 23, 2022, 10:51 AM, at 10:51 AM, Michael Tiernan <michael.tiernan@gmail.com> wrote:
> I have a couple of BASIC macros in a spreadsheet.
>
> I keep thinking that there must be a "init" function that isn't being 
> called because each time I open the spreadsheet, the macros don't run.
> I 
> have to mess about a bit and then force each cell to recalculate 
> manually. (I'm sure that there's a global 'recalculate' button/tool 
> somewhere but that's secondary to the problem.)
>
> I know there's a lot of documentation out there on macros (almost too 
> much) but I'm not sure where to start reading, does anyone have a 
> pointer that would address, not how to create a macro but how to 
> incorporate it to become automatic?
>
> Thanks.
>
> -- 
>   << MCT >> Michael C Tiernan. http://www.linkedin.com/in/mtiernan
>   Non Impediti Ratione Cogatationis
>   Women and cats will do as they please, and men and dogs
>    should relax and get used to the idea. -Robert A. Heinlein
>
>
> -- 
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more:
> https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy