CODEWITHSUNDEEP
formulalibreoffice-calc
Qohelet
Qohelet

Reputation: 1616

Display formulas by formatting/cell settings

How is it possible to display a formula in Libreoffice by a simple change of the formatting or the cell settings of the desired cells?

I'd like to have a table which displays the results and another which displays the formulas next to each other. (at the same time)

The solution Options->LibreofficeCalc->View->Formula doesn't work as the whole document is affected. Also in the print-preview it falls back to the results. (I wish to print it later)

The plugin Display Formula and Result (Value) simultaneously does display them both at the same time but I'm not happy as it seems to work under limited conditions only (Some working formulas are just displayed as ### and if I use it on the whole table it formats cell by cell without the ability to undo it. Having a 5x5 table will cause 25 Ctrl+Z if it's not working as supposed)

Upvotes: 2

Views: 992

Answers (2)

Jim K
Jim K

Reputation: 13790

If you specifically require formatting, then the Display Formula and Result (Value) simultaneously add-on seems to work as desired.

Formulas are displayed as ### if the cells are too small. When this occurs, resize the columns and the full formula will appear.

As to undoing quickly, there are a number of methods:

  • Select the cell range and go to Format -> Clear Direct Formatting.
  • A table of 5x5 can be quickly undone by holding down Ctrl+z for about two seconds.
  • Format -> Conditional Formatting, and hold down shift to select multiple. Press Remove.
  • Format -> Styles and Formatting, and hold down shift to select multiple styles. Then delete them.
  • Reset the whole sheet by running the CFClear macro from https://forum.openoffice.org/en/forum/viewtopic.php?f=20&t=62169.
  • Save the file first and then reload if it is not what you wanted.

To me, the biggest downside of the add-on is that it can potentially double the file size, and it clutters up conditional formatting and cell styles. But if formatting some cells as a formula is a priority, then it seems like a good solution.

Upvotes: 2

ngulam
ngulam

Reputation: 1075

use the formula =FORMULA(cell) to display the formula used in cell

Upvotes: 3

Related Questions