add a button

Discuss the spreadsheet application

add a button

Postby briglia23 » Wed Jun 25, 2008 12:49 pm

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
briglia23
 
Posts: 155
Joined: Tue Jun 24, 2008 10:09 am

Re: add a button

Postby Villeroy » Wed Jun 25, 2008 1:21 pm

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, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28846
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: add a button

Postby briglia23 » Wed Jun 25, 2008 2:19 pm

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
briglia23
 
Posts: 155
Joined: Tue Jun 24, 2008 10:09 am

Re: add a button

Postby Villeroy » Wed Jun 25, 2008 2:24 pm

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, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28846
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 27 guests