Bug 101396 - VIEWING Font color changes when auto spellcheck is enabled and text is underlined due to spelling error (steps in comment 7)
Summary: VIEWING Font color changes when auto spellcheck is enabled and text is underl...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.0.4 release
Hardware: All macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Spell-Checking
  Show dependency treegraph
 
Reported: 2016-08-08 19:26 UTC by Björn
Modified: 2020-06-08 18:09 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Font color display changes with active spellchecker and window focus (left: no spellchecker, middle: spellchecker active in focussed window, right: spellchecker active in defocussed window) (369.73 KB, image/tiff)
2016-08-08 19:26 UTC, Björn
Details
LO5152 screenshot (159.78 KB, image/png)
2016-08-09 06:54 UTC, Alex Thurgood
Details
LO530alpha screenshot (149.87 KB, image/png)
2016-08-09 07:00 UTC, Alex Thurgood
Details
cyan (248.80 KB, image/tiff)
2016-08-09 07:49 UTC, Björn
Details
red (264.81 KB, image/tiff)
2016-08-09 07:50 UTC, Björn
Details
Orange1 font colour showing difference in shade when spellcheck activated (9.62 KB, image/png)
2016-08-10 07:17 UTC, Alex Thurgood
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Björn 2016-08-08 19:26:30 UTC
Created attachment 126675 [details]
Font color display changes with active spellchecker and window focus (left: no spellchecker, middle: spellchecker active in focussed window, right: spellchecker active in defocussed window)

In Calc, when several cells have the same font color and some of the cells contain words that are not considered correct by the automatic spell checker and thus are underlined with a red spell checker marking, then the displayed font color of these cells differs from those with no spell checker markings.

It seems that the color of the marked cells is lighter than regular. This can is not easy to see with each color - I used "Sky blue 2" to demonstrate the effect in the screenshots.

Re-applying the font color does not change anything.

The color noticably changes when automatic spell checking is switched on or off. The colors also seem to differ depending on whether the window is focussed or not:

- No spell checker active: regular color
- Spell checker active and window has focus: marked cells are displayed in a lighter color
- Spell checker active and window has no focus: all cells are displayed in a lighter color

The color change seems to affect the whole line. Neighboring cells are changed in color, too, even if they are not marked by the spell checker.

This bug seems not to occur in Writer.
Comment 1 Alex Thurgood 2016-08-09 06:53:45 UTC
Can not reproduce with 

Version: 5.1.5.2
Build ID: 7a864d8825610a8c07cfc3bc01dd4fce6a9447e5
Threads CPU : 2; Version de l'OS :Mac OS X 10.11.6; UI Render : par défaut; 
Locale : fr-FR (fr.UTF-8); Calc: group

See my screenshot.
Comment 2 Alex Thurgood 2016-08-09 06:54:23 UTC
Created attachment 126679 [details]
LO5152 screenshot
Comment 3 Alex Thurgood 2016-08-09 06:59:30 UTC
No repro either with :

Version: 5.3.0.0.alpha0+
Build ID: dbbcaad1e960bf322ed0a2aa932623556fdb46dc
CPU Threads: 2; OS Version: Mac OS X 10.11.6; UI Render: default; 
Locale: fr-FR (fr.UTF-8); Calc: group

See screenshot
Comment 4 Alex Thurgood 2016-08-09 07:00:00 UTC
Created attachment 126680 [details]
LO530alpha screenshot
Comment 5 Alex Thurgood 2016-08-09 07:01:30 UTC
Please provide detailed step-by-step instructions on how you prepared each sheet.


Setting NEEDINFO, please set back to UNCONFIRMED once you have provided that information.
Comment 6 Alex Thurgood 2016-08-09 07:02:18 UTC
Also please indicate which zoom level you are operating at, and whether or not your are using a HiDPI display.
Comment 7 Björn 2016-08-09 07:48:16 UTC
My version is
Version: 5.2.0.4
Build-ID: 066b007f5ebcc236395c7d282ba488bca6720265
CPU-Threads: 4; BS-Version: Mac OS X 10.11.6; UI-Render: Standard; 
Gebietsschema: de-DE (de.UTF-8)

My hardware is an iMac 27" (late 2013), so no high DPI (retina) display.

Step-by-step:
1. Open LO
2. Select "Create - Calc Spreadsheet" - empty spreadsheet appears, zoom is 100%
3. Enter mixture of misspelled and correct words in a couple of cells of a single column. The auto spell check is on and immediately marks misspelled words.
4. Mark cells that contain words
5. Choose Font Color - Sky Blue 2
6. Remove cell selection by clicking into empty cell
7. Zoom to 400% - I see the difference in color already
8. Disable auto spell checker (Tools - Automatic Spell Checking) and watch the colors closely - it changes as descibed in the original report.
9. Enable auto spell checker again - colors change again.

This works here with UI language set to English or to German. It seems to me it did not work when I was already at zoom level 400% in step 2 from a previous editing. Maybe the color assignment must be done at zoom level 100%... I tried a couple of times, and that way it always worked.

The color change is actually very hard to get with other colors. I tried Orange 3 and Cyan 2 (see screenshots) - at cyan the change is not noticeable with the naked eye (at least for me), but can be measured e.g. with a color picker in Gimp.
Comment 8 Björn 2016-08-09 07:49:40 UTC
Created attachment 126682 [details]
cyan

Color change barely noticable, but can be measured with a color picker tool.
Comment 9 Björn 2016-08-09 07:50:21 UTC
Created attachment 126683 [details]
red

Color change can be seen with the naked eye
Comment 10 Alex Thurgood 2016-08-10 07:13:54 UTC
Björn : thanks for the detailed repro instructions, I was able to reproduce with Orange1, where the colour change is even noticeable between unflagged text and flagged text on activated spellcheck.

Confirming.

Version: 5.3.0.0.alpha0+
Build ID: 3a668616968dbce778c54ec56847828efa7bdb6d
CPU Threads: 2; OS Version: Mac OS X 10.11.6; UI Render: default; 
Locale: fr-FR (fr.UTF-8); Calc: group
Comment 11 Alex Thurgood 2016-08-10 07:16:07 UTC
So, does the spellcheck code, when it flags a word as incorrect, overlay a colour/shade on the glyphs in addition to the underline. We'd need to find someone who knows the code for that.
Comment 12 Alex Thurgood 2016-08-10 07:17:29 UTC
Created attachment 126710 [details]
Orange1 font colour showing difference in shade when spellcheck activated
Comment 13 Alex Thurgood 2016-08-10 08:04:12 UTC
@lnemeth : any ideas why this might be happening ?
Comment 14 eisa01 2018-03-29 20:37:53 UTC
Still present, and not present in 3.3 so it's a regression

Version: 6.1.0.0.alpha0+
Build ID: a488c7ad2763b944713997911c1ddb0315d8c93f
CPU threads: 2; OS: Mac OS X 10.12.6; UI render: default; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2018-03-26_00:38:29
Locale: en-US (en_US.UTF-8); Calc: group
Comment 15 QA Administrators 2019-04-04 03:04:18 UTC Comment hidden (obsolete)
Comment 16 Björn 2019-04-06 22:53:16 UTC
Still present in the current version:

Version: 6.2.2.2
Build-ID: 2b840030fec2aae0fd2658d8d4f9548af4e3518d
CPU-Threads: 4; BS: Mac OS X 10.14.4; UI-Render: Standard; VCL: osx; 
Gebietsschema: de-DE (de_DE.UTF-8); UI-Sprache: de-DE
Calc: threaded
Comment 17 Björn 2020-02-08 22:45:56 UTC
Cannot reproduce anymore with:

Version: 6.4.0.3
Build ID: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8
CPU threads: 4; OS: Mac OS X 10.14.6; UI render: default; VCL: osx; 
Locale: de-DE (de_DE.UTF-8); UI-Language: en-US
Calc: threaded