My calc sheet opens with the formulas showing but when I hit show formula the totals appear. Any ideas as to how to correct this please?
show formulas appears to be checked by default. Clicking on it shows totals. This used to be the other way round. Surely totals should be the default?
Follow the link in the first comment. One of the first phrases there is “choose Tools - Options - LibreOffice Calc - View”. Just do it, look at the state of the first checkbox in the Display section and fix it.
Thank-you for your help. Much appreciated. All OK now.