Bug 141840 - Forms (buttons) on one of 18 spreadsheets go black after a Save and Open with Calc 7.0.5.2.
Summary: Forms (buttons) on one of 18 spreadsheets go black after a Save and Open with...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.5.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-04-22 19:54 UTC by Michael
Modified: 2021-04-27 03:35 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
This spreadsheet is affected by 7.0.5.2. (1.70 MB, application/vnd.oasis.opendocument.spreadsheet)
2021-04-22 19:59 UTC, Michael
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Michael 2021-04-22 19:54:05 UTC
Description:
We have 18 spreadsheets used for entering data from US Navy and Coast Guard log books. Each spreadsheet has a Setup page so users can figure various options. This page has two buttons to confirm a proper user and image directory have been selected. When one of these spreadsheets is Saved and re-opened, the buttons turn black. This occurred with version 7.0.5.2. I replaced the buttons from another spreadsheet. The buttons go black after a Save and re-open. I deleted the Setup sheet and copied one from another spreadsheet. The buttons tuned black after a Save and re-open. We have several buttons on our Log sheet. These are all OK. All the buttons on the other 17 spreadsheets are OK.

The buttons, even though black, function as they should.

I uninstalled 7.0.5.2 and installed 6.3.3. When I opened the affected spreadsheet that had been saved with 7.0.5.2, I got black buttons. When I opened up a backup copy with 6.3.5 the buttons were fine after a Save and re-open.
If you email me, I can send you an affected spreadsheet.

https://i.imgur.com/ef8vO9Z.jpg

https://i.imgur.com/D6ZowX6.jpg

Steps to Reproduce:
1. Get a copy of the affected spreadsheet from me.
2. Save and re-open with 7.0.5.2.
3.

Actual Results:
Open Manning_1900_v3_3.ods with 7.0.5.2. After a Save and re-open the buttons on the Setup sheet turn black.

Expected Results:
the buttons should be unchanged.


Reproducible: Always


User Profile Reset: No



Additional Info:
This happens with only one of our 18 spreadsheets. All 18 spreadsheets are similar other than having different Log Pages which is where transcribers enter their data. The log books change formats from year to year and ship to ship, so the 18 spreadsheets have their rows and columns formatted to correspond to a particular ship's log.
Comment 1 Michael 2021-04-22 19:59:01 UTC
Created attachment 171363 [details]
This spreadsheet is affected by 7.0.5.2.

Setup Page buttons go black after a Save and Re-open with Calc 7.0.5.2. They have been OK with Calc versions from 3 to 6.
Comment 2 NISZ LibreOffice Team 2021-04-26 15:58:44 UTC
Does not happen in:

Version: 7.0.0.3 (x64)
Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e
CPU szálak: 4; OS: Windows 10.0 Build 18363; Felületmegjelenítés: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: threaded

Happens in:

Version: 7.0.4.2 (x64)
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: threaded

Does not happen in:

Version: 7.1.0.3 (x64) / LibreOffice Community
Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: threaded

and nightly 7.2 master either.
Comment 3 NISZ LibreOffice Team 2021-04-26 18:29:29 UTC
Seems to have been fixed in 7.1 with:

https://cgit.freedesktop.org/libreoffice/core/commit/?id=b1c119679700630d16bcf76d96a99e3a39908914

author	Luboš Luňák <l.lunak@collabora.com>	2020-06-30 09:38:43 +0200
committer	Luboš Luňák <l.lunak@collabora.com>	2020-07-01 07:35:25 +0200

do not use scanline padding for computing vcl bitmap checksum

Double checked with git checkout HEAD~1 - when using the Skia backend the file save was broken before this commit.

Thanks Luboš for fixing this one!