Description: Updated to 24.2.3 from 7.6.6. There are some conditions in which a duplicate push button appears in spreadsheet. Contents of the spreadsheet are such that it cannot be shared. Will describe as best I can. Near the upper left of spreadsheet is a push button control that runs a macro. Upon moving the mouse cursor over the button a duplicate button appears a couple inches directly below. Hovering the mouse cursor over the button while the macro is running causes the duplicate button to flicker. Suspect that is in some way related to "Do Events" statements in the macro. Changing a cell prior to pointing at the button prevents the duplicate from appearing. Was going to provide a screan capture (still or video) but without the contents near the button, the duplicate does not appear. Some other spreadsheets with push botton controls do not exhibit this behavior. Don't know the underlying cause and can't reproduce in a shareable way to be investigated. Steps to Reproduce: 1. Open Calc workbook 2. Do not make any changes 3. Point at push button control Actual Results: Duplicate push button control appears a couple inches directly below. Expected Results: No duplicate push button control appearing. Reproducible: Always User Profile Reset: No Additional Info: Don't know whether to classify as happens every time or sometimes because in the workbooks where it happens it's consistently every time. But in workbooks where it doesn't happen it consistently never happens. Since for the case being reported it's every time. I'll leave it at that. Version: 24.2.3.2 (X86_64) / LibreOffice Community Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba CPU threads: 8; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
Another data point. Seems to be sensitive to selected cell location when saved. Doesn't happen if the selected cell is near upper left. i.e. near the button. But if below say where the duplicate would appear then it does. Have not been able thus far to reproduce in a new workbook.
One by one deleted all the other sheets from the workbook. Continued to happen until the last other sheet was deleted. No charts buttons etc. on last several sheets deleted. Did not resume the behavior after adding in a new sheet. All the sheets where originally created with MSO 2013 Pro Plus Excel. Been using and saving as LibreOffice 7.x.x since March 2023. Behavior began with update to 24.2.3. In some other workbooks created from scratch in LibreOffice 7.5.x (March 2023) the duplicate push button does not appear.
Please test enabling Menu/Tools/Options/LibreOffice/View - Graphics Output - Force Skia software rendering
(In reply to m_a_riosv from comment #3) > Please test enabling > Menu/Tools/Options/LibreOffice/View - Graphics Output - Force Skia software > rendering No impact. Duplicate push button still appears.
So please attach a file with the macro, to test.
(In reply to m_a_riosv from comment #5) > So please attach a file with the macro, to test. Have no sharable file that exhibits the issue.
Created attachment 193959 [details] Figured out out how to reproduce issue in a new document Steps to reproduce issue. 1. Create new "OpenDocument Spreadsheet" 2. Duplicate "Sheet1" to "Sheet2" 3. Select "Sheet2" 4. Insert a push button control near upper left (Menu - Insert - Form Control - Push Button) 5. Exit Design Mode (Esc) 6. Freeze row below (a row or two) where the push button control is located 7. Select a cell at least one row below the row freeze 8. Save & close LibreOffice 9. Open 10. Do NOT make any changes. Not even so much as scrolling or changing sheets. 11. Point mouse cursor at the push button. A duplicate push button appears directly below the original. Some observations: Must be at least 2 sheets. Rows must be frozen below the push button. If a column is also frozen the issue does not occur. Scrolling prevents the issue from occurring. Changing a cell contents prevents issue from occurring. Changing between sheets prevents issue from occurring. Seems to be quite a few conditions at play. Pretty sure someone will be able to track it down with this. Version: 24.2.3.2 (X86_64) / LibreOffice Community Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba CPU threads: 8; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
Not reproducible Version: 24.2.3.2 (X86_64) / LibreOffice Community Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: default; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Reproducible (already with 24.2.0.1) - cf. the attached .gif recording. Version: 24.2.3.2 (X86_64) / LibreOffice Community Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba CPU threads: 8; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: en-US (pl_PL); UI: en-US Calc: threaded
Created attachment 193974 [details] duplication of a push button
Created attachment 193977 [details] Screen record
Created attachment 193978 [details] Duplicate Push Button - Screen Capture Screen capture of duplicate push button. Entire process. Including file creation.
Also reproducible on Windows 7 (as of LO version 24.2.0.1) Version: 24.2.3.2 (X86_64) / LibreOffice Community Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: en-US (pl_PL); UI: en-US Calc: CL threaded
Have you tried to update your graphics from the vendor? What is the screen resolution?
(In reply to m_a_riosv from comment #14) > Have you tried to update your graphics from the vendor? > > What is the screen resolution? The latest OEM graphics driver already installed. Display resolution is 1920 x 1080 Issue is the same for both the latest OEM and vendor graphics driver. Intel(R) Iris(R) Xe Graphics Acer: Driver Provider: Intel Corporation Driver Date: 2/18/2022 Driver Version: 30.0.101.1404 Intel: Driver Provider: Intel Corporation Driver Date: 4/20/2024 Driver Version: 31.0.101.5445 Device name NOYB Processor 11th Gen Intel(R) Core(TM) i5-1135G7 @ 2.40GHz 2.42 GHz Installed RAM 8.00 GB (7.78 GB usable) Device ID x Product ID x System type 64-bit operating system, x64-based processor Pen and touch No pen or touch input is available for this display Edition Windows 11 Pro Version 23H2 Installed on 2/27/2023 OS build 22631.3447 Experience Windows Feature Experience Pack 1000.22688.1000.0 Manufacturer Acer It's a pretty vanilla machine.
Even with your resolution, I can not able to reproduce. Let's see if someone else can reproduce the issue.
(In reply to NOYB from comment #4) > (In reply to m_a_riosv from comment #3) > > Please test enabling > > Menu/Tools/Options/LibreOffice/View - Graphics Output - Force Skia software > > rendering > > No impact. Duplicate push button still appears. If you can, please try the following: 0. Save all your work. 1. In Menu Tools > Options > LibreOffice > View > (Graphic Output) 1.1 Uncheck / DISABLE the check box named "Use Skia for all rendering". 2. When you press OK in the Options dialog, you will be presented with a button, asking to restart LO. Press that button to allow it. 3. A few seconds later, LO will restart. Go again to the same Options menu and review that indeed the aforementioned checkbox is still unchecked / DISABLED (because there have been cases in which the setting does not prevail). Take note of this and get out of the Options dialog. 4. Now proceed to perform the original test to replicate the problematic behavior with the insertion of the push button. 5. Go to menu Help > About and copy the new information to the clipboard, so you can paste it in your next comment here. It is expected that at least 1 item should be different (Skia vs Default). Please don't change any options / settings before copying this version information. 5. Please report the result of this new test in a new comment here, and paste the new version information in the same new comment. 6. Now you can revert the "Use Skia for all rendering" checkbox to what it was before this new test.
(In reply to ady from comment #17) > (In reply to NOYB from comment #4) > > (In reply to m_a_riosv from comment #3) > > > Please test enabling > > > Menu/Tools/Options/LibreOffice/View - Graphics Output - Force Skia software > > > rendering > > > > No impact. Duplicate push button still appears. > > If you can, please try the following: > > 0. Save all your work. > 1. In Menu Tools > Options > LibreOffice > View > (Graphic Output) > 1.1 Uncheck / DISABLE the check box named "Use Skia for all rendering". > ... It is expected that at least 1 item should be different (Skia vs Default). When unchecking (disabling) "Use Skia for all rendering", the "Use hardware acceleration box is automatically changed from unchecked (disabled) to checked (enabled). But this does not seem to have any effect on the issue either. Version: 24.2.3.2 (X86_64) / LibreOffice Community Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba CPU threads: 8; OS: Windows 10.0 Build 22631; UI render: default; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded No change in issue behavior.
(In reply to m_a_riosv from comment #16) > Even with your resolution, I can not able to reproduce. > > Let's see if someone else can reproduce the issue. In your video I see there is an "AcT rDB rPT RH" tool bar. The issue is sensitive to a currently unknown scope of changes. ex: scrolling, resizing window, switching between sheets, etc. Maybe a plugin, extension etc is preventing the issue from occurring. Do you have a "clean" system or VM you can test a vanilla setup with.
They are toolbar customization. In safe mode the same result, not issue.
(In reply to m_a_riosv from comment #20) > They are toolbar customization. > > In safe mode the same result, not issue. But can you test on a fresh clean system with vanilla setup?
My setup: - screen resolution 1920 x 1080 - graphics: Intel(R) Iris(R) Xe driver up to date ---------------- I also experience the "twin" button by doing the following: 1. create a new Calc document 2. insert a push button 3. freeze a row below the control 4. turn the design mode off 5. hover over the control Again, it happens as of LO 24.2.0.1 - see please the attached .gif recording (7.6.6.3 on the left, 24.2.3.2 on the right).
Created attachment 194028 [details] Behaviour in 7.6.6.3 and 24.2.3.2
@Nutka, could you please follow the steps from comment 17 and report back? In the meantime, I am setting this report to NEW, since more than 1 user can replicate the problem.
(In reply to ady from comment #24) > @Nutka, could you please follow the steps from comment 17 and report back? The problem still persists (either for the steps described by @NOYB or by me).
Created attachment 194033 [details] repetitive variation with only one sheet I can also reproduce issue with nutka's method and this repetitive variation with only one sheet. See attached screen recording video. 1. Open document. 2. Freeze a rows below where push button will be placed. 3. Enter Design Mode. 4. Insert push button above row freeze. 5. Exit Design Mode. 6. Twin button appears. 7. Enter Design Mode. 8. Delete push button Repeat steps 4 - 8
Created attachment 194034 [details] with column freeze Some more observations. The twin button appears the same distance below the row freeze as the original distance from top of sheet. Happens also with column freeze, but depending on positioning may be hidden. See attached screen image capture.