diff options
| author | Jonathan Tron <[email protected]> | 2014-02-26 14:57:26 +0100 |
|---|---|---|
| committer | Jonathan Tron <[email protected]> | 2014-02-26 14:57:26 +0100 |
| commit | 450d5e703ff6d45b6689959ea9079e81ff6dc4ad (patch) | |
| tree | 5cc16a644498cde0a3884e7ed4c013b031f0e841 /test | |
| parent | d7b4ae4b2508732f1648594d0056c0e2b4105d1a (diff) | |
| download | caxlsx-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.rb | 11 |
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 |
