Method: Axlsx::CellSerializer.array_formula_serialization

Defined in:
lib/axlsx/workbook/worksheet/cell_serializer.rb

.array_formula_serialization(cell, str = '') ⇒ String

Serializes cells that are type array formula

Parameters:

  • cell (Cell) —

    The cell that is being serialized

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

    The string the serialized content will be appended to.

Returns:

  • (String) 


97
98
99
100
 
# File 'lib/axlsx/workbook/worksheet/cell_serializer.rb', line 97

def array_formula_serialization(cell, str='')
  str << ('t="str">' << '<f t="array" ref="' << cell.r << '">' << cell.clean_value.to_s.sub('{=', '').sub(/}$/, '') << '</f>')
  str << ('<v>' << cell.formula_value.to_s << '</v>') unless cell.formula_value.nil?
end