IBM Lotus Symphony


Setting view preferences for Lotus Symphony Spreadsheets

Defines which elements of the IBM® Lotus® Symphony™ Spreadsheets main window are displayed. You can also show or hide highlighting of values in tables.

To access this command...
Choose File > Preferences > Symphony > Lotus Symphony Spreadsheets > View

Visual aids

Grid lines

Specifies whether to display grid lines between the cells. In IBM Lotus Symphony Spreadsheets, for printing, choose Layout - Properties - Page Properties - Sheet and mark the Grid check box.

Color

Specifies a color for the grid lines in the current document. To see the grid line color that was saved with the document, go to File > Preferences > Symphony > Color Scheme > Spreadsheet tab, set the color to "Default" in Grid lines box.

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

Formulas

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

Zero values

Specifies whether to show numbers with the value of 0.

Comment indicator

Specifies that a small rectangle in the top right corner of the cell indicates that a comment exists.

Value highlighting

Mark 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, dates, and so on, in green.

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 or 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 and 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 checked, you will only be able to switch between the sheets through 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.

Zoom

If you want all sheets are shown with the same zoom factor, select Synchronize sheets.

Product Feedback | Additional Documentation | Trademarks