Implement :offset option for worksheet#add_row (#87)

1 files changed, 24 insertions, 24 deletions

diff --git a/examples/complex_example.md b/examples/complex_example.md
index 51b85e6b..4f395b02 100644
--- a/examples/complex_example.md
+++ b/examples/complex_example.md
@@ -22,34 +22,34 @@ t_money    = s.add_style b: true, num_fmt: 5, bg_color: 'FFDFDEDF'
 
 wb.add_worksheet do |sheet|
   sheet.add_row
-  sheet.add_row [nil, 'College Budget'], style: [nil, header]
+  sheet.add_row ['College Budget'], style: header, offset: 1
 
   sheet.add_row
-  sheet.add_row [nil, "What's coming in this month.", nil, nil, 'How am I doing'], style: tbl_header
-  sheet.add_row [nil, 'Item', 'Amount', nil, 'Item', 'Amount'], style: [nil, ind_header, col_header, nil, ind_header, col_header]
-  sheet.add_row [nil, 'Estimated monthly net income', 500, nil, 'Monthly income', '=C9'], style: [nil, label, money, nil, label, money]
-  sheet.add_row [nil, 'Financial aid', 100, nil, 'Monthly expenses', '=C27'], style: [nil, label, money, nil, label, money]
-  sheet.add_row [nil, 'Allowance from mom & dad', 20000, nil, 'Semester expenses', '=F19'], style: [nil, label, money, nil, label, money]
-  sheet.add_row [nil, 'Total', '=SUM(C6:C8)', nil, 'Difference', '=F6 - SUM(F7:F8)'], style: [nil, t_label, t_money, nil, t_label, t_money]
+  sheet.add_row ["What's coming in this month.", nil, nil, 'How am I doing'], style: tbl_header, offset: 1
+  sheet.add_row ['Item', 'Amount', nil, 'Item', 'Amount'], style: [ind_header, col_header, nil, ind_header, col_header], offset: 1
+  sheet.add_row ['Estimated monthly net income', 500, nil, 'Monthly income', '=C9'], style: [label, money, nil, label, money], offset: 1
+  sheet.add_row ['Financial aid', 100, nil, 'Monthly expenses', '=C27'], style: [label, money, nil, label, money], offset: 1
+  sheet.add_row ['Allowance from mom & dad', 20000, nil, 'Semester expenses', '=F19'], style: [label, money, nil, label, money], offset: 1
+  sheet.add_row ['Total', '=SUM(C6:C8)', nil, 'Difference', '=F6 - SUM(F7:F8)'], style: [t_label, t_money, nil, t_label, t_money], offset: 1
 
   sheet.add_row
-  sheet.add_row [nil, "What's going out this month.", nil, nil, 'Semester Costs'], style: tbl_header
-  sheet.add_row [nil, 'Item', 'Amount', nil, 'Item', 'Amount'], style: [nil, ind_header, col_header, nil, ind_header, col_header]
-  sheet.add_row [nil, 'Rent', 650, nil, 'Tuition', 200], style: [nil, label, money, nil, label, money]
-  sheet.add_row [nil, 'Utilities', 120, nil, 'Lab fees', 50], style: [nil, label, money, nil, label, money]
-  sheet.add_row [nil, 'Cell phone', 100, nil, 'Other fees', 10], style: [nil, label, money, nil, label, money]
-  sheet.add_row [nil, 'Groceries', 75, nil, 'Books', 150], style: [nil, label, money, nil, label, money]
-  sheet.add_row [nil, 'Auto expenses', 0, nil, 'Deposits', 0], style: [nil, label, money, nil, label, money]
-  sheet.add_row [nil, 'Student loans', 0, nil, 'Transportation', 30], style: [nil, label, money, nil, label, money]
-  sheet.add_row [nil, 'Other loans', 350, nil, 'Total', '=SUM(F13:F18)'], style: [nil, label, money, nil, t_label, t_money]
-  sheet.add_row [nil, 'Credit cards', 450], style: [nil, label, money]
-  sheet.add_row [nil, 'Insurance', 0], style: [nil, label, money]
-  sheet.add_row [nil, 'Laundry', 10], style: [nil, label, money]
-  sheet.add_row [nil, 'Haircuts', 0], style: [nil, label, money]
-  sheet.add_row [nil, 'Medical expenses', 0], style: [nil, label, money]
-  sheet.add_row [nil, 'Entertainment', 500], style: [nil, label, money]
-  sheet.add_row [nil, 'Miscellaneous', 0], style: [nil, label, money]
-  sheet.add_row [nil, 'Total', '=SUM(C13:C26)'], style: [nil, t_label, t_money]
+  sheet.add_row ["What's going out this month.", nil, nil, 'Semester Costs'], style: tbl_header, offset: 1
+  sheet.add_row ['Item', 'Amount', nil, 'Item', 'Amount'], style: [ind_header, col_header, nil, ind_header, col_header], offset: 1
+  sheet.add_row ['Rent', 650, nil, 'Tuition', 200], style: [label, money, nil, label, money], offset: 1
+  sheet.add_row ['Utilities', 120, nil, 'Lab fees', 50], style: [label, money, nil, label, money], offset: 1
+  sheet.add_row ['Cell phone', 100, nil, 'Other fees', 10], style: [label, money, nil, label, money], offset: 1
+  sheet.add_row ['Groceries', 75, nil, 'Books', 150], style: [label, money, nil, label, money], offset: 1
+  sheet.add_row ['Auto expenses', 0, nil, 'Deposits', 0], style: [label, money, nil, label, money], offset: 1
+  sheet.add_row ['Student loans', 0, nil, 'Transportation', 30], style: [label, money, nil, label, money], offset: 1
+  sheet.add_row ['Other loans', 350, nil, 'Total', '=SUM(F13:F18)'], style: [label, money, nil, t_label, t_money], offset: 1
+  sheet.add_row ['Credit cards', 450], style: [label, money], offset: 1
+  sheet.add_row ['Insurance', 0], style: [label, money], offset: 1
+  sheet.add_row ['Laundry', 10], style: [label, money], offset: 1
+  sheet.add_row ['Haircuts', 0], style: [label, money], offset: 1
+  sheet.add_row ['Medical expenses', 0], style: [label, money], offset: 1
+  sheet.add_row ['Entertainment', 500], style: [label, money], offset: 1
+  sheet.add_row ['Miscellaneous', 0], style: [label, money], offset: 1
+  sheet.add_row ['Total', '=SUM(C13:C26)'], style: [t_label, t_money], offset: 1
 
   sheet.add_chart(Axlsx::Pie3DChart) do |chart|
     chart.title = sheet['B11']