Fix a typo in `Axlsx::Worksheet#dimension` when a row was added without value.

When `Axlsx::Worksheet#add_row` is called without values `#dimension` returned
"AA:200" instead of "AA200", which resulted in a dimension of "A1:AA:200".
This lead to an error in `Axlsx.name_to_indices` which is then called with
"200" instead of "AA200" when using `Axlsx::Worksheet#abs_auto_filter`.

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]