From 32b9175cca482fe02a69ec7cc4e362d70c4e1324 Mon Sep 17 00:00:00 2001
From: Joe Kain <jkain.dev@gmail.com>
Date: Sun, 11 Mar 2012 13:59:20 -0700
Subject: test r_abs with a cell in column AA.

---
 test/workbook/worksheet/tc_cell.rb | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/test/workbook/worksheet/tc_cell.rb b/test/workbook/worksheet/tc_cell.rb
index 97a9951b..efaee3ac 100644
--- a/test/workbook/worksheet/tc_cell.rb
+++ b/test/workbook/worksheet/tc_cell.rb
@@ -9,6 +9,8 @@ class TestCell < Test::Unit::TestCase
     p.workbook.styles.add_style :sz=>20
     @row = @ws.add_row
     @c = @row.add_cell 1, :type=>:float, :style=>1
+    @ws.add_row (0..26).map { |index| index }
+    @cAA = @ws["AA2"]
   end
 
   def test_initialize
@@ -42,6 +44,7 @@ class TestCell < Test::Unit::TestCase
 
   def test_r_abs
     assert_equal(@c.r_abs,"$A$1", "calculate absolute cell reference")
+    assert_equal(@cAA.r_abs,"$AA$2", "needs to accept multi-digit columns")
   end
 
   def test_style
-- 
cgit v1.2.3


From ccd59b3d88907da35a3cded14ba9cfa3a6379bd2 Mon Sep 17 00:00:00 2001
From: Joe Kain <joekain@gmail.com>
Date: Fri, 9 Mar 2012 14:08:39 -0800
Subject: Fix Cell#r_abs to handle multi-digit row numbers and multi-letter
 column ids.

---
 lib/axlsx/workbook/worksheet/cell.rb | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/lib/axlsx/workbook/worksheet/cell.rb b/lib/axlsx/workbook/worksheet/cell.rb
index 62fa539f..ff759cdf 100644
--- a/lib/axlsx/workbook/worksheet/cell.rb
+++ b/lib/axlsx/workbook/worksheet/cell.rb
@@ -230,7 +230,7 @@ module Axlsx
     # @example Absolute Cell Reference
     #   ws.rows.first.cells.first.r #=> "$A$1"
     def r_abs
-      "$#{r.split('').join('$')}"
+      "$#{r.match(%r{([A-Z]+)([0-9]+)})[1,2].join('$')}"
     end
 
     # @return [Integer] The cellXfs item index applied to this cell.
-- 
cgit v1.2.3