Apache OpenOffice (AOO) Bugzilla – Issue 111291
Formula colored cell highlighting doesn't work with named cells
Last modified: 2017-07-20 22:12:33 UTC
Calc has the very useful feature of highlighting referenced cells and associated formula content in color when editing a formula. However, I have found that the color highlighting only works if the cells are un-named. With named cells, the highlighting doesn't work. It seems to be a pretty strange decision to disable such a great feature just because cell naming is used. Excel highlights cells whether or not names are used.
Looks like a duplicate of #1339.
As of comment 1. *** This issue has been marked as a duplicate of issue 1339 ***