104103 – consolidation of reference colors

Issue 104103 - consolidation of reference colors

Summary: consolidation of reference colors

Status:	CONFIRMED

Alias:	None

Product:	Calc
Classification:	Application
Component:	viewing (show other issues)
Version:	OOO310m11
Hardware:	Other All

Importance:	P3 Trivial with 2 votes (vote)
Target Milestone:	---
Assignee:	AOO issues mailing list
QA Contact:

URL:
Keywords:	oooqa

Duplicates (1):	104196 (view as issue list)
Depends on:
Blocks:

Reported:	2009-08-08 11:11 UTC by risch
Modified:	2014-01-15 18:18 UTC (History)
CC List:	3 users (show)

See Also:
Issue Type:	ENHANCEMENT
Latest Confirmation in:	4.1.0-dev
Developer Difficulty:	---

Attachments
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
Add an attachment (proposed patch, testcase, etc.)

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.