Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Edit Fields

Opens a dialogue box in which you can edit the properties of a field. Click in front of a field, and then choose this command. In the dialogue box, you can use the arrow buttons to move to the previous or the next field.

You can also double-click a field in your document to open the field for editing.

To access this command...

Choose Edit - Fields

To change the view between field names and field contents in your document, choose View - Field Names.

If you select a DDE link in your document, and then choose Edit - Fields, the Edit Links dialogue box opens.

If you click in front of a "sender" type field, and then choose Edit - Fields, the User data dialogue box opens.

Type

Lists the type of field that you are editing.

The following dialogue box elements are only visible when the corresponding field type is selected.

Select

Lists the field options, for example, "fixed". If you want, you can click another option for the selected field type.

Format

Select the format for the content of the field. For date, time and user-defined fields, you can also click "Additional formats" in the list, and then choose a different format. The formats that are available depend on the type of field that you are editing.

Offset

Displays the offset for the selected field type, for example, for "Next Page," "Page Numbers" or "Previous Page". If you want, you can enter a new offset value which will be added to the displayed page number.

If you want to change the actual page number and not the displayed number, do not use the Offset value. To change page numbers, read the Page Numbers guide.

Level

Change the defined values and outline levels for the "Chapter" field type.

Name

Displays the name of a field variable. If you want, you can enter a new name.

Value

Displays the current value of the field variable. If you want, you can enter a new value.

Fixed content

Inserts the field as static content, that is, the field cannot be updated.

Condition

Displays the condition that must be met for the field to be activated. If you want, you can enter a new condition.

Then, Else

Change the field contents that are displayed depending on whether the field condition is met or not.

Macro

Opens the Macro Selector, in which you can choose the macro that will run when you click the selected field in the document. This button is only available for the "Execute macro" function field.

Reference

Insert or modify the reference text for the selected field.

Macro name

Displays the name of the macro assigned to the selected field.

Placeholder

Displays the placeholder text of the selected field.

Insert Text

Displays the text that is linked to a condition.

Formula

Displays the formula of a formula field.

Invisible

Hides the field contents in the document. The field is inserted as a thin gray mark in the document. This option is only available for the "Set Variable" and "User Field" field types.

Apply

Adds the user-defined field to the Select list.

Apply

Delete

Removes the user-defined field from the select list. You can only remove fields that are not used in the current document. To remove a field that is used in the current document from the list, first delete all instances of the field in the document, and then remove it from the list.

Delete

Database selection

Select a registered database that you want to insert the selected field from. You can also change the table or query that the selected field refers to.

Record number

Displays the database record number that is inserted when the condition specified for the "Any record" field type is met.

Left Arrow

Jumps to the previous field of the same type in the document. This button is only active when a document contains more than one field of the same type.

Previous Field

Right Arrow

Jumps to the next field of the same type in the document. This button is only active when a document contains more than one field of the same type.

Next Field