Ask Your Question

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

asked 2019-05-28 17:39:00 +0100

zp gravatar image

updated 2020-10-06 14:24:34 +0100

Alex Kemp gravatar image

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.

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 2020-10-06 14:25:00.418401


Please file a bug report with the problematic file attached.

Mike Kaganski gravatar imageMike Kaganski ( 2019-05-28 17:43:49 +0100 )edit

Ah. I guess this means there is not an easy way to fix this. Okay I will file a bug report, thanks.

zp gravatar imagezp ( 2019-05-30 00:55:39 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-06-03 17:33:41 +0100

zp gravatar image

updated 2019-06-03 17:38:22 +0100

For info, for anyone else experiencing this, my problem was RESOLVED by restoring my user profilefollowing these instructions :

Checking the user profile for corruption is suggested at the very end of the bug report page so two suggestions :

  1. suggest checking this before suggesting a bug report, and / or
  2. the suggestion to check user profile for corruption should be placed at the TOP of the bug report page.

I had already written out the entire report and created an anonymized file specifically to submit and the whole process was somewhat time-consuming, and it turned out, unnecessary. :/ Anyway problem solved, hopefully this info will help others with the same bug in future.

EDIT : I am unable to mark this as the correct answer because I don't have enough points apparently, could someone else do that ?

edit flag offensive delete link more


You can't mark your own answer as correct, obviously.. and someone else than the original questioner can't before a waiting period of 3 days.

erAck gravatar imageerAck ( 2019-06-03 20:46:45 +0100 )edit

Question Tools

1 follower


Asked: 2019-05-28 17:39:00 +0100

Seen: 261 times

Last updated: Jun 03 '19