Description: Old versions had Tools>Options>LibreOffice>View Selection.Transparency on/off and percentage Transparency option is now hidden in the "expert options". My most popular answer on ask.libreoffice.org is this: https://ask.libreoffice.org/t/asked-before-calc-ver-7-3-1-3-highlighted-cell-color/75738/4 Steps to Reproduce: 1. Select any cell or range in Calc. Select any text in any component 2. 3. Actual Results: Selection is highlighted in a color that is set up on system level. A spreadsheet's active cell has a thin coloured border. Expected Results: With org.openoffice.Office.Common.DrawingLayer.TransparentSelection = OFF all selections are highlighted in colors complementary to the highlighted items, borders, text, areas which is very easy to spot even in colorful situations. Reproducible: Always User Profile Reset: No Additional Info: Office suites are used by elderly people who suffer a lot from bad UI design.
FWIW: The TransparentSelectionPercentage of 75 to high for my taste. To much transparency, making hard to notice the cell selection on my macbook with greenish system colors
What was the rationale for moving it to Expert Options?
(In reply to Eyal Rozenberg from comment #2) > What was the rationale for moving it to Expert Options? Good question. The commit message making the change points to https://wiki.documentfoundation.org/index.php?title=Design/Whiteboards/Options/Global see https://cgit.freedesktop.org/libreoffice/core/commit/?id=0b0fb87fbac36ef9fbf3dfeac0f1372617f4b3e4 Motivation: These settings aren't necessary for the usability of LibreOffice and don't comply with our design principles. --- Based on few ask question the main issue is that the cell Selection is following system colors. If you have a yellow system color (which appears to be the case here), you will have hard time noticing selections. Especially with high transparency (low contrast) Some other ask reports: https://ask.libreoffice.org/t/calc-how-to-change-color-of-selected-cell-indicator/76852 https://ask.libreoffice.org/t/how-to-change-calc-cell-selector-colour-on-7-3-on-macos/73847 If I read this correctly the removal of Selection.Transparency pre-dates the issue. So nobody missed it until some started pointing to it to solve this way
I suggest to resolve as WF. First, changing the transparency does not change the OS-defined highlight color. If this is set to yellow without a matching dark background it's not our bug. Second, the transparency is working well with 75%. It never has been reported as an issue. Exposing these standards on tools > options clutters the UI and hinders usability.
(In reply to Telesto from comment #3) > Some other ask reports: > https://ask.libreoffice.org/t/calc-how-to-change-color-of-selected-cell- > indicator/76852 > https://ask.libreoffice.org/t/how-to-change-calc-cell-selector-colour-on-7-3- > on-macos/73847 These seem to be about cell selection highlight color. Are you sure those are the links you meant to provide?
(In reply to Heiko Tietze from comment #4) > I suggest to resolve as WF. > > First, changing the transparency does not change the OS-defined highlight > color. If this is set to yellow without a matching dark background it's not > our bug. > Second, the transparency is working well with 75%. It never has been > reported as an issue. Exposing these standards on tools > options clutters > the UI and hinders usability. This is not about changing any color scheme. Turning transparency off enables a completely different scheme of highlighting that does not depend on obscure system settings. It highlights any text/cell selection in complementary colors of whatever has been selected. This is extremely user friendly particularly for elderly users. The feature has been proven as useful by positive forum feedback. The useful feature exists. It has been hidden. Please unhide.
If the elder people struggle to recognize the highlight color from the OS why don't they configure a high-contrast mode? Please don't clutter the UI with unnecessary settings.
(In reply to Andreas Säger from comment #0) > Transparency option is now hidden in the "expert options". > > My most popular answer on ask.libreoffice.org is this: > https://ask.libreoffice.org/t/asked-before-calc-ver-7-3-1-3-highlighted-cell- > color/75738/4 Hi Andreas, It is happening so frequent and so complicated, that you think it is really worth bringing that option back from hidden to somewhere in the UI? thnx - Cor
Similar request in https://bz.apache.org/ooo/show_bug.cgi?id=97672. Michael, what do you think with a11y in mind?
(In reply to Heiko Tietze from comment #9) > Similar request in https://bz.apache.org/ooo/show_bug.cgi?id=97672. > > Michael, what do you think with a11y in mind? From what I can see in a quick test, setting the "Accessibility" -> "Options for High Contrast Appearence" -> "High Contrast" option to "Enable" results in Calc selection being displayed the same way as setting the mentioned expert setting: > Expected Results: > With org.openoffice.Office.Common.DrawingLayer.TransparentSelection = OFF > all selections are highlighted in colors complementary to the highlighted > items, borders, text, areas which is very easy to spot even in colorful > situations. (and might possibly do more in addition, didn't look into it in more detail yet) Therefore: Does that already cover the request made here? Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 0c53ac3ff360a3fd646dcb0c42198300fab86d90 CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+xcb) Locale: en-GB (en_GB.UTF-8); UI: en-US Calc: threaded
(In reply to Michael Weghorn from comment #10) > "High Contrast" option to "Enable" results in Calc selection being displayed > the same way as setting the mentioned expert setting: > ... > Therefore: Does that already cover the request made here? Yes, it does IMO.
NAB -- the global options were reworked/dropped in 2015 for https://gerrit.libreoffice.org/c/core/+/17481/ as worked up in https://wiki.documentfoundation.org/Design/Whiteboards/Options/Global At this point, the 'TransparentSelection' option when set in expert configuration is much less drastic than "Automatic" --> "Enabled" setting of the 'Options for High Contrast Appearance'. Toggling off transparent selection, only inverts the rendering of the selection. While the HC options mode toggles the entire UI response (icon theme, document bg/fg)--users not already on an os/DE HC theme would not like the outcome. Middle ground, bcz bringing the 'TransparentSelection' out of expert configuration would be useful Assistive Technology as a visual aid, how-about adding it to the Tools -> Options -> Accessibility panel? Place it the "Miscellaneous Options" block as 'Disable transparent selection'
(In reply to V Stuart Foote from comment #12) > Middle ground, bcz bringing the 'TransparentSelection' out of expert > configuration would be useful Assistive Technology as a visual aid, > how-about adding it to the Tools -> Options -> Accessibility panel? (In reply to Michael Weghorn from comment #10) > From what I can see in a quick test, setting the "Accessibility" -> "Options > for High Contrast Appearence" -> "High Contrast" option to "Enable" results > in Calc selection being displayed the same way as setting the mentioned > expert setting: Too many options spoil the broth. Adding "[ ] Disable transparent selection" next to "High Contrast [Enable]" rather adds confusion that solving any problems. Do you agree with WF/NAB, Stuart?
(In reply to Heiko Tietze from comment #13) > > Too many options spoil the broth. Adding "[ ] Disable transparent selection" > next to "High Contrast [Enable]" rather adds confusion that solving any > problems. Do you agree with WF/NAB, Stuart? Unfortunately the High Contrast [Automatic|Disable|Enable] toggles the entire UI, while the current expert configuration 'TransparentSelection' affects the limited but very impactful UI in rendering cell selection for both sheet cells in calc and tables in writer. At 7.5 users of os/DE provided HC modes are now better served with Automatic detections. But for low vision users (and folks needing more obvious visual ques, or just when suffering eye fatigue) discovering the 'TransparentSelection' in expert configuration is a challenge. This is a useful UI setting that would be reasonable to provide via toggle from the Tools -> Options -> Accessibility panel.
I believe such an overlapping setting is not helpful as it conflicts / is not effective with the high contrast option. So my take is still to not add but OTOH it won't hurt too many users. Implementation is an easy hack, may accessibility decide whether to do or to resolve WF.
(In reply to Heiko Tietze from comment #15) > may accessibility decide whether to do or to resolve WF. Michael, last word is for you regarding bringing the option back into Options > LibreOffice > Accessibility :) (Makes me wonder if that High Contrast section needs a rethink. Maybe it would be better to drop the dropdown to just follow the OS (with an explanation that LO does that), while still keeping some choice options as "falls in the high contrast category but useful enough to use it on its own".)