In Calc when View -> Value Highlighting is enabled, values are displayed as follows: "Text cells are formatted in black, formulas in green, number cells in blue, and protected cells are shown with light grey background, no matter how their display is formatted." https://help.libreoffice.org/Calc/Value_Highlighting I received feedback that eg. green can be particularly hard/impossible to see for colorblind users (of course it depends on the kind and degree of colorblindness), so a way to configure the highlight colors could be useful. As far as I can see the fixed colors are set here: https://opengrok.libreoffice.org/xref/core/sc/source/ui/view/output.cxx#292 void ScOutputData::SetSyntaxMode( bool bNewMode ) { ... } I'm not sure where the best place to set the colors would be: Application Colors vs. Expert Configuration. One could also argue towards setting up color profiles for different kinds of color blindnesses, and provide sensible defaults, but that looks like a larger chunk of work.
Hello, I agree with you. I'm visual-impaired and I don't see all the colors myself and such feature could help me and other people more colorblind a lot. I prefer to avoid expert configuration because colorblind have not to be expert to change their configuration. Best regards.
Created attachment 140719 [details] test document
Szymon Kłos committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=fb29b8262488d045a926504725669a362bacb5bb tdf#116241 Customizing value highlighting colors It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
How to test: Open Calc. Tools -> Options -> LibreOffice Calc -> View -> Highlighting
Szymon Kłos committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=154496aefe67b81f80d7c08d12bfb145eddb93ac Revert "tdf#116241 Customizing value highlighting colors" It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Hello all, I no longer understand what is the status of this bug? Does the fix pushed by Szymon Kłos should be tested or it is not enough to fix the issue? Best regards, Alex.
I reverted my change because I'm going to move color configuration to other place - "Application colors". My fix will be available soon.
Szymon Kłos committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=030c30b33b569a38241ac8bd03a2de1fba2313cc tdf#116241 Customizing value highlighting colors It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Andras Timar committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/help/commit/?id=3d8a38dd7bcd9221891c487814dad8bd18785522 tdf#116241 Customizing value highlighting colors -- help text
Hello all, I confirm that the bug is correctly fixed. Thanks a lot Andras Timar for this fix. Best regards, Alex.