Bug 140862 - Custom button control shown when file is saved, not shown when re-opened, still listed in Form Navigator
Summary: Custom button control shown when file is saved, not shown when re-opened, sti...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.0.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-03-07 16:22 UTC by Kevin Knerr
Modified: 2022-03-18 16:13 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Kevin Knerr 2021-03-07 16:22:37 UTC
Description:
I create a custom button to run a macro. The button is shown and works throughout the session. The next time I open the file, the button cannot be seen. I change to design mode and open the form navigator. The button is listed with all its properties intact. In particular, it is enabled and visible, but it is not shown anywhere in the file. Additionally, it cannot be deleted via the Form Navigator. Using "cut" ghosts the control, but it cannot be pasted and cannot be deleted that way either.

Steps to Reproduce:
1. Create a button
2. Save the file and close it
3. Open the file - the button is gone
4. Go to design mode and open the Form Navigator - the button is still listed

Actual Results:
My custom control was not shown, and could not be invoked by any method

Expected Results:
The button is exactly where I placed it, visible, and functioning


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Version: 7.1.1.2 / LibreOffice Community
Build ID: 10(Build:2)
CPU threads: 4; OS: Linux 5.11; UI render: default; VCL: kf5
Locale: en-US (en_US.utf8); UI: en-US
7.1.1-1
Calc: threaded

Button was created at least a year ago and was still working in LO 7.0.3 (Arch package libreoffice-fresh-7.0.3-2-x86_64) The button disappeared after upgrading to 7.1.0. I found what appeared to be related bugs, so I waited for the 7.1.1 package in Arch, but the old button was still missing. I created a new button which worked until I closed the file. After opening the next time, the new button was also missing. Both versions are listed in the Form Navigator, but I can't make them visible or delete them. While I could recreate the button each time, I don't want to pollute my file with dozens of copies of the button. Yes, I can run the macro via the dialog, but it's a hassle with the number of clicks required to get to the macro I want (which is the ONLY macro in this file...)
Comment 1 Buovjaga 2022-03-07 08:58:47 UTC
I added a push button to a blank Calc file, saved and reloaded, but the button was still there. Please test with 7.3.

Arch Linux 64-bit
Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: 66a9795f27fda887d9f66d0d8bb196fd636fe452
CPU threads: 8; OS: Linux 5.16; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded Jumbo
Built on 7 March 2022

Set to NEEDINFO.
Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED WORKSFORME, if the problem went away.
Comment 2 Kevin Knerr 2022-03-18 15:37:33 UTC
Current version: 7.3.1.3 (Arch package libreoffice-fresh-7.3.1-1-x86_64)

At this time, the new button is preserved correctly upon reopening the saved file.

The original button is still listed in the form navigator but is still not visible or deletable. I've tried adjusting position and size properties to ensure it isn't just hidden behind the new button (even though button #1 was actually larger than button #2).

At this point, I'm treating the old control as a broken relic that I can't remove without recreating this file from scratch.

Since new buttons aren't broken, I believe this bug was corrected since the initial report.

Thanks!