summaryrefslogtreecommitdiffhomepage
path: root/test
diff options
context:
space:
mode:
authorJonathan Tron <[email protected]>2014-02-26 14:57:26 +0100
committerJonathan Tron <[email protected]>2014-02-26 14:57:26 +0100
commit450d5e703ff6d45b6689959ea9079e81ff6dc4ad (patch)
tree5cc16a644498cde0a3884e7ed4c013b031f0e841 /test
parentd7b4ae4b2508732f1648594d0056c0e2b4105d1a (diff)
downloadcaxlsx-450d5e703ff6d45b6689959ea9079e81ff6dc4ad.tar.gz
caxlsx-450d5e703ff6d45b6689959ea9079e81ff6dc4ad.zip
Add auto_filter defined name in `Axlsx::Worksheet#to_xml_string` (refs #285)
The way ot was done previously (adding the defined name on `Axlsx::Worksheet#auto_filter=`) meant that it was added only when using this method. But it's possible to assign range on the auto-created `AutoFilter` with: ```ruby workheet.auto_filter.range = "A1:B2" ``` In this case the defined name was never added to the workbook.
Diffstat (limited to 'test')
-rw-r--r--test/workbook/worksheet/tc_worksheet.rb11
1 files changed, 11 insertions, 0 deletions
diff --git a/test/workbook/worksheet/tc_worksheet.rb b/test/workbook/worksheet/tc_worksheet.rb
index 7cefbda9..74253613 100644
--- a/test/workbook/worksheet/tc_worksheet.rb
+++ b/test/workbook/worksheet/tc_worksheet.rb
@@ -514,7 +514,18 @@ class TestWorksheet < Test::Unit::TestCase
assert_raise(ArgumentError) { @ws.auto_filter = 123 }
@ws.auto_filter.range = "A1:D9"
assert_equal(@ws.auto_filter.range, "A1:D9")
+ @ws.to_xml_string
+ assert(@wb.defined_names.any?{|defined_name| defined_name.name=='_xlnm._FilterDatabase'})
+ end
+
+ def test_auto_filter_assign
+ assert(@ws.auto_filter.range.nil?)
assert(@wb.defined_names.none?{|defined_name| defined_name.name=='_xlnm._FilterDatabase'})
+ assert_raise(ArgumentError) { @ws.auto_filter = 123 }
+ @ws.auto_filter = "A1:D9"
+ assert_equal(@ws.auto_filter.range, "A1:D9")
+ @ws.to_xml_string
+ assert(@wb.defined_names.any?{|defined_name| defined_name.name=='_xlnm._FilterDatabase'})
end
def test_sheet_pr_for_auto_filter