Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How do you move an existing push button on the face of a worksheet?

LibreOffice Calc 5.0.3.2

I have a push button on the face of a worksheet that runs a macro. After I inserted a column, it is in the wrong place so I need to move it without running the macro.

On the Form Design toolbar I select Design Mode. If I do that, the button becomes invisible to mouse clicks, i.e. a click selects the cell beneath it, and the right-click menu is the cell menu that does not contain Control Properties. On the Form Controls toolbar, all the controls are greyed out.

As this is not the behaviour described in the documentation, I presume it is a bug. Can anyone confirm that, or tell me what I am doing wrong?

I found this workaround: On the Form Design toolbar, I activate Design Mode then choose Form Navigator. From there I am able to select the button, access its properties and change the X co-ordinate to move it to the right manually (bit of trial and error to get it where I want it). Would be a bit difficult to identify the button if there were lots on the sheet, but luckily there is just to one! But it should be possible to just drag it...

How do you move an existing push button on the face of a worksheet?

LibreOffice Calc 5.0.3.2

I have a push button on the face of a worksheet that runs a macro. After I inserted a column, it is in the wrong place so I need to move it without running the macro.

On the Form Design toolbar I select Design Mode. If I do that, the button becomes invisible to mouse clicks, i.e. a click selects the cell beneath it, and the right-click menu is the cell menu that does not contain Control Properties. On the Form Controls toolbar, all the controls are greyed out.

As this is not the behaviour described in the documentation, I presume it is a bug. Can anyone confirm that, or tell me what I am doing wrong?

I found this workaround: On the Form Design toolbar, I activate Design Mode then choose Form Navigator. From there I am able to select the button, access its properties and change the X co-ordinate to move it to the right manually (bit of trial and error to get it where I want it). Would be a bit difficult to identify the button if there were lots on the sheet, but luckily there is just to one! But it should be possible to just drag it...