Recalculate: Force recalculate - F9 by default, but could be reassigned. OR on the menu at Data --> Calculate --> Recalculate There's also "recalculate hard" which is (probably misunderstood by me) like the first calculate on load. CTRL-F9 or the same menu as recalculate. ___________ Macros: Tools --> options --> Libreoffice --> Security --> Macro Security On Fri, Dec 23, 2022 at 9: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