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