diff options
| -rw-r--r-- | lib/axlsx/workbook/worksheet/sheet_pr.rb | 2 | ||||
| -rw-r--r-- | test/workbook/worksheet/tc_worksheet.rb | 7 |
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 |