lib/roo/excelx.rb in roo-1.9.4 vs lib/roo/excelx.rb in roo-1.9.5
- old
+ new
@@ -305,26 +305,9 @@
sheet = @default_sheet unless sheet
read_cells(sheet) unless @cells_read[sheet]
@cell[sheet].inspect
end
- # returns each formula in the selected sheet as an array of elements
- # [row, col, formula]
- def formulas(sheet=nil)
- theformulas = Array.new
- sheet = @default_sheet unless sheet
- read_cells(sheet) unless @cells_read[sheet]
- first_row(sheet).upto(last_row(sheet)) {|row|
- first_column(sheet).upto(last_column(sheet)) {|col|
- if formula?(row,col,sheet)
- f = [row, col, formula(row,col,sheet)]
- theformulas << f
- end
- }
- }
- theformulas
- end
-
private
# helper function to set the internal representation of cells
def set_cell_values(sheet,x,y,i,v,vt,formula,tr,str_v,
excelx_type=nil,