This is a note for Future John. In LibreOffice Calc you can run Data -> Calculate -> Recalculate Hard to force a recalculation of your worksheet. I needed to do this so that changes to my macros got picked up. The shortcut key is Ctrl+Shift+F9. There is also F9 but I can’t use that shortcut key because I have it bound to something else.
LibreOffice Calc: Data -> Calculate -> Recalculate Hard (Ctrl+Shift+F9)
Reply