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

Table Data Bar

Use the Table Data bar to control the data view.

The filtered data view is active until you change or cancel the sorting or filtering criteria. If a filter is active, the Apply Filter icon on the Table Data bar is activated.

Save Record

Saves the current database table record. The Save Record icon is found on the Table Data bar.

Save Record

Edit Data

Turns the edit mode for the current database table on or off.

Edit Data

Undo

Reverses the last command or the last entry you typed. To select the command that you want to reverse, click the arrow next to the Undo icon on the Standard bar.

Undo: Data Input

Find Record

In forms or database tables, you can search through data fields, list boxes, and check boxes for specific values.

Find Record

Refresh

Refreshes the displayed data. In a multi-user environment, refreshing the data ensures that it remains current.

Refresh

Sort Order

Specifies the sort criteria for the data display.

Sort Order

Sort Ascending

Text fields are sorted alphabetically, numeric fields are sorted by number.

Sort Ascending

Sort Descending

Text fields are sorted alphabetically, number fields are sorted by number.

Sort Descending

AutoFilter

Filters the records, based on the content of the currently selected data field.

AutoFilter

Apply Filter

Switches between the filtered and unfiltered view of the table.

Apply Filter

Standard Filter

Allows you to set the filtering options.

Standard Filter

Reset Filter/Sorting

Cancels the filter settings and displays all of the records in the current table.

Reset Filter/Sorting

Data to Text

Inserts all fields of the marked record into the current document at the cursor position.

Data to Text

Data to Fields

Updates the contents of the existing database fields by the marked records. The Data to Fields icon is only available if the current document is a text document.

Data to Fields

Mail Merge

Starts the Mail Merge Wizard to create form letters.

Mail Merge

Data Source of Current Document

Displays, in the data source browser, the table that is linked to the current document.

Data Source of Current Document

Explorer On/Off

Turns on and off the view of the data source explorer. The Explorer On/Off icon is visible on the Table Data bar.

Explorer On/Off