Delete basic object or form

Rahzan · April 14, 2026, 6:09pm

I am on my first day on Librecalc, trying to see how bad it will be to convert my ms-excel files who have extensive VBA code and it’s not good news!
I am trying to recover from the shock of the hour, that I cannot simply delete a spurious form or object from a project. It seems that I need to write a piece of code to do a simple delete (in an environment where I haven’t even written a “hello” routine).

Is this understanding correct?

What is the outline of steps to do this delete of a form and event handlers?
I know the form’s name and there are associated event handler routines.
Thank you in advance.

Wanderer · April 14, 2026, 8:56pm

Who should know this? We know less about your capabilities than you about LibreOffice…
.
How did your “spurious form” came into existence? Generated by some vba? By you? You know about “design mode” for forms?
How did you try to delete them? Can you see the object on screen?
Do you use navigator? Context menu?

Rahzan · April 14, 2026, 9:13pm

Thanks for your comment.
It is my first day on librecalc.
I don’t know where any of the programming resources are.
The object is left over from a previous project which was was exported out but this form and its handlers were left behind. I assumed it is a simple delete, only to clean-up the file.
The response from an LLM was there is no delete-object function in librecalc, hence my asking to confirm.

The object is visible. But no visible way to delete it.

Wanderer · April 14, 2026, 9:43pm

As I avoided vba I have not much exprience here…

Try to go to the Organizer via the button. Maybe there are mor options.
As you wrote visible: You tried if there is (usually invisible) context menu? (Del-key often works also, after you marked someting.)

Then check the following:

https://help.libreoffice.org/latest/en-US/text/shared/optionen/01130100.html?&DbPAR=SHARED&System=UNIX

sokol92 · April 15, 2026, 11:01am

If you want to delete macros and user forms in an .xlsm (.xltm, .xls) file, follow the same steps as in Excel.

Open the .xlsm file in LibreOffice and save it as .xlsx (by selecting the appropriate item in the file type drop-down list).
Close and reopen the .xlsx file.

Villeroy · April 15, 2026, 4:20pm

https://bugs.documentfoundation.org/show_bug.cgi?id=90580

Rahzan · April 29, 2026, 3:18pm

Thanks.
Not knowing what the organizer is, I did not try it.
However, when I go there I see the generic Forms category but there is nothing under it, and I suppose for that same reason the Delete is grayed out.

We can call this question closed, and the LLM was likely right, in that the form is stuck in there forever, until the project is rewritten completely.
I appreciate all the efforts to help, but it is not a big deal in itself; it was just too presumptuous of a way to get me on converting the vba programming.
It seems I have to go all the way back to the beginning to learn it from the ground up, and translate the VBA as well its structure. The IDE itself seems to be the most unfamiliar part than anything within msexcel-vba.

Besides Youtube, if there are better resources to start to learn the IDE and starBasic, please refer me.