When working in my spreadsheet, cells containing my formulas display the value I am looking for, but when I go to Preview Print or Print, the formula prints instead of the value. In the Open Office>Preferences>open Office Calc>view, the display formula is not checked. So why is it showing the formula???
This is OO version 3.4.1 operating on an IMac OS X El Capitan Any Ideas?
[Solved] Printing Formulas instead of Values
[Solved] Printing Formulas instead of Values
Last edited by RoryOF on Thu Sep 15, 2016 12:03 pm, edited 2 times in total.
Reason: Added green tick [RoryOF, Moderator]
Reason: Added green tick [RoryOF, Moderator]
Running Open Office 3.4.1 on an iMac with an OS X EL Capitan operating system.
Re: Printing Formulas instead of Values
When in the Print Preview, click Format Page, then select the Sheet tab, next ensure that Formulas is unchecked in the Print section.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
Re: Printing Formulas instead of Values
And please upgrade your software if the newer versions of the AOO or the LibreOffice are available for your operating system.This is OO version 3.4.1
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Solved Printing Formulas instead of Values
Thanks Russell B
Running Open Office 3.4.1 on an iMac with an OS X EL Capitan operating system.