Posted 6/11/2022 09:35 (#9700340 - in reply to #9688470) Subject: RE: ReCalculate in Libre Calc Spreadsheets
It appears there is a random bug in Calc that is hard to eliminate:
"libreoffice calc had / has a problem with ‘shared formulas’ randomly blocking autocalculate since years, i think 184.108.40.206 was the last ‘save’ version (it was without ‘shared formulas’). the problem described by Budi B L is still in 220.127.116.11.a1 for linux x64 if switched to ‘threaded’ calculate mode, may be also in ‘CL’-mode, ‘unthreaded’ looks working correctly as the bug appears only randomly it’s often considered fixed while still there but not apparent … ‘hard-recalc’ (ctrl-shift-F9) fixes the erroneous results (in most cases) but cells may stay excluded from autocalculation and produce new faults lateron.
you may find work on it at bugs.libreoffice.org 31, e.g. bug #123736."
I have had problems occasionally, usually when referencing external sheets or pivot tables. Sometimes I have had to reload the spreadsheet. I hope I can remember 'hard' recalc (ctrl-shift-F9) and try it next time.
I went a different route when I set Tahoma up as the default font. Under Tools-Options-LO advanced-Open Expert Configuration, I was able to search for font and found default font order and moved Tahoma to the front. I think if using Linux Tahoma font must be added under Linux to be available to all programs, not just LO. There may be a default page setting for headers and footers. I did not find it with a quick search.