Class: Writexlsx::Worksheet::FormulaArrayCellData

Inherits:
CellData
  • Object
show all
Defined in:
lib/write_xlsx/worksheet/cell_data.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 collapse

Methods inherited from CellData

#cell_attributes, #display_url_string?

Methods included from Utility

#absolute_char, #check_dimensions, #check_dimensions_and_update_max_min_values, #check_parameter, #convert_date_time, #dash_types, delete_files, #fill_properties, #float_to_str, #layout_properties, #line_fill_properties, #line_properties, #palette_color, #pixels_to_points, #process_workbook_options, #ptrue?, #put_deprecate_message, #quote_sheetname, #r_id_attributes, #row_col_notation, #shape_style_base, #store_col_max_min_values, #store_row_max_min_values, #substitute_cellref, #underline_attributes, #v_shape_attributes_base, #v_shape_style_base, #value_or_raise, #write_anchor, #write_auto_fill, #write_color, #write_comment_path, #write_div, #write_fill, #write_font, #write_stroke, #write_xml_declaration, #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


112
113
114
115
# File 'lib/write_xlsx/worksheet/cell_data.rb', line 112

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

#dataObject


117
118
119
# File 'lib/write_xlsx/worksheet/cell_data.rb', line 117

def data
  @result || 0
end

#write_cellObject


121
122
123
124
125
126
# File 'lib/write_xlsx/worksheet/cell_data.rb', line 121

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