diff options
| author | Randy Morgan <[email protected]> | 2011-12-08 22:34:06 +0900 |
|---|---|---|
| committer | Randy Morgan <[email protected]> | 2011-12-08 22:34:06 +0900 |
| commit | 72c4c3314ad4f5f2be4784aa4401cf9fd3a40ff3 (patch) | |
| tree | 5338ab4dfd30d68cddc5f290a8f019009d3043f4 | |
| parent | 208e08f46ca4e69dd5ecf6316ec9b877c86a1b3e (diff) | |
| download | caxlsx-72c4c3314ad4f5f2be4784aa4401cf9fd3a40ff3.tar.gz caxlsx-72c4c3314ad4f5f2be4784aa4401cf9fd3a40ff3.zip | |
[bug fix] Sheet names with spaces require quotation when generating range
| -rw-r--r-- | lib/axlsx.rb | 2 |
1 files changed, 1 insertions, 1 deletions
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 |