diff options
| -rw-r--r-- | lib/axlsx/workbook/worksheet/worksheet.rb | 2 | ||||
| -rw-r--r-- | test/workbook/worksheet/tc_worksheet.rb | 5 |
2 files changed, 6 insertions, 1 deletions
diff --git a/lib/axlsx/workbook/worksheet/worksheet.rb b/lib/axlsx/workbook/worksheet/worksheet.rb index 6a53e2ca..1abfcd0d 100644 --- a/lib/axlsx/workbook/worksheet/worksheet.rb +++ b/lib/axlsx/workbook/worksheet/worksheet.rb @@ -275,7 +275,7 @@ module Axlsx # @return [String] the A1:B2 style reference for the first and last row column intersection in the workbook def dimension dim_start = rows.first.cells.first == nil ? 'A1' : rows.first.cells.first.r - dim_end = rows.last.cells.last == nil ? 'AA:200' : rows.last.cells.last.r + dim_end = rows.last.cells.last == nil ? 'AA200' : rows.last.cells.last.r "#{dim_start}:#{dim_end}" end diff --git a/test/workbook/worksheet/tc_worksheet.rb b/test/workbook/worksheet/tc_worksheet.rb index 5dac2176..c930d06b 100644 --- a/test/workbook/worksheet/tc_worksheet.rb +++ b/test/workbook/worksheet/tc_worksheet.rb @@ -108,6 +108,11 @@ class TestWorksheet < Test::Unit::TestCase assert_equal @ws.dimension, "A1:C2" end + def test_dimension_with_empty_row + @ws.add_row + assert_equal "A1:AA200", @ws.dimension + end + def test_referencing @ws.add_row [1, 2, 3] @ws.add_row [4, 5, 6] |