Ask Your Question
1

I'm using "Calc Spreadsheet" for a project and I'm wondering if there is a way to show the full equations on the spreadsheet, rather than just the answers. If so, how?! Thank you! [closed]

asked 2014-05-21 00:01:18 +0200

SamR gravatar image

updated 2016-03-09 21:18:24 +0200

Alex Kemp gravatar image

Need Help with Calc Spreadsheet!

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-23 04:15:52.791803

2 Answers

Sort by » oldest newest most voted
1

answered 2014-05-21 00:38:13 +0200

m.a.riosv gravatar image

There is a function to see the formula in a cell:
=FORMULA(A1)
also there is an extension that maybe can help:
http://extensions.libreoffice.org/ext...

edit flag offensive delete link more
1

answered 2014-05-21 14:07:38 +0200

Regina gravatar image

You can add the command .uno:ToggleFormula to a toolbar. It is the command "ShowFormula" in category "View". With this icon, you can toggle showing formulas or values, that is more useful than the corresponding setting in the options dialog. But in contrast to Excel it acts on the whole sheet and not only on the active cell.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-05-21 00:01:18 +0200

Seen: 89 times

Last updated: May 21 '14