LibreOffice calc not showing colored cell referring since update to [closed]

asked 2017-11-01 17:54:42 +0100

dion gravatar image

updated 2020-09-02 22:14:49 +0100

Alex Kemp gravatar image

Working an a Linux debian unstable system, I upgraded to LibreOffice version

Problem with LibreOffice calc: normally if I click inside a cell that contains a formula referring to other cells, the cell coordinates would get different colors and the cells the formula refers to get the same color. This is a very important feature to be able to debug formulas. In the version above, this does not work any longer. All the colors of the cell coordinates stays black and the cells referred to don't show in any color.

Also Shift+F4 for changing from relative to absolute coordinates does not work.

Any solution?

EDIT: apparently the behavior has changed. I have to double-click the cell now and then it works. So this can be closed or either remaining here for others.

EDIT 2: Shift+F4 has been replaced by F4. The LibreOffice help still specifies Shift+F4 though. See

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by dion
close date 2017-11-01 17:58:56.596190


@dion Please, when closing a question as duplicate add a reference to the "duplicate of" question, here 136193

erAck gravatar imageerAck ( 2017-11-01 18:42:29 +0100 )edit