Form Controls
The Form Controls toolbar contains tools that you need to create an interactive form. You can use the toolbar to add controls to a form in a text, spreadsheet, presentation, or HTML document, for example a button that runs a macro.
XML-vormidokumendid (XForms) kasutavad samu juhtelemente.
To create a form, open a document and use the Form Controls toolbar to add and define the form controls. If you want, you can also link the form to a database, so that you can use the controls to manipulate a database.
When you create a form in an HTML document, you can use the form to send data over the Internet.
LibreOffice only exports the form properties that are supported by the HTML version that you export to. To specify the HTML version, choose LibreOffice - PreferencesTools - Options - Load/Save - HTML Compatibility.
Juhtelemendi lisamiseks dokumendile
-
On the Form Controls toolbar, click the icon of the control that you want to add.
-
Juhtelemendi loomiseks vea dokumendis hiirega selle piirjooned.
Ruudukujulise juhtvälja loomiseks tuleb vedamise ajal all hoida klahvi Shift.
To add a field from the field list of a table or query to a form, drag a cell into the form. In a text document, you can also drag a column header to add a field to a form. To include a label for the field, hold down the CommandCtrl+Shift key down when you drag a column head.
Juhtelemendi muutmine
-
Right-click the control and choose Control. A dialog opens where you can define the properties of the control.
-
To specify a accelerator key for a control, add a tilde (~) in front of the character in the label for the control.
-
You can drag and drop controls from one document to another document. You can also copy and paste controls between documents. When you insert a control from another document, LibreOffice analyzes the data source, content type, and content properties of the control so that the control fits the logical structure in the target document. For example, a control that displays contents from an address book continues to display the same contents after you copy the control to a different document. You can view these properties on the Data tab page of the Form properties dialog.
Select
This icon switches the mouse pointer to the select mode, or deactivates this mode. The select mode is used to select the controls of the current form.
Check Box
Creates a check box. Check boxes allow you to activate or deactivate a function in a form.
Text Box
Creates a text box. Text boxes are fields in which the user can enter text. In a form, text boxes display data or allow for new data input.
Formatted Field
Creates a formatted field. A formatted field is a text box in which you can define how the inputs and outputs are formatted, and which limiting values apply.
A formatted field has special control properties (choose Format - Control).
Push Button
Creates a push button. This function can be used to execute a command for a defined event, such as a mouse click.
You can apply text and graphics to these buttons.
Option Button
Creates an option button. Option buttons enable the user to choose one of several options. Option buttons with the same functionality are given the same name (Nameproperty). Normally, they are given a group box.
List Box
Creates a list box. A list box lets users select an entry from a list. If the form is linked to a database and the database connection is active, the List Box Wizard will automatically appear after the list box is inserted in the document. This wizard helps you create the list box.
Combo Box
Creates a combo box. A combo box is a single-line list box with a drop-down list from which users choose an option. You can assign the "read-only" property to the combo box so that users cannot enter other entries than those found in the list. If the form is bound to a database and the database connection is active, the Combo Box Wizard will automatically appear after you insert the combo box in the document.
Label Field
Creates a field for displaying text. These labels are only for displaying predefined text. Entries cannot be made in these fields.
Veel juhtelemente
Avab tööriistariba Veel juhtelemente.
Vormi koostamine
Avab tööriistariba Vormi koostamine.
Nõustajad sees/väljas
Lülitab vormi juhtelementide koostamise nõustajate automaatse ilmumise sisse või välja.
Need nõustajad aitavad kirjeldada loendibokside, tabelite ja teiste juhtelementide omadusi.
Context Menu Commands
Kerimisnupp
Loob kerimisnupu.
Kui lisada kerimisnupp Calc'i arvutustabelile, saab kaardi Andmed abil luua kahesuunalise lingi kerimisnupu ja arvutustabeli lahtri vahel. Kui muuta lahtri sisu, uuendatakse kerimisnupu väärtust. Samuti muutub kerimisnupu väärtuse muutmisel ka lahtri sisu.
Kerimisriba
Loob kerimisriba.
Kerimisribale saab määrata järgnevaid omadusi:
|
Nimi |
Semantika |
|
Min. kerimisväärtus |
Määrab kerimisriba vähima kõrguse või laiuse. |
|
Maks. kerimisväärtus |
Määrab kerimisriba suurima kõrguse või laiuse. |
|
Kerimisriba vaikeväärtus |
Määrab kerimisriba vaikeväärtuse, mida kasutatakse vormi lähtestamisel. |
|
Suund |
Määrab kerimisriba suuna: vertikaalne või horisontaalne. |
|
Väike muudatus |
Määrab vähima suuruse, mille võrra saab kerimisriba kerida, näiteks klõpsates kerimisriba noolel. |
|
Suur muudatus |
Määrab suuruse, mille võrra saab kerimisriba kerida suurte sammudega, näiteks klõpsates kerimisriba liuguri ja noole vahelisel alal. |
|
Viivitus |
Määrab viivituse millisekundites kerimisriba muutvate sündmuste vahel. Seda viivitust kasutatakse näiteks siis, kui klõpsata kerimisriba noolel ja hoida hiirenuppu all. |
|
Sümboli värv |
Määrab kerimisriba noolte värvi. |
|
Nähtav suurus |
Määrab kerimisriba liuguri suuruse "väärtusühikutes". Näiteks väärtuse ("Maks. kerimisväärtus" miinus "Min. kerimisväärtus") / 2 korral hõlmab liugur poole kerimisribast. Võrdse kõrguse ja laiusega kerimisriba loomiseks tuleb nähtav suurus võrdsustada nulliga. |
Calc'i arvutustabelis saab kaardi Andmed abil luua kahesuunalise lingi kerimisriba ja lahtri vahele.
Image Button
Creates a button displayed as an image. Aside from the graphic representation, an image button has the same properties as a "normal" button.
Image Control
Creates an image control. It can only be used to add images from a database. In the form document, double-click one of these controls to open the Insert Graphic dialog to insert the image. There is also a context menu (not in design mode) with commands for inserting and deleting the image.
Images from a database can be displayed in a form, and new images can be inserted in the database as long as the image control is not write-protected. The control must refer to a database field of the image type. Therefore, enter the data field into the properties window on the Data tab page.
Date Field
Creates a date field. If the form is linked to a database, the date values can be adopted from the database.
If you assign the "Dropdown" property to the date field, the user can open a calendar to select a date under the date field. This also applies to a date field within a Table Control field.
Date fields can be easily edited by the user with the up arrow and down arrow keys. Depending on the cursor position, the day, month, or the year is can be increased or decreased using the arrow keys.
Specific Remarks on Date Fields.
Time Field
Creates a time field. If the form is linked to a database, the time values for the form can be adopted from the database.
Time fields can be easily edited by the user with the up and down arrow keys. Depending on the cursor position, the hours, minutes, or the seconds are increased or decreased using the arrow keys.
File Selection
Creates a button that enables file selection.
Numerical Field
Creates a numerical field. If the form is linked to a database, the numerical values in the form can be adopted from the database.
Currency Field
Creates a currency field. If the form is linked to a database, the currency field contents for in the form can be adopted from the database.
Pattern Field
Creates a pattern field. Pattern fields consist of an edit mask and a literal mask. The edit mask determines which data can be entered. The literal mask determines the contents of the pattern field when loading the form.
Please note that pattern fields are not exported into HTML format.
Group Box
Creates a frame to visually group several controls. Group boxes allow you to group option buttons in a frame.
If you insert a group frame into the document, the Group Element Wizard starts, which allows you to easily create an option group.
Note: When you drag a group box over already existing controls and then want to select a control, you have to first open the context menu of the group box and choose Arrange - Send to Back. Then select the control while pressing CommandCtrl.
Group boxes are used only for a visual effect. A functional grouping of option fields can be made through the name definition: under the Name properties of all option fields, enter the same name in order to group them.
Table Control
Creates a table control to display a database table. If you create a new table control, the Table Element Wizard appears.
Special information about Table Controls.
Navigeerimisriba
Loob navigatsiooniriba.
Navigeerimisriba võimaldab liikuda andmebaasi või andmebaasi vormi kirjete hulgas. Navigeerimisriba juhtelemendid töötavad samamoodi, nagu tavalise LibreOffice'i navigeerimisriba omad.
Automatic Control Focus
If Automatic Control Focus is activated, the first form control will be selected when you open the document. If the button is not activated, the text will be selected after opening. The Tab Order that you have specified determines which is the first form control.