Class: Writexlsx::Worksheet::FormulaArrayCellData

Inherits:

CellData

• Object
• CellData
• Writexlsx::Worksheet::FormulaArrayCellData

Defined in:

lib/write_xlsx/worksheet.rb

Overview

:nodoc:

Constant Summary

Constants included from Utility

Utility::COL_MAX, Utility::ROW_MAX, Utility::SHEETNAME_MAX, Utility::STR_MAX

Instance Attribute Summary

Attributes inherited from CellData

#col, #link_type, #range, #result, #row, #tip, #token, #url, #xf

Instance Method Summary

• #data ⇒ Object
• #initialize(worksheet, row, col, formula, xf, range, result) ⇒ FormulaArrayCellData constructor

  A new instance of FormulaArrayCellData.

• #write_cell ⇒ Object

Methods inherited from CellData

#cell_attributes

Methods included from Utility

#absolute_char, #check_dimensions, #check_dimensions_and_update_max_min_values, #check_parameter, #convert_date_time, delete_files, #ptrue?, #put_deprecate_message, #row_col_notation, #store_col_max_min_values, #store_row_max_min_values, #substitute_cellref, #underline_attributes, #write_color, #xl_cell_to_rowcol, #xl_col_to_name, #xl_range, #xl_range_formula, #xl_rowcol_to_cell, #xml_str

Constructor Details

#initialize(worksheet, row, col, formula, xf, range, result) ⇒ FormulaArrayCellData

Returns a new instance of FormulaArrayCellData.

# File 'lib/write_xlsx/worksheet.rb', line 235

def initialize(worksheet, row, col, formula, xf, range, result)
  @worksheet = worksheet
  @row, @col, @token, @xf, @range, @result = row, col, formula, xf, range, result
end

Instance Method Details

#data ⇒ Object

# File 'lib/write_xlsx/worksheet.rb', line 240

def data
  @result || 0
end

#write_cell ⇒ Object

# File 'lib/write_xlsx/worksheet.rb', line 244

def write_cell
  @worksheet.writer.tag_elements('c', cell_attributes) do
    @worksheet.write_cell_array_formula(token, range)
    @worksheet.write_cell_value(result)
  end
end