Merge pull request #185 from agardiner/preserve-spaces

Add support for preserving leading and trailing spaces in cell values

1 files changed, 9 insertions, 0 deletions

diff --git a/test/workbook/worksheet/tc_worksheet.rb b/test/workbook/worksheet/tc_worksheet.rb
index ed8c7cab..c2bb0faa 100644
--- a/test/workbook/worksheet/tc_worksheet.rb
+++ b/test/workbook/worksheet/tc_worksheet.rb
@@ -352,6 +352,15 @@ class TestWorksheet < Test::Unit::TestCase
     assert(schema.validate(doc).map{ |e| puts e.message; e }.empty?, "error free validation")
   end
 
+  def test_to_xml_string_with_preserve_spaces
+    # Check that xml:space="preserve" has been added when preserve_spaces is set
+    ws_xml = Nokogiri::XML(@ws.to_xml_string)
+    assert(ws_xml.xpath("//xmlns:worksheet/@xml:space='preserve'"))
+    @ws.preserve_spaces = false
+    ws_xml = Nokogiri::XML(@ws.to_xml_string)
+    assert(!ws_xml.xpath("//xmlns:worksheet/@xml:space='preserve'"))
+  end
+
   def test_styles
     assert(@ws.styles.is_a?(Axlsx::Styles), 'worksheet provides access to styles')
   end