How to use the Form Property?

Creating and using forms
Post Reply
uu4
Posts: 7
Joined: Sun Jul 12, 2015 5:08 am

How to use the Form Property?

Post by uu4 »

Many people are having great difficulties using the Form Property in order to acquire or submit data to and from Calc.

Even in thie Base forum, I found so many related questions.

Answers are rarely found in Help menu or in this board.

Please help us find the simple and quick solution by using the following example:

(1)
Image

Desired outcome: Click one of the buttons and show the selected data in the blue area (A11:C11)

Question: I don't know what to enter in URL field


(2)
Image

In this DATA tab, there are so many fields for which there are no tutorials or specific help menu.

Question: How can I acquire the button-selected data using this Form Property window?


Essential Issue: I would like to show the button-selected data in the specified field in Calc window
WITHOUT using VBA.

Reason: For security reason, macro is prohibited in my environment.


Thank you for your help.
OpenOffice 4.1.1 on Windows 7
F3K Total
Volunteer
Posts: 1038
Joined: Fri Dec 16, 2011 8:20 pm

Re: How to use the Form Property?

Post by F3K Total »

Hi,
find attached an example using Option Buttons.
R
Attachments
Select.ods
(12.82 KiB) Downloaded 230 times
  • MMove 1.0.6
  • Extension for easy, exact positioning of shapes, pictures, controls, frames ...
  • my current system
  • Windows 10 AOO, LOLinux Mint AOO, LO
uu4
Posts: 7
Joined: Sun Jul 12, 2015 5:08 am

Re: How to use the Form Property?

Post by uu4 »

Thank you for your help.

I didn't know how to handle checkbox because the result returned by the checkbox was non-numeric
and could not cite other location.

I appreciate your easy to understand teaching file.
Thank you again.
OpenOffice 4.1.1 on Windows 7
Post Reply