examples/array_formula.rb in write_xlsx-1.09.4 vs examples/array_formula.rb in write_xlsx-1.09.5

- old
+ new

@@ -15,11 +15,11 @@ # Create a new workbook and add a worksheet workbook = WriteXLSX.new('array_formula.xlsx') worksheet = workbook.add_worksheet # Write some test data. -worksheet.write('B1', [ [ 500, 10 ], [ 300, 15 ] ]) -worksheet.write('B5', [ [ 1, 2, 3 ], [ 20234, 21003, 10000 ] ]) +worksheet.write('B1', [[500, 10], [300, 15]]) +worksheet.write('B5', [[1, 2, 3], [20234, 21003, 10000]]) # Write an array formula that returns a single value worksheet.write('A1', '{=SUM(B1:C1*B2:C2)}') # Same as above but more verbose.