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

asked 2015-11-17 11:25:55 +0200

arowland gravatar image

updated 2016-03-14 02:18:24 +0200

Alex Kemp gravatar image

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...

edit retag flag offensive close merge delete