Bug 98319 - EDITING: No colored cell names in the input line
Summary: EDITING: No colored cell names in the input line
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.2.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Formula-Bar
  Show dependency treegraph
 
Reported: 2016-03-01 19:02 UTC by Tobias Hemm
Modified: 2023-10-10 14:51 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
No colored cell names in the input line (58.46 KB, image/jpeg)
2016-03-01 19:02 UTC, Tobias Hemm
Details
Example MS Excel (49.46 KB, image/jpeg)
2016-03-21 20:44 UTC, Tobias Hemm
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Tobias Hemm 2016-03-01 19:02:43 UTC
Created attachment 123119 [details]
No colored cell names in the input line

When editing an existing formula, the cell names are colored only in the spreadsheet, but not in the input line.

For people--like me--who edit the formula in the input line, it would be very helpful to highlight the cell names with colors there, as well.
In this way, the assignment of the cells names to the corresponding colored frames would be much easier.

For better understanding of the issue, it might be helpful to see the attached file.
Comment 1 Joel Madero 2016-03-02 20:21:08 UTC
Pushing to UX team.
Comment 2 Yousuf Philips (jay) (retired) 2016-03-02 22:41:49 UTC
It isnt colored in Excel, Quattro Pro and Gnumeric, but is colored in Calligra and Google Docs.
Comment 3 Tobias Hemm 2016-03-21 20:44:37 UTC
Created attachment 123762 [details]
Example MS Excel
Comment 4 Tobias Hemm 2016-03-21 20:46:25 UTC
(In reply to Yousuf (Jay) Philips from comment #2)
> It isnt colored in Excel, Quattro Pro and Gnumeric, but is colored in
> Calligra and Google Docs.


Hi Yousuf,

as far as I know, in Google Docs it is colored in the spreadsheet as well as in the input line. For me, this is the optimal solution.

I know neither Quattro Pro, nor Gnumeric, nor Calligra.

But I can tell you that it is colored in Excel 2013 - however, only in the input line, not in the spreadsheet. (You don't need to believe me. See the attached file.)

Greetings,
Tobias