From 686d90aa265ed3072070a523d6f4c6922c941c05 Mon Sep 17 00:00:00 2001 From: Randy Morgan Date: Wed, 26 Sep 2012 15:00:38 +0900 Subject: set filter_mode --- lib/axlsx/workbook/worksheet/sheet_pr.rb | 2 +- test/workbook/worksheet/tc_worksheet.rb | 7 +++++++ 2 files changed, 8 insertions(+), 1 deletion(-) 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 -- cgit v1.2.3