Apache OpenOffice (AOO) Bugzilla – Issue 103466
Hi-lighting cells with colours during forumla editing is confusing if the same cell is refered to multiple times
Last modified: 2009-07-13 09:30:22 UTC
The attached screenshot should explain everything. When debugging a formula OO.org helpfully colours the terms and the cell borders so you can see which is which. However if you use the same cell reference multiple times in the formula each reference is assigned a unique colour but each cell is only coloured once. This is confusing and presents a usability issue. Hopefully the attached picture is clear.
Created attachment 63478 [details] Example of confusing colouring when displaying formula
double to Issue 26787 *** This issue has been marked as a duplicate of 26787 ***
closed double