Class: Axlsx::FilterColumn

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

Overview

The filterColumn collection identifies a particular column in the AutoFilter range and specifies filter information that has been applied to this column. If a column in the AutoFilter range has no criteria specified, then there is no corresponding filterColumn collection expressed for that column.

Constant Summary collapse

FILTERS =

Allowed filters

[:filters]

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(col_id, filter_type, options = {}) {|@filter| ... } ⇒ FilterColumn

Note:

This class yeilds its filter object as that is where the vast majority of processing will be done

Creates a new FilterColumn object

Parameters:

  • col_id (Integer|Cell)

    The zero based index for the column to which this filter will be applied

  • filter_type (Symbol)

    The symbolized class name of the filter to apply to this column.

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

    options for this object and the filter

  • [Boolean] (Hash)

    a customizable set of options

Yields:


18
19
20
21
22
23
24
25
# File 'lib/axlsx/workbook/worksheet/auto_filter/filter_column.rb', line 18

def initialize(col_id, filter_type, options = {})
  RestrictionValidator.validate 'FilterColumn.filter', FILTERS, filter_type
  #Axlsx::validate_unsigned_int(col_id)
  self.col_id = col_id
  parse_options options
  @filter = Axlsx.const_get(Axlsx.camel(filter_type)).new(options)
  yield @filter if block_given?
end

Instance Attribute Details

#col_idInteger

Zero-based index indicating the AutoFilter column to which this filter information applies.

Returns:

  • (Integer)

34
35
36
# File 'lib/axlsx/workbook/worksheet/auto_filter/filter_column.rb', line 34

def col_id
  @col_id
end

#filterObject (readonly)

The actual filter being dealt with here This could be any one of the allowed filter types


38
39
40
# File 'lib/axlsx/workbook/worksheet/auto_filter/filter_column.rb', line 38

def filter
  @filter
end

Instance Method Details

#apply(row, offset) ⇒ Object

Apply the filters for this column filtered.

Parameters:

  • row (Array)

    A row from a worksheet that needs to be


67
68
69
# File 'lib/axlsx/workbook/worksheet/auto_filter/filter_column.rb', line 67

def apply(row, offset)
  row.hidden = @filter.apply(row.cells[offset+col_id.to_i])
end

#hidden_buttonBoolean

Flag indicating whether the AutoFilter button for this column is hidden.

Returns:

  • (Boolean)

50
51
52
# File 'lib/axlsx/workbook/worksheet/auto_filter/filter_column.rb', line 50

def hidden_button
  @hidden_button ||= false
end

#hidden_button=(hidden) ⇒ Boolean

Parameters:

  • hidden (Boolean)

    Flag indicating whether the AutoFilter button for this column is hidden.

Returns:

  • (Boolean)

72
73
74
75
# File 'lib/axlsx/workbook/worksheet/auto_filter/filter_column.rb', line 72

def hidden_button=(hidden)
  Axlsx.validate_boolean hidden
  @hidden_button = hidden
end

#show_buttonBoolean

Flag indicating whether the filter button is visible. When the cell containing the filter button is merged with another cell, the filter button can be hidden, and not drawn.

Returns:

  • (Boolean)

44
45
46
# File 'lib/axlsx/workbook/worksheet/auto_filter/filter_column.rb', line 44

def show_button
  @show_button ||= true
end

#show_button=(show) ⇒ Boolean

Flag indicating whether the AutoFilter button is show. This is undocumented in the spec, but exists in the schema file as an optional attribute.

Parameters:

  • show (Boolean)

    Show or hide the button

Returns:

  • (Boolean)

82
83
84
85
# File 'lib/axlsx/workbook/worksheet/auto_filter/filter_column.rb', line 82

def show_button=(show)
  Axlsx.validate_boolean show
  @show_botton = show
end

#to_xml_string(str = '') ⇒ Object

Serialize the object to xml


88
89
90
91
92
# File 'lib/axlsx/workbook/worksheet/auto_filter/filter_column.rb', line 88

def to_xml_string(str='')
  str << "<filterColumn #{serialized_attributes}>"
  @filter.to_xml_string(str)
  str << "</filterColumn>"
end