Class: Axlsx::ProtectedRange

Inherits:
Object
  • Object
show all
Includes:
OptionsParser, SerializedAttributes
Defined in:
lib/axlsx/workbook/worksheet/protected_range.rb

Overview

Note:

the recommended way to manage protected ranges with via Worksheet#protect_range

The Protected Range class represents a set of cells in the worksheet

See Also:

Instance Attribute Summary collapse

Instance Method Summary collapse

Methods included from SerializedAttributes

#declared_attributes, included, #serialized_attributes, #serialized_element_attributes, #serialized_tag

Methods included from OptionsParser

#parse_options

Constructor Details

#initialize(options = {}) {|_self| ... } ⇒ ProtectedRange

Initializes a new protected range object

Parameters:

  • [String] (Hash) —

    a customizable set of options

Yields:

  • (_self)

Yield Parameters:



12
13
14
15
 
# File 'lib/axlsx/workbook/worksheet/protected_range.rb', line 12

def initialize(options = {})
  parse_options options
  yield self if block_given?
end

Instance Attribute Details

#name ⇒ String

The name of the protected range

Returns:

  • (String) 


24
25
26
 
# File 'lib/axlsx/workbook/worksheet/protected_range.rb', line 24

def name
  @name
end

#sqref ⇒ String

The reference for the protected range

Returns:

  • (String) 


20
21
22
 
# File 'lib/axlsx/workbook/worksheet/protected_range.rb', line 20

def sqref
  @sqref
end

Instance Method Details

#to_xml_string(str = "") ⇒ Object

serializes the proteted range our output to that object. Use this - it helps limit the number of objects created during serialization

Parameters:

  • str (String) (defaults to: "") —

    if this string object is provided we append



42
43
44
 
# File 'lib/axlsx/workbook/worksheet/protected_range.rb', line 42

def to_xml_string(str = "")
  serialized_tag 'protectedRange', str
end