Ask Your Question

calc- edit cell- show color border on references to other cells

asked 2017-02-02 22:57:56 +0100

chrisss gravatar image

updated 2017-02-03 14:09:28 +0100

When I edit a formula in some cells, LO displays a colored outline around the cells used as references in the formula that I'm editing. In other cells, it does NOT do this. For example, if I create a formula using the "sum" function, the referenced cells are outlined on edit.

There must be an option, preference, or other switch to turn this on + off. Where do I find that? thanks in advance.

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2017-02-03 15:42:22 +0100

Ratslinger gravatar image

updated 2017-02-03 18:47:36 +0100

From the menu Tools->Options then:

image description

It's the Show references in color selection.


Don't see another setting and can't duplicate your statement:

image description image description

edit flag offensive delete link more

answered 2017-02-03 18:33:03 +0100

chrisss gravatar image

Got it - thanks much. Having checked that box, here's what I'm seeing:

It works if the formula is input like: =SUM(H11:H12) It does NOT appear to work if the formula is input as: =SUM('SheetName'.H11:H12) ... even when the cell to which it refers, is on the same sheet as the cell which contains the formula.

I can go thru and change the references when I want to see the references. Just wondering if I'm missing something else.

thanks again.

edit flag offensive delete link more

answered 2017-11-12 14:46:06 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I guys, i tried for a few times but it doesnt work:

i have the show references in color tickled but... nothing happens.

i'm using the - ma 10.10.5

hope you can help thanks!

edit flag offensive delete link more


Hello, You should not ask a question as an answer. Use comment. However, except for first closing all open LO files first & then checking, I don't see where your problem is. Perhaps ask as a new question.

Ratslinger gravatar imageRatslinger ( 2017-11-12 15:56:19 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-02-02 22:57:56 +0100

Seen: 203 times

Last updated: Nov 12 '17