To view ALL formula on Spreadsheet
Hi
New to LibreOffice, so please forgive the simple question !!
It's possible in Excel to view all formula on a sheet by doing :-
- In an empty cell, type = (equal sign).
- Click the Select All button (to the left of cell A1).
- Select the cell, and on the Formulas tab, in the Formula Auditing group, click Trace Precedents Button image twice.
I've managed to find the 'Tools' 'Detective' 'Trace Precedents', but can't work out how to display all formula on the sheet. I'm needing this to ensure the formulae in an XLS file is going to be stored in an ODS correctly
Many thanks