Issue 26919 - Calc fails to colour cell references while editing formulas
Calc fails to colour cell references while editing formulas
Status: CONFIRMED
Product: Calc
Classification: Application
Component: code
OOo 1.1.1RC
All All
: P3 trivial with 9 votes (vote)
: ---
Assigned To: niklas.nebel
:
: 55242 81837 (view as issue list)
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2004-03-24 11:10 UTC by norbert2
Modified: 2013-08-07 15:12 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation on: ---
Developer Difficulty: ---


Attachments
formel-edit.sxc (5.39 KB, application/vnd.sun.xml.calc)
2004-03-24 11:11 UTC, norbert2
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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.