From 72c4c3314ad4f5f2be4784aa4401cf9fd3a40ff3 Mon Sep 17 00:00:00 2001
From: Randy Morgan <randym@reallyenglish.com>
Date: Thu, 8 Dec 2011 22:34:06 +0900
Subject: [bug fix] Sheet names with spaces require quotation when generating
 range

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

(limited to 'lib')

diff --git a/lib/axlsx.rb b/lib/axlsx.rb
index 4fbe2b92..daa7ea11 100644
--- a/lib/axlsx.rb
+++ b/lib/axlsx.rb
@@ -39,7 +39,7 @@ module Axlsx
   # determines the cell range for the items provided
   def self.cell_range(items)
     return "" unless items.first.is_a? Cell          
-    ref = "#{items.first.row.worksheet.name}!" +
+    ref = "'#{items.first.row.worksheet.name}'!" +
       "#{items.first.r_abs}"
     ref += ":#{items.last.r_abs}" if items.size > 1
     ref
-- 
cgit v1.2.3