add a button

Discuss the spreadsheet application
Post Reply
briglia23
Posts: 155
Joined: Tue Jun 24, 2008 10:09 am

add a button

Post by briglia23 »

Is possible to insert a button in a cell of a document?
If is it possible how can i make?
Thank you
OOo 2.3.X on openSuse 10
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: add a button

Post by Villeroy »

Insert>Hyperlink...
Further settings:Form:[Button]

Basically the hyperlink dialog creates the same URL-button like this procedure:
View>Toolbars>Form Controls
Turn on edit mode (2nd button)
Draw a button
Control properties:Action:Open URL, URL:<some ur>, Label:<some label>
Turn off edit mode (2nd button)

Buttons are extremely inflexible. They are difficult to change and they behave badly with sorted and filtered cells. In spreadsheets I prefer formatted hyperlinks where the cell itself is the button.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
briglia23
Posts: 155
Joined: Tue Jun 24, 2008 10:09 am

Re: add a button

Post by briglia23 »

Thank you so much.
But i not understand very well.
The button is created but now i have another problem.

How I can make in order to make to execute a macro when I press the push-button as soon as created?
OOo 2.3.X on openSuse 10
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: add a button

Post by Villeroy »

View>Toolbars>Form Controls
Turn on edit mode (2nd button)
Right-click the button, control properties:tab "Events"
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply