Bug 161645

Cannot change font color in a cell.

Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon.

And pls explain in what cell it doesn't work, and how.
Changing the cell text color or part of the text?

Pls don't sent private messages.

-------- Forwarded Message --------
Subject: 	Re: [Bug 161645] Font Colour not working
Date: 	Wed, 19 Jun 2024 20:17:45 +0200
From: 	Dr. Mark Bugeja MD <marcusfb@gmail.com>
To: 	bugzilla-daemon@bugs.documentfoundation.org


Dear Sirs/ Madams,

Don't make life complicated. I have mentioned what needs to be looked into and the rest is up to your developer/s to work it out. I merely opened a blank sheet and wrote a few characters in a cell and tried to apply the change font colour. The text remained unchanged. I did this AFTER I checked the highlight option for col and row.

Please simplify your reporting procedures and requirements. It is putting me off reporting anything else I happen to encounter and I'd much rather use some other software to get the jobs done. In fact I don't use libreoffice that much to be quite honest because despite so many versions having been released, there are still basic defects that seem to have slipped through the net and no one seems to have noticed! Is the software checked at all for basic functions before being released?

Sorry if I may sound negative about all this but getting replies like this puts me off! I appreciate it is free software but there is a limit to how much one can tolerate. At least show that you have made some attempt to replicate the issue being reported! If you did, you would not be asking further clarifications.

Mark

(In reply to m_a_riosv from comment #3)
> Pls don't sent private messages.
> 
> -------- Forwarded Message --------
> Subject: 	Re: [Bug 161645] Font Colour not working
> Date: 	Wed, 19 Jun 2024 20:17:45 +0200
> From: 	Dr. Mark Bugeja MD <marcusfb@gmail.com>
> To: 	bugzilla-daemon@bugs.documentfoundation.org
> 
> 
> Dear Sirs/ Madams,
> 
> Don't make life complicated. I have mentioned what needs to be looked into
> and the rest is up to your developer/s to work it out. I merely opened a
> blank sheet and wrote a few characters in a cell and tried to apply the
> change font colour. The text remained unchanged. I did this AFTER I checked
> the highlight option for col and row.
> 
> Please simplify your reporting procedures and requirements. It is putting me
> off reporting anything else I happen to encounter and I'd much rather use
> some other software to get the jobs done. In fact I don't use libreoffice
> that much to be quite honest because despite so many versions having been
> released, there are still basic defects that seem to have slipped through
> the net and no one seems to have noticed! Is the software checked at all for
> basic functions before being released?
> 
> Sorry if I may sound negative about all this but getting replies like this
> puts me off! I appreciate it is free software but there is a limit to how
> much one can tolerate. At least show that you have made some attempt to
> replicate the issue being reported! If you did, you would not be asking
> further clarifications.
> 
> Mark

I am interested in this. Can you attach the problem file? All is OK for me after checking with the latest release.

On pc Debian x86-64 with LO Debian package 24.2.4, idem on Win10 x86-64 with LO 24.2.4, I don't reproduce this.

Do you reproduce this on any file or on a specific file only?

Could you respond to mariosv question + try to apply https://wiki.documentfoundation.org/QA/FirstSteps#Corrupted_user_profile
?

You can add a comment by using this link:
https://bugs.documentfoundation.org/show_bug.cgi?id=161645#

you can add an attachment + comment by using https://bugs.documentfoundation.org/attachment.cgi?bugid=161645&action=enter

Now if it's too much for you/don't want to/whatever and want to use another Office suite like Microsoft one, just go ahead.

I just opened a new file and typed a few characters and applied the font color to the highlighted test/ to the selected cell. 

I was just testing a couple of features with nothing specific being done other than using what the software provides on a clean sheet. Just a casual observation which I reported.

There is nothing to add. If there was I most likely would have. I doubt a screen shot or any file would help as it would not show anything other than the fonts remaining the same black colour.

I am using Win 11. Please use a proper windows OS not linux with a Windows simulator. I have experienced and reported issues on another software and the programmer keeps using a linux based system and cannot reproduce what I report. So changes needed simply don't get implemented as the developer cannot be bothered. Very frustrating especially when there is no other software that can do the job. 

The persistence of programmers to keep using Linux as the OS to develop their software when probably 90% of the world population uses Windows as the OS beats me. Use Linux if you wish by all means.... but do keep a proper windows OS on a separate computer to test the software for windows users.... and I recommend a MacOS on yet another.

* text

(In reply to marcusfb@gmail.com from comment #6)
> I just opened a new file and typed a few characters and applied the font
> color to the highlighted test/ to the selected cell.
Ok so it happens with any file.

> 
>...
> There is nothing to add. If there was I most likely would have. I doubt a
> screen shot or any file would help as it would not show anything other than
> the fonts remaining the same black colour.
We still don't know the precise LO version you use (see https://bugs.documentfoundation.org/show_bug.cgi?id=161645#c2). I mean perhaps the pb is already fixed on a recent LO version.
Moreover, you didn't respond about applying https://wiki.documentfoundation.org/QA/FirstSteps#Corrupted_user_profile.

> 
> I am using Win 11. Please use a proper windows OS not linux with a Windows
> simulator. I have experienced and reported issues on another software and
> the programmer keeps using a linux based system and cannot reproduce what I
> report. So changes needed simply don't get implemented as the developer
> cannot be bothered. Very frustrating especially when there is no other
> software that can do the job.
I've got a desktop on Linux and laptop on Windows 10 + another desktop on Windows 11, the 3 worked.
> 
> The persistence of programmers to keep using Linux as the OS to develop
> their software when probably 90% of the world population uses Windows as the
> OS beats me. Use Linux if you wish by all means.... but do keep a proper
> windows OS on a separate computer to test the software for windows users....
> and I recommend a MacOS on yet another.
Linux is more open, most of things are free, more respect on private life, etc. but I won't feed more the troll here.
Yes, there are some people who test on Windows (I just did it on Win10 and Win11), other on macOS.

As indicated above: 24.2.4.2

Why did you ask when the info has been included? 

Am I missing something?

Can you please explain why there should be two seemingly and entirely different software bearing the same name (LO Fresh and LO Still)?

OK.... I see that "still" is an older more "stable" version without the frills of the "fresh".

Poor choice of names! English not your forte I guess.

Simply call "Still": "LibreOffice Original"

Call the "Fresh": "Libre Office Advanced" or "Libre Office Pro" 
or something to that effect

(In reply to marcusfb@gmail.com from comment #9)
> As indicated above: 24.2.4.2
> 
> Why did you ask when the info has been included? 
> 
> Am I missing something?

(In reply to marcusfb@gmail.com from comment #9)
> As indicated above: 24.2.4.2
> 
> Why did you ask when the info has been included? 
Ok you had put this on Version field but since some people choose randomly, I wanted to be sure (since I don't reproduce this in this version)
> 
> Am I missing something?
Yes, you still didn't apply https://wiki.documentfoundation.org/QA/FirstSteps#Corrupted_user_profile

(In reply to marcusfb@gmail.com from comment #11)
> OK.... I see that "still" is an older more "stable" version without the
> frills of the "fresh".
> 
> Poor choice of names! English not your forte I guess.
and I guess a minimum of diplomacy is not yours.

> 
> Simply call "Still": "LibreOffice Original"
> 
> Call the "Fresh": "Libre Office Advanced" or "Libre Office Pro" 
> or something to that effect
No. There's nothing "advanced" in 24.2.4, just a more recent LO version.
It's not "Pro" at all since "Pro" prefer more stable or more "bullet proof" version, so rather 7.6.7 here.


About "Fresh" and "still", I think it's been changed now, at least I don't it see on https://www.libreoffice.org/download/download-libreoffice/ 

Anyway, it's unrelated with your pb here so no need to add more noise about this.

Hehehe! Diplomacy from my experience is the art if a lot of sweet talk without getting anywhere.... Just look at politics....

I do have a target: I want to bring about changes for the better without being frivolous.... highlighting an issue to improve the software for all.

;-)

*of

Change font colour works on Dev 25.2.

I didn't do any changes to the AppData.... files.

@Mark,

For anyone to be able to solve a problem, the problem has to be replicated. I am a common user, just as you. I have tested the behavior you reported with LO Calc on Windows, and I do not reproduce it.

I would like to kindly ask you to follow a few simple steps, in order to move this report forward:

1. Save and close other documents and programs that are not related to this test.
2. Start a new empty Calc spreadsheet.
3. In cell A1, type-in "Text" (without quotation marks).
4. Press the [ENTER] key on your keyboard.

4.1. At this point, the most common behavior is that the active cell is by now cell A2, while the typed-in text is shown on cell A1.

5. Using the arrow keys of your keyboard, move the focus back to the prior cell A1. If the conditions in the prior step ("4.1") were met in your case, then pressing the "UP" arrow key in your keyboard should set cell A1 as the active cell.

6. With cell A1 being the active cell, click on the icon that changes the font color. The icon is a split button: clicking on the right-side down arrow that is part of the icon would allow you to select a different color than the current default ("Dark Red 2").


After following these steps, the font color of the content of cell A1 should be changed according to the color you selected (in the above step 6). According to your next comment, I might add some more steps for you to follow, in order to find out what the problem could be (so it could be solved).

Do you see the Text within cell A1 being displayed with the selected font color then?

I followed those steps in a new calc sheet in LO v. 24.2.4.2. 
Font remains unchanged.
I can change fill in colour of the cell but NOT the font colour.

If I use LO Dev 25.2, then there is no issue.

Mark

Before I post additional instructions, please beware not to execute more than one LO version at a time. You should rather close LO (24.2.4.2) before starting LO Dev (25.2 alpha), or vice versa. It is fine to have both installed, but you should avoid having both opened/running simultaneously.

(In reply to marcusfb@gmail.com from comment #18)
> I followed those steps in a new calc sheet in LO v. 24.2.4.2. 
> Font remains unchanged.

In LO 24.2.4.2, please go to menu View > Value highlighting. Is this ON, or OFF? Please try changing this setting once, try changing the font color of cell A1 again, and then change the same “Value highlighting“ setting once again.

Is there any effect on the displayed font color on cell A1 then?

According to your next comment, I might provide further instructions.

Now we're talking. That.... did correct the issue.

Problem: one does not know whether that feature is on or off since there is an icon in the place where a check mark should be!

There are other features likewise depicted.... 

Shouldn't something be done to facilitate knowing visually what's on and what isn't?

(In reply to marcusfb@gmail.com from comment #20)
> Problem: one does not know whether that feature is on or off since there is
> an icon in the place where a check mark should be!

When the setting is ON, the icon that is shown in the same menu entry has a different background.

> Now we're talking. That.... did correct the issue.

@Mark,

First, I’m glad that helped.

Please understand that most of the comments you see in this Bugzilla tracker are made by volunteers, common users. This site is not for users' support, but to report bugs or enhancement requests.

The next time you believe that something is not working as expected, instead of immediately opening a new bug report please go to <https://ask.libreoffice.org> and open a new topic with your doubts or problem. If other users in the Ask forum can confirm that there is indeed a bug to report, _then_ you might want to open a new bug report with clear steps to reproduce it and what exactly is that you would expect to happen instead. You might also want to add a link to the specific topic in the Ask forum; which usually helps too.

Opening tickets that don't turn out to be real bug reports is a lot of resources being wasted, for all of us. Please keep in mind, again, that I am just a common user like you, and most of us here are.

This is not the first time I suggest, to you specifically, going to the Ask forum. The complaints and rants that I have read in some of your prior comments don't help either. Next time I see a report from you, I will probably think twice before using my time on it.

According to your comment 20, I am now closing this report as not-a-bug.

Thank you. A feature like this should be on by default not requiring activation.... at least in my logic after using Word and Excel for decades. 

I shall keep those comments in mind.... for the next time.... hoping my memory does not fail me and I still have energy to spare as I age ungracefully.

Kindest regards. Sorry to be a bother.