Adding in support for optionally using the shared strings table. This will allow us to inter-op properly with Numbers

1 files changed, 39 insertions, 0 deletions

diff --git a/test/workbook/tc_shared_strings_table.rb b/test/workbook/tc_shared_strings_table.rb
new file mode 100644
index 00000000..b0e9de05
--- /dev/null
+++ b/test/workbook/tc_shared_strings_table.rb
@@ -0,0 +1,39 @@
+require 'test/unit'
+require 'axlsx.rb'
+
+class TestSharedStringsTable < Test::Unit::TestCase
+
+  def setup    
+    @p = Axlsx::Package.new :use_shared_strings=>true
+    ws = @p.workbook.add_worksheet
+    ws.add_row ['a', 1, 'b']
+    ws.add_row ['b', 1, 'c']
+    ws.add_row ['c', 1, 'd']    
+  end
+
+  def test_workbook_has_shared_strings
+    assert(@p.workbook.shared_strings.is_a?(Axlsx::SharedStringsTable), "shared string table was not created")
+  end
+
+  def test_count
+    sst = @p.workbook.shared_strings
+    assert_equal(sst.count, 6)
+  end
+
+  def test_unique_count
+    sst = @p.workbook.shared_strings
+    assert_equal(sst.unique_count, 4)
+  end
+
+  def test_valid_document    
+    schema = Nokogiri::XML::Schema(File.open(Axlsx::SML_XSD))
+    doc = Nokogiri::XML(@p.workbook.shared_strings.to_xml)
+    errors = []
+    schema.validate(doc).each do |error|
+      puts error.message
+      errors << error
+    end
+    assert_equal(errors.size, 0, "sharedStirngs.xml Invalid" + errors.map{ |e| e.message }.to_s)
+  end
+
+end