View

Defines which elements of the StarOffice Calc main window are displayed. You can also show or hide highlighting of values in tables.

Visual Aids

Specifies which lines are displayed.

Grid Lines

Specifies whether to display grid lines between the cells.

Grid Line Color

Specifies a color for the grid lines in the current document.

Page Breaks

Specifies whether to view the page breaks within a defined print area.

Guides While Moving

Specifies whether to view guides when moving drawings, frames, graphics and other objects. These guides help you align objects.

Simple Handles

Specifies whether to display the handles (the eight points on a selection box) as simple squares without 3D effect.

Large Handles

Specifies that larger than normal handles (the eight points on a selection box) are displayed.

Display

Select various options for the screen display.

Formulas

Specifies whether to show formulas instead of results in the cells.

Zero Values

Specifies whether to show numbers with the value of 0.

Note Indicator

Specifies that an inserted note is displayed when the mouse is held over the corresponding cell. A small rectangle in the top right corner of the cell indicates that a note exists and can be displayed. To display a note permanently, select the Show Note command from the cell's context menu. You can type and edit notes with the Insert - Note command. Notes that are permanently displayed can be edited by clicking the note box. Click the Navigator, and under the Notes entry you can view all notes in the current document. By double clicking a note, the cursor will jump to the corresponding cell containing the note.

Value Highlighting

Select the Value Highlighting box to highlight all values in the sheet. Text cells are highlighted in black, cells with numbers in blue, and cells containing formulas, logical values, and dates, in green. When this command is active, any colors assigned in the document will not be displayed until the function is deactivated.

Anchor

Specifies whether the anchor icon is displayed when an inserted object, such as a graphic, is selected.

Text Overflow

Specifies that, if a cell contains a larger text than the cell's width, and the cell on the right also contains data, you will see a small triangle on the right side of the cell indicating that the text continues.

Show References in Color

Specifies that each reference is highlighted in color in the formula. The cell range is also enclosed by a colored border as soon as the cell containing the reference is selected for editing.

Objects

Defines whether to display or hide objects, or use placeholders, for up to three object groups.

Objects/Graphics

Defines if objects and graphics are shown, hidden or replaced by a placeholder.

Charts

Defines if charts in your document are shown, hidden or replaced by a placeholder.

Drawing Objects

Defines if drawing objects in your document are shown, hidden or replaced by a placeholder.

Window

Specifies whether some Help elements will or will not appear in the table.

Column/Row Headers

Specifies whether to display row and column headers.

Horizontal Scroll Bar

Specifies whether to display a horizontal scroll bar at the bottom of the document window. Note that there is a slider between the horizontal scroll bar and the sheet tabs that may be set to one end.

Vertical Scroll Bar

Specifies whether to display a vertical scroll bar at the right of the document window.

Sheet Tabs

Specifies whether to display the sheet tabs at the bottom of the spreadsheet document. If this box is not selected, you can only switch between the sheets by means of the Navigator. Note that there is a slider between the horizontal scroll bar and the sheet tabs that may be set to one end.

Outline Symbols

If you have defined an outline, the Outline symbols option specifies whether to view the outline symbols at the border of the sheet.

Back to top