Bug 164752 - Calc Push Button: When I click on a Push Button, the background color changes
Summary: Calc Push Button: When I click on a Push Button, the background color changes
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.4.2 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks: Button-Controls
  Show dependency treegraph
 
Reported: 2025-01-17 21:31 UTC by Mark
Modified: 2025-01-25 18:58 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Calc Push BUtton Properties 1 (35.43 KB, image/png)
2025-01-17 21:31 UTC, Mark
Details
Calc Push Button Properties (scrolled to bottom) (33.99 KB, image/png)
2025-01-17 21:34 UTC, Mark
Details
test file from Ask site (12.31 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-01-19 08:50 UTC, raal
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Mark 2025-01-17 21:31:34 UTC
Created attachment 198603 [details]
Calc Push BUtton Properties 1

I have number of push buttons in my spreadsheet.

I have frozen several rows at the top, and each cell is a button.  The buttons are hyperlinks to cells in the same document.  I use this as a "Navigation Bar" to jump to different locations.

I use macros to create the buttons.

For each of these buttons I have set background and text colors, font, etc.

The problem is, when I click one of these buttons, the background color changes.  It gets darker.

If I enable "Design Mode" they all change back to their original color.  Certain other actions so this as well (I don't remember how.)

I am attaching a screenshot of the property window for one of my push buttons.  I'm sorry, but I don't know how to include all of a scrolling window at once, so I will have to attach a second shot to get the rest.

If you need screenshots of the actual buttons please let me know.
Comment 1 Mark 2025-01-17 21:34:35 UTC
Created attachment 198604 [details]
Calc Push Button Properties (scrolled to bottom)
Comment 2 nutka 2025-01-18 14:57:32 UTC
Reproducible with 24.8.4.2 and 24.2.7.2 on Windows 11.

It appears that the change was introduced in version 7.2.0.1
(see the related topic [1] on the Ask LibreOffice site.



----------
[1]
"How can I stop a Calc Command Button (Type URL) from changing Background Color when clicking it?"

https://ask.libreoffice.org/t/how-can-i-stop-a-calc-command-button-type-url-from-changing-background-color-when-clicking-it/111811
Comment 3 raal 2025-01-19 08:50:02 UTC
Repro with Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 9dd225ee8c45d6c944b9ce5578780d89612e9ffb
CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded

but not in Version: 6.4.0.0.alpha1+
Comment 4 raal 2025-01-19 08:50:46 UTC
Created attachment 198610 [details]
test file from Ask site
Comment 5 raal 2025-01-19 08:58:46 UTC
This seems to have begun at the below commit in bibisect repository/OS linux-64-7.2.
Adding Cc: to Matej Kivader ; Could you possibly take a look at this one?
Thanks
 45f8608b090748878b3488ad5b960fd539dabd6e is the first bad commit
commit 45f8608b090748878b3488ad5b960fd539dabd6e
Author: Jenkins Build User <tdf@pollux.tdf>
Date:   Sat Apr 10 15:31:40 2021 +0200

    source 68b225bfbf51391b517dd483181e40e4a4c3fe31

112989: tdf#141195:fix button text color with default background color | https://gerrit.libreoffice.org/c/core/+/112989