[Solved] Printing Formulas instead of Values

Discuss the spreadsheet application

[Solved] Printing Formulas instead of Values

Postby Pappyal » Thu Sep 15, 2016 12:29 am

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?
Last edited by RoryOF on Thu Sep 15, 2016 12:03 pm, edited 2 times in total.
Reason: Added green tick [RoryOF, Moderator]
Running Open Office 3.4.1 on an iMac with an OS X EL Capitan operating system.
Pappyal
 
Posts: 2
Joined: Wed Sep 14, 2016 9:18 pm

Re: Printing Formulas instead of Values

Postby RusselB » Thu Sep 15, 2016 4:32 am

When in the Print Preview, click Format Page, then select the Sheet tab, next ensure that Formulas is unchecked in the Print section.
Print Preview Page Settings.PNG
OpenOffice 4.1.6 and LibreOffice 6.0.6.2 on Windows 7 Pro & Ultimate
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.
User avatar
RusselB
Moderator
 
Posts: 5407
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Printing Formulas instead of Values

Postby Zizi64 » Thu Sep 15, 2016 7:38 am

This is OO version 3.4.1


And please upgrade your software if the newer versions of the AOO or the LibreOffice are available for your operating system.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
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.
User avatar
Zizi64
Volunteer
 
Posts: 8225
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Solved Printing Formulas instead of Values

Postby Pappyal » Thu Sep 15, 2016 11:36 am

Thanks Russell B
Running Open Office 3.4.1 on an iMac with an OS X EL Capitan operating system.
Pappyal
 
Posts: 2
Joined: Wed Sep 14, 2016 9:18 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 17 guests