Description

class Axlsx::SheetView
Note:

The recommended way to manage the sheet view is via Worksheet#sheet_view

View options for a worksheet.

Creates a new Axlsx::SheetView object

Parameters:

  • options (Hash) (defaults to: {})

    a customizable set of options

Options Hash (options):

  • color_id (Integer)

    Color Id

  • default_grid_color (Boolean)

    Default Grid Color

  • right_to_left (Boolean)

    Right To Left

  • show_formulas (Boolean)

    Show Formulas

  • show_grid_lines (Boolean)

    Show Grid Lines

  • show_outline_symbols (Boolean)

    Show Outline Symbols

  • show_row_col_headers (Boolean)

    Show Headers

  • show_ruler (Boolean)

    Show Ruler

  • show_white_space (Boolean)

    Show White Space

  • show_zeros (Boolean)

    Show Zero Values

  • tab_selected (Boolean)

    Sheet Tab Selected

  • top_left_cell (String, Cell)

    Top Left Visible Cell

  • view (Symbol)

    View Type

  • window_protection (Boolean)

    Window Protection

  • workbook_view_id (Integer)

    Workbook View Index

  • zoom_scale (Integer)
  • zoom_scale_normal (Integer)

    Zoom Scale Normal View

  • zoom_scale_page_layout_view (Integer)

    Zoom Scale Page Layout View

  • zoom_scale_sheet_layout_view (Integer)

    Zoom Scale Page Break Preview

Adds a new selection param [Symbol] pane param [Hash] options return [Selection]

Color Id Index to the color value for row/column text headings and gridlines. This is an 'index color value' (ICV) rather than rgb value. default nil

The pane object for the sheet view

Yields:

  • (@pane)

A hash of selection objects keyed by pane type associated with this sheet view.

Serializes the data validation

Parameters:

  • str (String) (defaults to: '')

Top Left Visible Cell Location of the top left visible cell Location of the top left visible cell in the bottom right pane (when in Left-to-Right mode). default nil

View Type Indicates the view type. Options are

* normal: Normal view
* page_break_preview: Page break preview
* page_layout: Page Layout View

default :normal

Workbook View Index Zero-based index of this workbook view, pointing to a workbookView element in the bookViews collection. default 0

Zoom Scale Window zoom magnification for current view representing percent values. This attribute is restricted to values ranging from 10 to 400. Horizontal & Vertical scale together. Current view can be Normal, Page Layout, or Page Break Preview. default 100

Zoom Scale Normal View Zoom magnification to use when in normal view, representing percent values. This attribute is restricted to values ranging from 10 to 400. Horizontal & Vertical scale together. Applies for worksheets only; zero implies the automatic setting. default 0

Zoom Scale Page Layout View Zoom magnification to use when in page layout view, representing percent values. This attribute is restricted to values ranging from 10 to 400. Horizontal & Vertical scale together. Applies for worksheets only; zero implies the automatic setting. default 0

Zoom Scale Page Break Preview Zoom magnification to use when in page break preview, representing percent values. This attribute is restricted to values ranging from 10 to 400. Horizontal & Vertical scale together. Applies for worksheet only; zero implies the automatic setting. default 0

SheetView is referenced in 0 repositories