Class: Writexlsx::Worksheet::DynamicFormulaArrayCellData

Inherits:
CellData
  • Object
show all
Defined in:
lib/write_xlsx/worksheet/cell_data.rb

Overview

:nodoc:

Constant Summary

Constants included from Utility

Utility::CHAR_WIDTHS, Utility::COL_MAX, Utility::PERL_TRUE_VALUES, Utility::ROW_MAX, Utility::SHEETNAME_MAX, Utility::STR_MAX

Instance Attribute Summary collapse

Attributes inherited from CellData

#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, #color, #convert_date_time, #convert_font_args, #dash_types, delete_files, #escape_url, #fill_properties, #float_to_str, #get_font_latin_attributes, #get_font_style_attributes, #get_image_properties, #layout_properties, #legend_properties, #line_fill_properties, #line_properties, #palette_color, #params_to_font, #pattern_properties, #pixels_to_points, #process_bmp, #process_gif, #process_jpg, #process_png, #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_a_body_pr, #write_a_def_rpr, #write_a_end_para_rpr, #write_a_lst_style, #write_a_p_formula, #write_a_p_pr_formula, #write_a_solid_fill, #write_a_srgb_clr, #write_anchor, #write_auto_fill, #write_color, #write_comment_path, #write_def_rpr_r_pr_common, #write_div, #write_fill, #write_font, #write_stroke, #write_tx_pr, #write_xml_declaration, #xl_cell_to_rowcol, #xl_col_to_name, #xl_range, #xl_range_formula, #xl_rowcol_to_cell, #xl_string_pixel_width, #xml_str

Constructor Details

#initialize(formula, xf, range, result) ⇒ DynamicFormulaArrayCellData

Returns a new instance of DynamicFormulaArrayCellData.



151
152
153
154
155
156
 
# File 'lib/write_xlsx/worksheet/cell_data.rb', line 151

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

Instance Attribute Details

Returns the value of attribute link_type.



149
150
151
 
# File 'lib/write_xlsx/worksheet/cell_data.rb', line 149

def link_type
  @link_type
end

#range ⇒ Object (readonly)

Returns the value of attribute range.



149
150
151
 
# File 'lib/write_xlsx/worksheet/cell_data.rb', line 149

def range
  @range
end

#result ⇒ Object (readonly)

Returns the value of attribute result.



149
150
151
 
# File 'lib/write_xlsx/worksheet/cell_data.rb', line 149

def result
  @result
end

#token ⇒ Object (readonly)

Returns the value of attribute token.



149
150
151
 
# File 'lib/write_xlsx/worksheet/cell_data.rb', line 149

def token
  @token
end

#url ⇒ Object (readonly)

Returns the value of attribute url.



149
150
151
 
# File 'lib/write_xlsx/worksheet/cell_data.rb', line 149

def url
  @url
end

Instance Method Details

#data ⇒ Object 



158
159
160
 
# File 'lib/write_xlsx/worksheet/cell_data.rb', line 158

def data
  @result || 0
end

#write_cell(worksheet, row, row_name, col) ⇒ Object 



162
163
164
165
166
167
168
169
170
171
 
# File 'lib/write_xlsx/worksheet/cell_data.rb', line 162

def write_cell(worksheet, row, row_name, col)
  # Add metadata linkage for dynamic array formulas.
  attributes = cell_attributes(worksheet, row, row_name, col)
  attributes << %w[cm 1]

  worksheet.writer.tag_elements('c', attributes) do
    worksheet.write_cell_array_formula(token, range)
    worksheet.write_cell_value(result)
  end
end