Contents

# -*- coding: utf-8 -*-
require 'helper'
require 'write_xlsx'
require 'stringio'

class TestWriteCustomFilters < Test::Unit::TestCase
  def setup
    @workbook = WriteXLSX.new(StringIO.new)
    @worksheet = @workbook.add_worksheet('')
  end

  def test_write_custom_filters_4_4000
    @worksheet.__send__('write_custom_filters', 4, 4000)
    result = @worksheet.instance_variable_get(:@writer).string
    expected = '<customFilters><customFilter operator="greaterThan" val="4000"/></customFilters>'
    assert_equal(expected, result)
  end

  def test_write_custom_filters_4_3000_0_1_8000
    @worksheet.__send__('write_custom_filters', 4, 3000, 0, 1, 8000)
    result = @worksheet.instance_variable_get(:@writer).string
    expected = '<customFilters and="1"><customFilter operator="greaterThan" val="3000"/><customFilter operator="lessThan" val="8000"/></customFilters>'
    assert_equal(expected, result)
  end
end

Version data entries

48 entries across 48 versions & 1 rubygems

Version	Path
write_xlsx-0.86.0	test/worksheet/test_write_custom_filters.rb
write_xlsx-0.85.11	test/worksheet/test_write_custom_filters.rb
write_xlsx-0.85.10	test/worksheet/test_write_custom_filters.rb
write_xlsx-0.85.9	test/worksheet/test_write_custom_filters.rb
write_xlsx-0.85.8	test/worksheet/test_write_custom_filters.rb
write_xlsx-0.85.7	test/worksheet/test_write_custom_filters.rb
write_xlsx-0.85.6	test/worksheet/test_write_custom_filters.rb
write_xlsx-0.85.5	test/worksheet/test_write_custom_filters.rb
write_xlsx-0.85.4	test/worksheet/test_write_custom_filters.rb
write_xlsx-0.85.3	test/worksheet/test_write_custom_filters.rb
write_xlsx-0.85.2	test/worksheet/test_write_custom_filters.rb
write_xlsx-0.85.1	test/worksheet/test_write_custom_filters.rb
write_xlsx-0.83.0	test/worksheet/test_write_custom_filters.rb
write_xlsx-0.81.1	test/worksheet/test_write_custom_filters.rb
write_xlsx-0.81.0	test/worksheet/test_write_custom_filters.rb
write_xlsx-0.80.0	test/worksheet/test_write_custom_filters.rb
write_xlsx-0.79.0	test/worksheet/test_write_custom_filters.rb
write_xlsx-0.78.0	test/worksheet/test_write_custom_filters.rb
write_xlsx-0.77.2	test/worksheet/test_write_custom_filters.rb
write_xlsx-0.77.1	test/worksheet/test_write_custom_filters.rb