Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Toggle highlight cells used in a formula, when clicking in the cell with the formula ?

Up to recently when I clicked in a cell containing a formula, then clicked in the input bar, all the cells used in the formula were highlighted in colour and the formula was displayed in the cell using corresponding colours.

However recently one of my files no longer highlights the cells at all. The details of the formula are displayed, but in black. No other cells are highlighted in any way, whether I click in the input bar or double-click on the formula cell.

It works in other sheets in the same file and in other files so it seems like it must be a local setting but I cannot find how to fix it.

After searching in the forum here I have tried : - updating from 5something to : no change - double-clicking in the formula cell instead of clicking in the input bar : no change - copying the data from the affected sheet(s) to a new sheet : this works until I save, then it stops working. - copying the data to a new file : also works immediately after pasting, then stops working. - Tools > Options > LibreOffice Calc > Display (? my app is in french so I am guessing at the english name), "display references in colour" (again, a translation of what it says in french ; last option in the first section) is selected.

PLEASE HELP this is a big problem for me.