Ask Your Question

how do i create buttons that link to calc files? [closed]

asked 2014-02-04 15:57:45 +0200

fldynamatic gravatar image

updated 2020-08-06 22:17:54 +0200

Alex Kemp gravatar image


I am trying to create buttons which once clicks open up another calc file. I tried to use the form designer. I cannot get the labels to be renamed to what I need them to. I need to simply create a button, have text on the button called fred and once clicked, it will open up fred's calc file. It appears that the form designer has never been tested within calc?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 06:37:31.514078

1 Answer

Sort by » oldest newest most voted

answered 2014-02-04 18:22:39 +0200

Regina gravatar image

You can use the hyperlink dialog Insert > Hyperlink. Use type 'Document'. In the upper part you can select the file. And in the lower part chose 'Button' from list 'Form' in part 'Further settings'.

edit flag offensive delete link more


Thanks - Idid that but nothing happens when I press the button

fldynamatic gravatar imagefldynamatic ( 2014-02-05 12:08:23 +0200 )edit

When you have newly created the button, you are still in Design mode. You have green handles, when you are in Design mode and you can resize the button and move it around. When you save and reload the document, it will no longer be in Design mode but in User mode and you can preform the action. Alternatively to save/reload you can open the toolbar "Form Design" and toggle between Design and User mode with the icon second from left.

Regina gravatar imageRegina ( 2014-02-05 13:56:42 +0200 )edit

great - thanks!

fldynamatic gravatar imagefldynamatic ( 2014-02-05 16:06:21 +0200 )edit

Question Tools

1 follower


Asked: 2014-02-04 15:57:45 +0200

Seen: 570 times

Last updated: Feb 04 '14