Issue 104103 - consolidation of reference colors
Summary: consolidation of reference colors
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: OOO310m11
Hardware: Other All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
: 104196 (view as issue list)
Depends on:
Reported: 2009-08-08 11:11 UTC by risch
Modified: 2014-01-15 18:18 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

not clear that they belong together (5.68 KB, image/jpeg)
2009-08-14 07:07 UTC, andrej_anubis
no flags Details
no colors when editing (2.13 KB, image/jpeg)
2009-08-14 07:08 UTC, andrej_anubis
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description risch 2009-08-08 11:11:34 UTC
Calc tries to assign a new color to each reference contained in the formula of 
a cell. E.g. B1=SUM(A1;A2;A1) will assign three different colors as soon as I 
reenter the cell for modification. Thus, two colors will be assigned to the 
same reference A1. For a more intuative color scheme, the same reference should 
be indentified always with the same color, no matter how often it ocurrs within 
a formula (Excel scheme).
Comment 1 Regina Henschel 2009-08-08 12:12:16 UTC
That would change the meaning. Currently the color corresponds to the occurrence
in the formula. So you can distinguish whether the first or second A1 in
=SUM(A1;A2;A1) is colored. You need this information, if you will change one
reference be dragging the colored frame.
Comment 2 risch 2009-08-12 20:51:09 UTC
I agree, this would change the meaning - but in my opinion to the better, because
1) if i want to know how many references I have in my formula, I do just count the colores items
and do not mind which color I see. The more important information how many times I am using
the same reference I cannot see easily.
2) having the same color for the same reference is more intuitive, because this way I can find
easily the colored frame that corresponds to each reference in my formula. In my example the
first A1 is blue, A2 red and the second A1 magenta. But where is the colored frame for my blue
reference? It is hidden below the magenta frame for the second occurence. If the second A1
would be blue as well, I would have one color frame for each reference...
Comment 3 Regina Henschel 2009-08-13 14:01:53 UTC
*** Issue 104196 has been marked as a duplicate of this issue. ***
Comment 4 andrej_anubis 2009-08-14 07:07:45 UTC
Created attachment 64151 [details]
not clear that they belong together
Comment 5 andrej_anubis 2009-08-14 07:08:30 UTC
Created attachment 64152 [details]
no colors when editing
Comment 6 Edwin Sharp 2014-01-15 18:18:58 UTC
IMHO comment 2 makes sense.