Bug 58947 - The color of the cell text in formula can be same as background
Summary: The color of the cell text in formula can be same as background
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.4 release
Hardware: x86 (IA32) Linux (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-UX Cell-Formula
  Show dependency treegraph
 
Reported: 2013-01-02 14:49 UTC by henrikki.almusa
Modified: 2022-09-06 10:02 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Spreadsheet with problematic cell color when editing the formula (7.87 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-01-02 14:49 UTC, henrikki.almusa
Details
Spreadsheet with problematic cell color when editing the formula (7.87 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-01-02 14:54 UTC, henrikki.almusa
Details

Note You need to log in before you can comment on or make changes to this bug.
Description henrikki.almusa 2013-01-02 14:49:55 UTC
Created attachment 72387 [details]
Spreadsheet with problematic cell color when editing the formula

When editing a formula the cells linked are colored. However the color can be same as background, thus making it impossible to see the cell text. See attachment.

My LibreOffice is the one that comes with Kubuntu.
LibreOffice 3.5.4.2 
Build ID: 350m1(Build:2).
Comment 1 henrikki.almusa 2013-01-02 14:54:41 UTC
Created attachment 72389 [details]
Spreadsheet with problematic cell color when editing the formula

Attachment type corrected.
Comment 2 Winfried Donkers 2013-02-12 12:33:44 UTC
I cannot confirm a problem with version 3.6.5.2 on Windows XP.

I: 
-opened the document, 
-selected cell A5 (containing the formula)
-and clicked with my mouse in the content entry control below the toolbars
-cells A1, A2 and A3 are marked with a frame, with respectively magenta, red and blue colour.
-cell A5 shows the formlua =[black]A3[blue]-[black]A2[red]-[black]A1[magenta]; the cell content entry control shows the forumla in black.

IMHO cell A5 is difficult to read because the user has set the background colour to red, and not because a bug in calc.

(tested with both value highlighting (Ctrl+F8) on or off).

I would like to propose to change the status of this bug report to SOLVED, WORKSFORME.

@Henrikki:
Is that OK with you?
Comment 3 henrikki.almusa 2013-03-25 07:08:02 UTC
Sorry for a long reply, but I just got a new version of Kubuntu installed and had to check if something happened with new version of LO. 

I think that the color used to show different cells should be able to skip the cell background color. Yes, it was set to be same, but IMO it should not matter as the usability hurts. There can be quite valid reasons to use background colors and that should not detract from usability.
Comment 4 henrikki.almusa 2013-03-25 07:10:10 UTC
Typo in first sentence:

I think that the function used to show different cells should be able to skip the cell background color.
Comment 5 Winfried Donkers 2013-03-25 08:25:59 UTC
Henrikki,

I have changed the bugstatus to confirmed (NEW) and set the severity to enhancement.
Unfortunately I do not have the time to work on it myself right now, perhaps later. Or someone else may jump in :)
Comment 6 Andreas Heinisch 2022-09-06 09:45:31 UTC
Should we skip the color just in the case when the colors or equal?
Comment 7 henrikki.almusa 2022-09-06 10:02:35 UTC
As long as the colors are not same it should be fine. Either the colors of text can be modified or possibly the cell background color is reverted to while during editing.