Bug 150646 - Unable to change font color in spreadsheet cells
Summary: Unable to change font color in spreadsheet cells
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.0.3 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-08-28 15:48 UTC by John Mildfelt
Modified: 2023-09-27 03:15 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description John Mildfelt 2022-08-28 15:48:15 UTC
Description:
I am unable to change the font color in the spreadsheet cells. It always reverts to black from red or any other color. 

Steps to Reproduce:
1.Select any cell and select RED for the cell font color
2.Type in a formula or text and it will appear in the color of red
3.Hit enter or tab to change cells and the red font will revert back to black.

Actual Results:
Font changes colors when you hit enter or tab in any cell 

Expected Results:
To remain the color you have selected in a cell that you selected to display


Reproducible: Always


User Profile Reset: Yes



Additional Info:
The cell color should stay the same from what you selected from the font color
Comment 1 raal 2022-08-28 19:41:00 UTC
Cannot reproduce with Version: 7.5.0.0.alpha0+ / LibreOffice Community
Build ID: 27892a5e12dada80226f778ab2bd14b1bdaab58a
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded
Comment 2 Timur 2022-08-30 09:44:59 UTC
Did you really deleted or renamed LO user folder, as indicated with User Profile Reset: Yes? 
Par paste info from Help-About. 
Do you use some special or dark theme?
Comment 3 QA Administrators 2023-02-27 03:20:13 UTC Comment hidden (obsolete)
Comment 4 ady 2023-02-27 03:56:48 UTC
Menu Tools > Options > LiberOffice > View > Use automatic font color for screen display

A_ Set off / unchecked > font color is seen OK.

B_ Set on / checked > font color gets back to be seen as black, as described by OP.

This is not the first time, and it won't be the last one either. This setting is not understood and not well-known, so users think the resulting behavior is a bug.

Unless something is done somewhere, this kind of reports will keep happening, and worse, users will keep thinking that LO Calc doesn't work in one of the most basic features.

I guess the only thing to do here is to wait for John Mildfelt's confirmation, and then NAB.
Comment 5 QA Administrators 2023-08-27 03:05:46 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2023-09-27 03:15:49 UTC
Dear John Mildfelt,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp