Ask Your Question

How to print formula and value of a cell same time with out altering the formula or value? [closed]

asked 2013-06-16 12:01:59 +0200

jjos gravatar image

updated 2013-06-18 16:34:48 +0200

For example, formula of the cell A1 =AVERAGE(1,2,3) and the printout required is AVERAGE(1,2,3) = 2 instead of just its value ie, 2. Is there any way to print BOTH formula and value of a cell in the cell itself with out adding another row, column or cell in the sheet and without altering the formula or value so that any other cells formula (eg: B1= A1*5) linked to this cell is not affected?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-02 19:29:48.566904

2 Answers

Sort by » oldest newest most voted

answered 2013-06-18 06:17:37 +0200

Kunjomachen gravatar image

updated 2013-06-19 16:27:30 +0200

there is an extension Display Formula and Result (Value) simultaneously. This extension displays formula and result (value) same time in a selected cell. For example if the formula of a cell is "=5×6" then the cell display will be "5×6=30", same time the value (30) and formula (=5×6) of the cell remains unchanged. And as per the question the display in cell B1 will be "A1×5=10"

edit flag offensive delete link more

answered 2013-06-16 13:35:30 +0200

m.a.riosv gravatar image

updated 2013-06-16 13:44:32 +0200

Hi jjos,

not easy black and white at same time.

But I think there are ways to achieve the result.

e.g. in C5: =AVERAGE(1;2;3) in D5: ==MID(FORMULA(C5);2;99)&"="&C5

hidden column D, you can print what you want and keep the calculations.

To hide the column and have a quick access to hidden/show columns, use:
Menu/Data/Group and Outline,

Verify is enable the option in:
Menu/Tools/Options/LibreOffice calc/View - Window - Outline symbols.

Another option is to have two sheets, one with calculations and second one to print.

edit flag offensive delete link more



Thanks mariosv for the answer.

jjos gravatar imagejjos ( 2013-06-16 15:45:28 +0200 )edit

Question Tools


Asked: 2013-06-16 12:01:59 +0200

Seen: 1,943 times

Last updated: Jun 19 '13