class

XLSX::Formula

Inherits Reference < Object

A cell containing a formula and its last cached result.

  • expression — the formula string without the leading = (e.g. "SUM(A1:A5)")
  • cached_value — the last value Excel calculated for this cell
  • shared_index — si attribute if this cell is part of a shared formula group
  • shared_ref — ref span attribute if this cell is the master of a shared group

Constructors

new(expression : String, cached_value : CellValue, shared_index : Int32 | Nil = nil, shared_ref : String | Nil = nil)
Source

Instance methods

==(other : Formula) : Bool
Source
cached_value
Source
expression
Source
shared_index
Source
shared_ref
Source
to_s(io : IO) : Nil

Appends a short String representation of this object which includes its class name and its object address.

class Person
  def initialize(@name : String, @age : Int32)
  end
end

Person.new("John", 32).to_s # => #<Person:0x10a199f20>
Source