From 7ff47a1d277ff719be21fb82258ffcefb509df51 Mon Sep 17 00:00:00 2001 From: mfrank01 Date: Tue, 29 Jul 2014 14:12:03 -0600 Subject: Allow multiple autofilters per workbook --- lib/axlsx/workbook/worksheet/worksheet.rb | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/axlsx/workbook/worksheet/worksheet.rb b/lib/axlsx/workbook/worksheet/worksheet.rb index 96fbf959..3a8aeb46 100644 --- a/lib/axlsx/workbook/worksheet/worksheet.rb +++ b/lib/axlsx/workbook/worksheet/worksheet.rb @@ -790,7 +790,7 @@ module Axlsx end def add_autofilter_defined_name_to_workbook - return if workbook.defined_names.any?{|dn| dn.name=='_xlnm._FilterDatabase'} || !auto_filter.range + return if !auto_filter.range workbook.add_defined_name auto_filter.defined_name, name: '_xlnm._FilterDatabase', local_sheet_id: index, hidden: 1 end -- cgit v1.2.3