From be5cbe443d7cea3dd7cfc8aec4d984c34a0fb9bf Mon Sep 17 00:00:00 2001
From: Adam Gardiner <adam.b.gardiner@gmail.com>
Date: Wed, 10 Apr 2013 14:29:11 +0100
Subject: Add support for preserving leading and trailing spaces in cell values

---
 lib/axlsx/workbook/worksheet/cell_serializer.rb | 10 ++++++++--
 1 file changed, 8 insertions(+), 2 deletions(-)

(limited to 'lib')

diff --git a/lib/axlsx/workbook/worksheet/cell_serializer.rb b/lib/axlsx/workbook/worksheet/cell_serializer.rb
index e4c35c3a..b054316b 100644
--- a/lib/axlsx/workbook/worksheet/cell_serializer.rb
+++ b/lib/axlsx/workbook/worksheet/cell_serializer.rb
@@ -23,6 +23,12 @@ module Axlsx
       # @param [String] str The string instance this run will be concated to.
       # @return [String]
       def run_xml_string(cell, str = '')
+        t = cell.value.to_s
+        if t[0, 1] == ' ' || t[-1, 1] == ' '
+          t = '<t xml:space="preserve">' << t << '</t>'
+        else
+          t = '<t>' << t << '</t>'
+        end
         if cell.is_text_run?
           data = cell.instance_values.reject{|key, value| value == nil || key == 'value' || key == 'type' }
           keys = data.keys & Cell::INLINE_STYLES
@@ -37,9 +43,9 @@ module Axlsx
               str << "<" << key.to_s << " val='" << data[key].to_s << "'/>"
             end
           end
-          str << "</rPr>" << "<t>" << cell.value.to_s << "</t></r>"
+          str << "</rPr>" << t << "</r>"
         else
-          str << "<t>" << cell.value.to_s << "</t>"
+          str << t
         end
         str
       end
-- 
cgit v1.2.3