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 <[email protected]> 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: [email protected] > 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: [email protected] 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
