Issue 26919

Summary: Calc fails to colour cell references while editing formulas
Product: Calc Reporter: norbert2 <norbert.notz>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, kpalagin, pagalmes.lists
Version: OOo 1.1.1RC   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
formel-edit.sxc none

Description norbert2 2004-03-24 11:10:56 UTC 
In the attached document, the blue cell simpily multplies the two green cells:

- Please double click the blue cell (C1) in order to be able to edit its formula
- Now you can see that the both reference-names "A1" and "B1" to the green 
cells are colored
- If you click the cursor with the mouse to another place within the formula, 
the cell-references are still colored (that's OK and equal to Excel)
- But if you move the cursor by the cursor keys, the colors are removed to 
black:

That's a minor problem. Excel does not change to black in this case. Excel does 
change the cell-names to black when really editing the formula.
OOo-Calc should do the same.

Please fix this.
Comment 1 norbert2 2004-03-24 11:11:14 UTC 
Created attachment 14038 [details]
formel-edit.sxc
Comment 2 frank 2004-03-24 11:32:44 UTC 
Hi Niklas,

one for you.

Frank
Comment 3 norbert2 2004-04-13 07:36:11 UTC 
I forgot to mention that also the colored borders of the reference-cells are 
removed. But this is logical when removing the colores from the cell-names.

Both should be kept when just moving the cursor: the colored cell-names and the 
colored borders.
Comment 4 frank 2005-10-13 13:44:12 UTC 
*** Issue 55242 has been marked as a duplicate of this issue. ***
Comment 5 norbert2 2007-09-21 20:27:06 UTC 
The problem here is that Calc fails to colour cell references "on the fly" while
editing formulas.

I have filled issue 81837 therefore. So this issue is obsolete.

Perhaps it should be set to duplicate of issue 81837, but I don't have the
authority to do that.
Comment 6 frank 2007-09-21 21:49:07 UTC 
*** Issue 81837 has been marked as a duplicate of this issue. ***
Comment 7 norbert2 2007-09-22 05:52:49 UTC 
I think this is a P3 issue because it turned out be more than a cursor problem.
Comment 8 norbert2 2007-09-22 05:57:58 UTC 
Here the correct description of issue 81837, which has been closed by fst,
although I wanted him to close THIS issue:

- please open the attached spreadsheet (link below) (cell A4 should be selected):
http://www.openoffice.org/nonav/issues/showattachment.cgi/48414/issue_81837.ods

- press F2 on cell A4 to edit it's formula:

Note the colored cell references and the colored cell borders.

- Now we want add the content of the cell A3 to the formula, so enter "+A3":

Note that the colors have vanished, after you have started typing.

Oder spreadsheet software like Excel and KSpread set the colors "on the fly"
while editing formulas. Calc should the same.

(Even if only the arrow keys are used to move the cursor through formulas, the
colors are vanishing, although the formula has not been edited.)
Comment 9 canis 2009-03-11 18:23:32 UTC 
Dear developers.
What about this issue?
Can we expect that it will be solved?
Set target at least, please.
Comment 10 norbert2 2009-03-12 11:46:42 UTC 
@canis:
Don't expect this issue to be fixed within the next 10 years. According to
experience Sun gives no priority to such usability glitches.

The only hope is that an external developer will work on it someday.
Comment 11 kpalagin 2009-03-13 11:53:26 UTC 
norbert2,
such attitude is not exactly inspiring for developers. You really have to have 
patience.
Regards,
KP.
Comment 12 Marcus 2017-05-20 11:13:09 UTC 
Reset assigne to the default "issues@openoffice.apache.org".