We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

how to show formula in calc [closed]

asked 2014-02-04 17:59:14 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I'm trying to show formulas in a Calc sheet, but when I click on menu->options->Calc->Show->Formula then I see the all the formulas in all sheets. Is there a way to see the formulas in an only one sheet?

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 2016-02-19 06:32:26.262197


2 Answers

Sort by » oldest newest most voted

answered 2014-02-05 01:13:24 +0200

m.a.riosv gravatar image

updated 2017-08-09 08:52:13 +0200

Kunjomachen gravatar image

Maybe this extension can help:


edit flag offensive delete link more


@mariosv - Thanks for this hint. This is already better than the default Calc and pretty close to below sketched enhancement request.Maybe someone will enhance the extension a bit so that the longer formulas overlay neighboring cells to show longer formulas. Thereafter it would be nice to have this in the Calc default version.

ROSt52 gravatar imageROSt52 ( 2014-02-05 02:04:33 +0200 )edit

answered 2014-02-05 01:08:59 +0200

ROSt52 gravatar image

To the best of my knowledge it is not possible to show formulas in some cells and show not in other. Cells styles do not allow this.

However, it would be a great enhancement to have a tool bar button to toogle "show formulas" and "show values" for selected areas (= one or more cells). May I recommend you to file an enhancement request here.

It would be nice if you would then indicate the bug number here so others could add comments to your enhancement reqeust.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-02-04 17:59:14 +0200

Seen: 2,923 times

Last updated: Aug 09 '17