Description: We have about 28 different spreadsheets that we use to log historic data from U.S. Navy logbooks. The first sheet is used for logging data and it has a background image of a log page from a given ship and year. The second sheet is the Setup sheet which is used to configure the way the transcriber uses the spreadsheet. The Setup sheet has two buttons, used to test the existence of the user's directory which holds the transcribed data, and the user's directory that holds the log book images. For some spreadsheets, the buttons on the Setup get corrupted by the log book image, and the colour of the buttons change and the text is obscured. This happens only on occasion and after a spreadsheet is saved and reopened. This occurs if the Setup Sheet is the second one in the spreadsheet, but does not happen if the Setup Sheet is the first one. I have included the Sacramento spreadsheet which has the Setup Page before the Log Page sheet, and it also has a Setup Page following the Log Page sheet. The buttons on the first Setup Sheet are OK, but they are corrupted on the second one. I have also included a Manning spreadsheet, which is OK. Steps to Reproduce: 1.Copy the Setup sheet buttons on the Manning spreadsheet onto the Setup_2 page on the Sacramento spreadsheet. 2.Close the Sacramento spreadsheet. 3.Reopen the spreadsheet. Actual Results: The copied buttons are corrupted after a save, close and reopen. Expected Results: The buttons should be unchanged, as the are on the Manning spreadsheet. Reproducible: Sometimes User Profile Reset: No Additional Info: Sometimes a spreadsheet will be fine but as we process more images, we will discover that the Setup buttons have been corrupted. However, once the Setup parameters have been set, we rarely go back to the Setup page again, so it is difficult to say which image causes the problem. You can change the image directory on the Setup Page and use the Get Image button on the Log Page to download other images. This problem has existed with many earlier versions of Windows and Calc, probably going back to Version 3. Version: 7.5.9.2 (X86_64) / LibreOffice Community Build ID: cdeefe45c17511d326101eed8008ac4092f278a9 CPU threads: 4; OS: Windows 10.0 Build 22000; UI render: Skia/Raster; VCL: win Locale: en-CA (en_CA); UI: en-US Calc: CL threaded
Created attachment 194516 [details] Sacramento spreadsheet with two Setup sheets, one OK, one with corrupt buttons. The buttons on the Setup Page are OK, and remain OK. The buttons on the Setup_2 page get corrupted with the image on the log page after a close and reopen.
Created attachment 194517 [details] The Manning spreadsheet has the Setup sheet following the Log Page sheet, but the buttons on it are OK. The Manning spreadsheet is here as an example. It is also a source for the buttons to go on the Sacramento Setup_2 sheet if needed.
I just realized one other thing. If the Sacramento spreadsheet is saved with "good buttons", it is about 13 M in size. When the spreadsheet is opened, the buttons will be opaque. If the spreadsheet is then saved, the size of the spreadsheet will be twice as large. The image files are about 13 M in size.
Could confirm the buggy behavior. Buttons couldn't be set to normal behavior by the properties of the control. Only possibility is to delete the buttons and create new ones. Tested with Version: 24.2.4.2 (X86_64) / LibreOffice Community Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2 CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded
Created attachment 194826 [details] This is a large image from the USS Lackawanna that does not corrupt the buttons. It has been renamed so that the Sacramento spreadsheet can open it. This image can be used for testing the buttons on the Setup sheet of the Sacramento spreadsheet. It does not affect the appearance of the buttons. This image was from the logs of the USS Lackawanna and it has been renamed so it can be used by the Sacramento spreadsheet.
The problem is that creating a new button does not solve the problem. As soon as the spreadsheet with the new buttons is saved, closed and reopened, the buttons on a page following the Log Page sheet are corrupted. It the buttons are on a sheet that comes before the Log Page sheet, they are unaffected. Somehow, the presence of certain images on a sheet before the one with the buttons corrupts the buttons. I first thought it had to do with the size. This image causes a problem: $ ls -l 581208-sacramento-004-009.JPG -rw-r--r-- 1 Michael None 13332951 Mar 19 2020 581208-sacramento-004-009.JPG This image, which is larger, does not: $ ls -l 581208-lackawanna-006-059.JPG -rw-r--r-- 1 Michael None 14363824 Jan 23 2020 581208-lackawanna-006-059.JPG I have copied the Lackawanna image into an image directory, for me that is C:\tmp, as 581208-sacramento-004-010.JPG. This image directory is set on the Setup sheet in cell C5. You can then load this image by clicking on the right hand button under the Page Number button on the Log Page sheet. This will load the image number 10. If you delete the corrupt buttons on the Setup sheet and copy in new ones, you can do a save, close and reopen and see that the buttons are fine. If you reload image 9, then you will see that a close and reopen corrupts the buttons. I find, for testing, it is faster just to copy one of the buttons on the Log Page sheet onto the Setup sheet. You will find that it corrupts just like the original ones on the Setup sheet. The URL for the loaded image is given on the Setup sheet in cell C38. You can download the image 9 using that URL. The image 10 that I am attaching is really an image from the Lackawanna logs. Should you download a Sacramento image 10, it will not be the same as the one I am sending, and it will corrupt the buttons.
Created attachment 194827 [details] This image corrupts the buttons. This image is the one for USS Sacramento that does corrupt the buttons on the Setup sheet. This image, and image 10 previously sent, should be saved in a directory, and that directory should be entered in cell C5 on the Setup sheet. The two images can then be loaded into the spreadsheet using the Page Number arrows on the Log Page sheet.