Formulas won't stay hidden

[suzie250]

Updated a few days ago to the most recent version with Windows 10 x64.

I’m having trouble with formulas not staying hidden. If I open page preview, when I come back, they are all showing again. Also, because of this, the columns won’t stay the size I want them for printing. If I make the column to just fit the numbers, the formulas make the numbers like this ###.

Is there a new setting that I’m missing???

[anon73440385]

Hello,

I read your question the following:

• Everything looks like you want to have it, if you are editing / viewing your document, however
• when it comes to printing your document or using print preview, you see the formulas and not the respective results from the formula evaluation.

If that’s the correct reading, you might have set to print formulas in

Format -> Page -> Tab: Sheet -> Section: Print -> Option: [x] Formulas.

Deactivate the option [ ] Formulas to look like the following;

Hope that fixes your problem.

[Hagar_Delest]

You may have switch on the formula display in the main view.

In the standard view (not the print preview), go to the menu View and click the Show Formula entry.

To show the community your question has been answered, please tag the best answer (), and/or vote for any helpful answer. Else, please edit your question to add information (answers are for solutions only).

[Hagar_Delest]

If it keeps switching back, try to reset your LibreOffice user profile (rename it).

[suzie250]

I have turned it off there and it keeps switching back.

[anon73440385]

Please do **not** use *Add Answer* if you actually don't answer a question but commenting an answer or responding to another user’s comment. Please use ***add a comment*** for that purpose. Thanks in advance …

[EarnestAl]

Have you tried in Tools > Options > LibreOffice Calc > View > Display unticking Formulas?