We use Calc to transcribe data on log page images from old Navy log books. The images come from the U.S. National Archives and Records Administration. Every once in a while, when we load an image into the Log Page sheet, the buttons on the Setup sheet turn black or cloudy. I have identified an image that turns the buttons black, and one that turns them cloudy. Once a button changes colour, it has to be deleted and copied from another spreadsheet.
Steps to Reproduce:
1. Load the image with Index 1 (Green cell A1) Image 5 (Yellow cell B1). Check the buttons the Setup sheet. Do a Save/Close/Re-open. The buttons should be orange.
2. Do the same for Index 2, image 5. Check the buttons. They should be orange.
3. Do the same for Index 2 image 3. Do a Save/Close/Reopen. The buttons go cloudy. You need to replace these buttons with the original ones. I keep the original spreadsheet and work on a copy.
4. Do the same for Index 3 image 145. After a Save/Close/Reopen, the buttons turn black.
There is something about these random images that cause the problem.
Every now and then an image loaded into the Log Page sheet causes the images on the Setup sheet to go opaque Black or Cloudy Grey after the spreadsheet is Saved, Closed and Reopened. This happens only with a few images, perhaps less than 1% of them.
The buttons should not be affected by an image being loaded.
User Profile Reset: No
I'm running Windows 11 on a new PC. This happened on my old PC running Windows 8 and later Windows 10, and on earlier versions of Calc.
Version: 18.104.22.168 (x64) / LibreOffice Community
Build ID: 9c0871452b3918c1019dde9bfac75448afc4b57f
CPU threads: 4; OS: Windows 10.0 Build 22000; UI render: default; VCL: win
Locale: en-CA (en_CA); UI: en-GB
Created attachment 186005 [details]
This is an image of the cloudy buttons.
The spreadsheet is too big to attach. Here is a URL for the spreadsheet.
Created attachment 186368 [details]
(In reply to Michael from comment #0)
> 3. Do the same for Index 2 image 3. Do a Save/Close/Reopen. The buttons go
> cloudy. You need to replace these buttons with the original ones. I keep the
> original spreadsheet and work on a copy.
I don't understand how I can do this. Please explain.
Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the information.
The Green cell, A1, is the image Index.
The Cell cell, A2, is the image Number.
Set the values of Index to 1 and Number to 2. Click on the Get Image button. The image will be imported.
Go to the Setup sheet. The buttons should be orange. Save, close and re-open the spreadsheet. This does not effect the colour of the buttons on the Setup Page.
Do the same for image Index 2 and Number 5. The buttons remain orange.
Then, repeat the process with image Index 2 and Number 3. After a Save/Close/Re-open, the buttons are cloudy. The buttons will stay that way until they are replaced with new buttons.
If you do the same for Image Index 3 Number 145, the orange buttons will go black after the Save/Close/Re-open.
Thanks, now I get it and could reproduce the cloudiness.
Version: 22.214.171.124.alpha0+ (X86_64) / LibreOffice Community
Build ID: 1b463f697405e64a03378fb38a32172c4d3c25e6
CPU threads: 2; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: en-US (en_FI); UI: en-US