# frozen_string_literal: true

require_relative './xlsx_func_testcase'

class TestAutofilter < XlsxWriterTestCase
  ROWS = [
    %w[Region Item Volume Month],
    ['East',  'Apple',  9000,   'July'],
    ['East',  'Apple',  5000,   'July'],
    ['South', 'Orange', 9000,   'September'],
    ['North', 'Apple',  2000,   'November'],
    ['West',  'Apple',  9000,   'November'],
    ['South', 'Pear',   7000,   'October'],
    ['North', 'Pear',   9000,   'August'],
    ['West',  'Orange', 1000,   'December'],
    ['West',  'Grape',  1000,   'November'],
    ['South', 'Pear',   10_000, 'April'],
    ['West',  'Grape',  6000,   'January'],
    ['South', 'Orange', 3000,   'May'],
    ['North', 'Apple',  3000,   'December'],
    ['South', 'Apple',  7000,   'February'],
    ['West',  'Grape',  1000,   'December'],
    ['East',  'Grape',  8000,   'February'],
    ['South', 'Grape',  10_000, 'June'],
    ['West',  'Pear',   7000,   'December'],
    ['South', 'Apple',  2000,   'October'],
    ['East',  'Grape',  7000,   'December'],
    ['North', 'Grape',  6000,   'April'],
    ['East',  'Pear',   8000,   'February'],
    ['North', 'Apple',  7000,   'August'],
    ['North', 'Orange', 7000,   'July'],
    ['North', 'Apple',  6000,   'June'],
    ['South', 'Grape',  8000,   'September'],
    ['West',  'Apple',  3000,   'October'],
    ['South', 'Orange', 10_000, 'November'],
    ['West',  'Grape',  4000,   'July'],
    ['North', 'Orange', 5000,   'August'],
    ['East',  'Orange', 1000,   'November'],
    ['East',  'Orange', 4000,   'October'],
    ['North', 'Grape',  5000,   'August'],
    ['East',  'Apple',  1000,   'December'],
    ['South', 'Apple',  10_000, 'March'],
    ['East',  'Grape',  7000,   'October'],
    ['West',  'Grape',  1000,   'September'],
    ['East',  'Grape',  10_000, 'October'],
    ['South', 'Orange', 8000,   'March'],
    ['North', 'Apple',  4000,   'July'],
    ['South', 'Orange', 5000,   'July'],
    ['West',  'Apple',  4000,   'June'],
    ['East',  'Apple',  5000,   'April'],
    ['North', 'Pear',   3000,   'August'],
    ['East',  'Grape',  9000,   'November'],
    ['North', 'Orange', 8000,   'October'],
    ['East',  'Apple',  10_000, 'June'],
    ['South', 'Pear',   1000,   'December'],
    ['North', 'Grape',  10_000, 'July'],
    ['East',  'Grape',  6000,   'February']
  ].freeze

  test 'autofilter00' do |wb|
    ws = wb.add_worksheet

    ROWS.each { |row| ws.add_row row }
  end

  test 'autofilter01' do |wb|
    ws = wb.add_worksheet

    ROWS.each { |row| ws.add_row row }
    ws.autofilter('A1', 50, 3)
  end
end