After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 144709 - Cell highlighting in function edit mode
Cell highlighting in function edit mode
Status: RESOLVED DUPLICATE of bug 166653
Product: Gnumeric
Classification: Applications
Component: GUI Expression Entry Widget
1.2.x
Other Linux
: Low minor
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2004-06-20 18:52 UTC by garetholoughlin
Modified: 2005-05-25 16:33 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description garetholoughlin 2004-06-20 18:52:16 UTC
This is a feature request.

Gnumeric does this differently than Excel and Openoffice.

Let's say I have a function in cell A3
=A1+A2

If I press F2 to edit cell A3, Excel and Openoffice will put different colored
boxes around A1 and A2 and color the cell references in the edit bar.  This is
very handy.

Gnumeric takes the tack of doing this one at a time depending on where your
cursor is in the edit bar.  If it's under A2 it highlights cell A2 with a blue
box, if it is under cell A1 it highlights cell A1 with a blue box.

It's true that as formulas get complex the Gnumeric approach is quite clean but
it would be helpful if the other behavior were available as well.  

Is it possible to provide both?

Say upon pressing F2, while the cursor is at the end of the edit bar all cells
could be highlighted as is done in Excel and Openoffice, and as the cursor is
moved the current Gnumeric approach is used?  That would seem to give the best
of both worlds.  

In my opinion if you don't have the Excel technique available you'll alienate a
lot of first time power users.


I'm using gnumeric 1.2.8 on the latest FC2 distro.
Comment 1 Jody Goldberg 2004-09-05 14:51:58 UTC
It would be nice to have better range highlighting during expression editing
Comment 2 Morten Welinder 2005-05-25 16:33:45 UTC

*** This bug has been marked as a duplicate of 166653 ***