set filter_mode

2 files changed, 8 insertions, 1 deletions

diff --git a/lib/axlsx/workbook/worksheet/sheet_pr.rb b/lib/axlsx/workbook/worksheet/sheet_pr.rb
index 710d3cc1..a8f60330 100644
--- a/lib/axlsx/workbook/worksheet/sheet_pr.rb
+++ b/lib/axlsx/workbook/worksheet/sheet_pr.rb
@@ -110,7 +110,7 @@ module Axlsx
     
     def update_properties
       page_setup_pr.fit_to_page = worksheet.fit_to_page?
-      filter_mode = worksheet.auto_filter.columns.size > 0
+      self.filter_mode = worksheet.auto_filter.columns.size > 0
     end
   end
 
diff --git a/test/workbook/worksheet/tc_worksheet.rb b/test/workbook/worksheet/tc_worksheet.rb
index 0dcb6756..4c8f2822 100644
--- a/test/workbook/worksheet/tc_worksheet.rb
+++ b/test/workbook/worksheet/tc_worksheet.rb
@@ -427,4 +427,11 @@ class TestWorksheet < Test::Unit::TestCase
     @ws.auto_filter.range = "A1:D9"
     assert_equal(@ws.auto_filter.range, "A1:D9")
   end
+
+  def test_sheet_pr_for_auto_filter
+    @ws.auto_filter.range = 'A1:D9'
+    @ws.auto_filter.add_column 0, :filters, :filter_items => [1]
+    doc = Nokogiri::XML(@ws.to_xml_string)
+    assert(doc.xpath('//sheetPr[@filterMode="true"]')) 
+  end
 end