LibreOffice Calc: Data -> Calculate -> Recalculate Hard (Ctrl+Shift+F9)

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.

How to clear dashed lines from LibreOffice Calc

I don’t know how it happened but suddenly I found I had this annoying situation in LibreOffice Calc whereby there were “dashed lines” repeating regularly throughout my sheets. Turns out it was display of page breaks. Anyway I found this and the solution was:

Tools ▸ Options ▸ LibreOffice Calc ▸ View ▸ Visual Aids ▸ Page breaks