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)
use the formula =FORMULA(cell) to display the formula used in cell