Ask Your Question

How does one maintain referenced cell coloring during formula editing?

asked 2019-06-27 19:50:25 +0100

Rich Lang gravatar image

Upon entering edit mode in a cell containing a formula which references other cells, those cells referenced in the formula show on-screen in different colors (having checked "Show references in color" at Tools > Options > LibreOffice Calc > View). But, as soon as I start to edit that formula, those colored borders around the referenced cells immediately disappear.

Is that the way Calc is supposed to operate? Or am I missing some other required setting? Or is this a bug?

I'm new to LibreOffice. So I don't know what the correct answer might be.

In Excel, that coloring of the referenced cells remains throughout the entire editing of the formula. Would be nice if Calc did the same.

(Calc on Windows 7)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-06-27 22:27:38 +0100

m.a.riosv gravatar image

There is a bug opened EDITING : Calc doesn't show colored borders on referenced cells when editing formula, you can add your comment there.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-06-27 19:50:25 +0100

Seen: 44 times

Last updated: Jun 27 '19