Bug 98320 - EDITING: Colored frames of adjoined cells are hard to distinguish
Summary: EDITING: Colored frames of adjoined cells are hard to distinguish
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: needsDevEval, topicUI
Depends on:
Blocks: Cell-Formula
  Show dependency treegraph
 
Reported: 2016-03-01 19:22 UTC by Tobias Hemm
Modified: 2023-05-06 18:14 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
Colored frames of adjoined cells are hard to distinguish (58.46 KB, image/jpeg)
2016-03-01 19:22 UTC, Tobias Hemm
Details
how it looks in excel (18.87 KB, image/png)
2016-03-02 21:39 UTC, Yousuf Philips (jay) (retired)
Details
how it looks in WPS/Kingsoft (10.61 KB, image/png)
2016-03-02 21:41 UTC, Yousuf Philips (jay) (retired)
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:22:48 UTC
Created attachment 123120 [details]
Colored frames of adjoined cells are hard to distinguish

When editing a formula, colored frames around cells are sometimes hard to distinguish from one another when two cells are adjoined.

For example, in the attached file, you'll see that cells B4 and B5 are hard to tell apart, since their colors--red and pink--are pretty similar.

I think it would help if the frames were thicker.
For this to work, it could be necessary to remove one of two 'colliding' lines--and also the squares in the corner--if two highlighted cells are adjoined.

Another suggestion would be a transparent background of the whole cell in the same color as the frame.

Also, it would be interesting to see how it looks like without any lines--only background. The background, in such a case, must, of course, 'outweigh' a potential background color that was changed by formatting.
Comment 1 Joel Madero 2016-03-02 20:20:21 UTC
@Tobias - please keep it to one suggestion/bug per report :)

That being said, pushing this to the UX team to look at.
Comment 2 Yousuf Philips (jay) (retired) 2016-03-02 21:39:34 UTC
Created attachment 123159 [details]
how it looks in excel
Comment 3 Yousuf Philips (jay) (retired) 2016-03-02 21:41:46 UTC
Created attachment 123160 [details]
how it looks in WPS/Kingsoft

With WPS, it uses a color fill highlight on the current selection that can be modified, so you can easily see one the relevant one.
Comment 4 Yousuf Philips (jay) (retired) 2016-03-02 22:36:44 UTC
So i tried Gnumeric and Calligra Sheets and they have similar behaviours as Calc and Excel.

Making the frames thicker inwards in the cells might be beneficial to make it easier to distinguish the colors, but having a fill highlight inside the selected cells would likely be better, similar to WPS.

@Eike: Is any of this possible?