examples/ruby-versions/pruning-ruby/sheets/sheet3.rb in rubyfromexcel-0.0.13 vs examples/ruby-versions/pruning-ruby/sheets/sheet3.rb in rubyfromexcel-0.0.16
- old
+ new
@@ -1,7 +1,15 @@
# coding: utf-8
# Inputs
class Sheet3 < Spreadsheet
def a1; 99.0; end
def a3; "In result"; end
+ def a5; 1.0; end
+ def b5; 2.0; end
+ def c5; 3.0; end
+ def d5; 4.0; end
+ def e5; 5.0; end
+ def a6_array; @a6_array ||= a('a5','e5'); end
+ def a6; @a6 ||= a6_array.array_formula_offset(0,0); end
+ def e6; @e6 ||= a6_array.array_formula_offset(0,4); end
end