Method: Axlsx::SheetProtection#initialize

Defined in:
lib/axlsx/workbook/worksheet/sheet_protection.rb

#initialize(options = {}) ⇒ SheetProtection

Creates a new SheetProtection instance

Parameters:

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

    a customizable set of options

Options Hash (options):

  • sheet (Boolean) —

    @see SheetProtection#sheet

  • objects (Boolean) —

    @see SheetProtection#objects

  • scenarios (Boolean) —

    @see SheetProtection#scenarios

  • format_cells (Boolean) —

    @see SheetProtection#objects

  • format_columns (Boolean) —

    @see SheetProtection#format_columns

  • format_rows (Boolean) —

    @see SheetProtection#format_rows

  • insert_columns (Boolean) —

    @see SheetProtection#insert_columns

  • insert_rows (Boolean) —

    @see SheetProtection#insert_rows

  • insert_hyperlinks (Boolean) —

    @see SheetProtection#insert_hyperlinks

  • delete_columns (Boolean) —

    @see SheetProtection#delete_columns

  • delete_rows (Boolean) —

    @see SheetProtection#delete_rows

  • select_locked_cells (Boolean) —

    @see SheetProtection#select_locked_cells

  • sort (Boolean) —

    @see SheetProtection#sort

  • auto_filter (Boolean) —

    @see SheetProtection#auto_filter

  • pivot_tables (Boolean) —

    @see SheetProtection#pivot_tables

  • select_unlocked_cells (Boolean) —

    @see SheetProtection#select_unlocked_cells

  • password. (String) —

    The password required for unlocking. @see SheetProtection#password=



29
30
31
32
33
34
 
# File 'lib/axlsx/workbook/worksheet/sheet_protection.rb', line 29

def initialize(options={})
  @objects = @scenarios = @select_locked_cells = @select_unlocked_cells = false
  @sheet = @format_cells = @format_rows = @format_columns = @insert_columns = @insert_rows = @insert_hyperlinks = @delete_columns = @delete_rows = @sort = @auto_filter = @pivot_tables = true
  @password = nil
  parse_options options
end