Class Openoffice
In: lib/roo/openoffice.rb
Parent: GenericSpreadsheet

Methods

cell   celltype   formula   formula?   formulas   new   officeversion   sheets   to_s  

Constants

A_ROO_TYPE = { "float" => :float, "string" => :string, "date" => :date, "percentage" => :percentage, "time" => :time, }

Public Class methods

new(filename, packed=nil, file_warning=:error)

initialization and opening of a spreadsheet file values for packed: :zip

Public Instance methods

cell(row, col, sheet=nil)

Returns the content of a spreadsheet-cell. (1,1) is the upper left corner. (1,1), (1,’A’), (‘A’,1), (‘a’,1) all refers to the cell at the first line and first row.

celltype(row,col,sheet=nil)

returns the type of a cell:

  • :float
  • :string
  • :date
  • :percentage
  • :formula
  • :time
  • :datetime
formula(row,col,sheet=nil)

Returns the formula at (row,col). Returns nil if there is no formula. The method formula? checks if there is a formula.

formula?(row,col,sheet=nil)

true, if there is a formula

formulas(sheet=nil)

returns each formula in the selected sheet as an array of elements [row, col, formula]

officeversion()

version of the openoffice document at 2007 this is always “1.0“

sheets()

returns an array of sheet names in the spreadsheet

to_s(sheet=nil)

shows the internal representation of all cells mainly for debugging purposes

[Validate]