Description: 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. Actual Results: 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. Expected Results: The buttons should not be affected by an image being loaded. Reproducible: Always User Profile Reset: No Additional Info: 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: 7.4.5.1 (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 Calc: threaded
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. https://drive.google.com/file/d/1wzZwQ1eqs1wTDAAWLuK8moG2pJJ5RpMv/view?usp=share_link
Created attachment 186368 [details] Example file
(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: 7.6.0.0.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 Calc: threaded
Dear Michael, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
I have been away on lake with no internet or cell service. I will reply to this as soon as I can, likely within a two or three days.
I tested it with my current version, and the spreadsheet works for me. After do the required steps, the buttons on the Setup Sheet retain their proper colour. I set the status of the bug to Resolved, WorksForMe. I also installed LO 3.3 on a separate computer, but I could not get the spreadsheet to function properly. I installed a Java JRE and loaded all my softkeys. I also changed the Macro Security to the lowest setting, but several of my formulae did not work, so I could not run a test with LO 3.3. I didn't think the amount of work required to get it to work enough to do a test was worthwhile. My current version of LO: Version: 25.2.5.2 (X86_64) / LibreOffice Community Build ID: 03d19516eb2e1dd5d4ccd751a0d6f35f35e08022 CPU threads: 4; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win Locale: en-CA (en_CA); UI: en-GB Calc: CL threaded