Bug 138962 - FORMATTING Font colour & Background colour Icons randomly give drop down colour selection menu rather than repeating the last colour used
Summary: FORMATTING Font colour & Background colour Icons randomly give drop down colo...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-12-15 23:42 UTC by John Lancaster
Modified: 2020-12-22 10:25 UTC (History)
2 users (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 Lancaster 2020-12-15 23:42:07 UTC

    
Comment 1 Ming Hua 2020-12-16 00:03:01 UTC
It's not random at all and those two buttons (and almost all other color buttons on toolbar) are designed to work that way.

The left part of the button, with icon, will apply the last color used when clicked.  The right part, with a downward arrow, will expand the dropdown menu when clicked.  And many other buttons on toolbar have this "more choices" dropdown menu indicated by the downward arrow.

Closing as NOTABUG.  If you don't see this arrow on your buttons or they don't work as I described above, please reopen with screenshot and more details.
Comment 2 John Lancaster 2020-12-16 00:34:55 UTC
64bit windows 10 OS, 64bit intel i5, libreoffice 7.0.3 (and earlier).
Problem occurs in CALC with both 'Background colour' & 'Font colour' icons.

1. Changed a cell colour to one selected from 'Background colour' menu,
2. Selected another cell (nonadjacent), then clicked on 'Background colour' icon 
   to colour the cell.
      Immediately repeat step 2 to colour the next cell.

Usually the selected colour appears, but often the drop down selection appears instead. 
The last used colour on the icon was not outlined in black, nor was any other action (ie selecting 'No fill') done.
It can happen clicking anywhere on the icon, not just close to the 'drop down' arrow.
The problem also happened running Libreoffice calc in safe mode.
Comment 3 John Lancaster 2020-12-16 00:43:41 UTC
Both the 'Back ground colour' icon and its dropdown arrow are clearly shown, I am clicking on the left hand icon not the arrow (which works fine).
Comment 4 Ming Hua 2020-12-16 01:17:37 UTC
(In reply to John Lancaster from comment #3)
> Both the 'Back ground colour' icon and its dropdown arrow are clearly shown,
> I am clicking on the left hand icon not the arrow (which works fine).
Alright, let's reopen it then.

(In reply to John Lancaster from comment #2)
> 64bit windows 10 OS, 64bit intel i5, libreoffice 7.0.3 (and earlier).
> Problem occurs in CALC with both 'Background colour' & 'Font colour' icons.
> 
> 1. Changed a cell colour to one selected from 'Background colour' menu,
> 2. Selected another cell (nonadjacent), then clicked on 'Background colour'
> icon 
>    to colour the cell.
>       Immediately repeat step 2 to colour the next cell.
However, you need to give more detailed steps and more information.

I can not reproduce with 7.0.4 on Windows 10:
Version: 7.0.4.2 (x64)
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 2; OS: Windows 10.0 Build 18363; UI render: default; VCL: win
Locale: zh-CN (zh_CN); UI: en-US
Calc: threaded

Please paste your LibreOffice's version information like above.  Go to Help > About LibreOffice dialog and use the button after "Version" to copy the information there, and paste in this bug.

Also please describe exactly what you did with mouse/keyboard in each steps, avoid vague terms like "a cell colour" or "the next cell".  For example:
1. Click on Cell A1, click the "Backgroud Color" button's dropdown arrow, choose color "Green" in the "standard" pallette;
2. Click on Cell B3, click the "Backgroud Color" button's icon, now B3 is also with green background color;
3. Press right arrow key twice to have Cell D3 selected, click the "Background Color" button's icon again;
etc.

FWIW, I tried multiple ways to select different cells: mouse clicks, arrow keys, PageUp/PageDown keys, all work as expected.

If you can, a screencast video would also be very helpful.
Comment 5 Telesto 2020-12-16 16:04:45 UTC
Also try safe-mode: Menu - Help -> Restart in safe mode
Comment 6 John Lancaster 2020-12-17 18:49:28 UTC
Sorry for delay, reply e-mail got bounced
____________________________________________________________________
Version:		7.0.3.1 (x64)
Build:	 d7547858d014d4cf69878db179d326fc3483e082
Environment:	CPU threads: 8; OS: Windows 10.0 Build 19041
User Interface:	UI render: Skia/Raster; VCL: win
Locale:		en-GB (en_GB); UI: en-GB
Misc:			Calc: threaded

Test 1:
1. Click on Cell A1,   click on "Background Colour" button's dropdown arrow,   Click on colour "RED" in the "standard" palette, now A1 has a “Red” background colour.

2. Click on Cell B2,   click on "Background Colour" button's icon, now B2 also has a “Red” background colour
3. Click on Cell C3,   click on "Background Colour" button's icon, now C3 also has a “Red” background colour
4. Click on Cell C4,   click on "Background Colour" button's icon, now C4 also has a “Red” background colour.

5. Click on Cell A5,   click on "Background Colour" button's icon, now the "standard" palette is displayed, cell A5 has an unchanged “Background Colour” (still “No-Fill”).

5a. Leaving Mouse pointer unmoved on "Background Colour" button's icon, click on "Background Colour" button's icon, the "standard" palette is removed.

5b. Leaving Mouse pointer unmoved on "Background Colour" button's icon, click on "Background Colour" button's icon, the "standard" palette is reappears, cell A5 still has an unchanged “Background Colour” (“No-Fill”).

5c. Leaving Mouse pointer unmoved on "Background Colour" button's icon, click on "Background Colour" button's icon, the "standard" palette is removed.

5e. Leaving Mouse pointer unmoved on "Background Colour" button's icon,    click on "Background Colour" button's icon, now A5 also has a “Red” background colour.

6. Click on Cell D5,   click on "Background Colour" button's icon, now D5 also has a “Red” background colour.

______________________________________________________________________

I repeated an identical test a number of times, with the same initial data (step 1 is always being done).

Test 2:
2. Click on Cell B2,   click on "Background Colour" button's icon, the "standard" palette is displayed, cell B2 has an unchanged “Background Colour” (still “No-Fill”).

2a. Leaving Mouse pointer unmoved on "Background Colour" button's icon, click on "Background Colour" button's icon, the "standard" palette is removed.

2b. Leaving Mouse pointer unmoved on "Background Colour" button's icon,    click on "Background Colour" button's icon, now B2 also has a “Red” background colour.

Test 3:
Background colour of all 11 cells I tried to change were successfully changed to “Red”

Other Tests:
A seemingly random number of cells could have their background colour successfully changed, before the "standard" palette menu appeared. This would typically appear once or twice before the cell background changed as required.

NOTE 1: Found similar behaviour on other icons with dropdowns such as… (as previously mentioned “Font colour”) and also it seems “Border colour” but  other than “Font colour” & “Background Colour” I use the dropdown menus anyway.

NOTE 2: Just duplicated the same dropdown menu problem on another laptop
Version:		7.0.0.3 (x86)
Build:	 8061b3e9204bef6b321a21033174034a5e2ea88e
Environment:	CPU threads: 4; OS: Windows 10.0 Build 18363
User Interface:	UI render: Skia/Raster; VCL: win
Locale:		en-GB (en_GB); UI: en-GB
Misc:			Calc: threaded


Sorry know nothing about ‘screencast video’ will try and research it

John Lancaster
Comment 7 Ming Hua 2020-12-19 07:09:46 UTC
(In reply to John Lancaster from comment #6)
> Test 1:
> 1. Click on Cell A1,   click on "Background Colour" button's dropdown arrow,
> Click on colour "RED" in the "standard" palette, now A1 has a “Red”
> background colour.
> 
> 2. Click on Cell B2,   click on "Background Colour" button's icon, now B2
> also has a “Red” background colour
> 3. Click on Cell C3,   click on "Background Colour" button's icon, now C3
> also has a “Red” background colour
> 4. Click on Cell C4,   click on "Background Colour" button's icon, now C4
> also has a “Red” background colour.
> 
> 5. Click on Cell A5,   click on "Background Colour" button's icon, now the
> "standard" palette is displayed, cell A5 has an unchanged “Background
> Colour” (still “No-Fill”).
Used a new user profile (so Skia enabled) and still can not reproduce using exactly these steps.

Version: 7.0.4.2 (x64)
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 2; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: zh-CN (zh_CN); 界面: zh-CN
Calc: threaded

Not sure what else could be the difference (locale?), but I'm afraid I can't be of much help here.

Also my reading of John's description in comment #6 is that reproduction of this bug doesn't seem deterministic, which further complicates things.

> Sorry for delay, reply e-mail got bounced
Bugzilla doesn't support adding comments through email replys (as far as I know), please always use the web interface.
Comment 8 John Lancaster 2020-12-20 01:17:50 UTC
Re: [Bug 138962] FORMATTING Font colour & Background colour Icons randomly give drop down colour selection menu rather than repeating the last colour used

I had this error on 2 PCs, the only common factor being the mouse used. I managed to get an old ‘broken’ mouse working long enough to try the "Background Colour" button's icon 30+ times with no problem, before the mouse died. The intermittent ‘bug’ still occurred with my current mouse, which otherwise seems to work fine. I suggest this bug report is closed. I will buy another USB mouse too see if the problem persists.

John Lancaster
Comment 9 Ming Hua 2020-12-22 10:25:12 UTC
(In reply to John Lancaster from comment #8)
> I suggest this bug report is closed. I
> will buy another USB mouse too see if the problem persists.
Resolved as WORKSFORME.  Please reopen if new mouse doesn't solve your problem.