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

Methods

cell   celltype   column   formula   formula?   formulas   new   officeversion   row   sheets   to_s  

Constants

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

Public Class methods

new(filename, packed=nil)

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
column(columnnumber,sheet=nil)

returns all values in this column as an array column numbers are 1,2,3,… like in the spreadsheet

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.

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"

row(rownumber,sheet=nil)

returns all values in this row as an array row numbers are 1,2,3,… like in the spreadsheet

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]