Add autofilter to worksheet
[p5sagit/Excel-Template.git] / t / 029_worksheet_autofilter.t
1 use strict;
2
3 use Test::More tests => 4;
4
5 use lib 't';
6 use mock;
7 use Data::Dumper;
8 mock::reset;
9
10 my $CLASS = 'Excel::Template';
11 use_ok( $CLASS );
12
13 my $object = $CLASS->new(
14     filename => \*DATA,
15 );
16 isa_ok( $object, $CLASS );
17
18 ok( $object->write_file( 'filename' ), 'Something returned' );
19
20 my @calls = mock::get_calls;
21 # warn Dumper \@calls;
22 is( join( $/, @calls, '' ), <<__END_EXPECTED__, 'Calls match up' );
23 Spreadsheet::WriteExcel::new( 'filename' )
24 Spreadsheet::WriteExcel::add_format( '' )
25 Spreadsheet::WriteExcel::add_worksheet( '' )
26 Spreadsheet::WriteExcel::Worksheet::new( '' )
27 Spreadsheet::WriteExcel::Worksheet::autofilter( 'A1:D11' )
28 Spreadsheet::WriteExcel::add_worksheet( '' )
29 Spreadsheet::WriteExcel::Worksheet::new( '' )
30 Spreadsheet::WriteExcel::Worksheet::autofilter( '0', '0', '10', '3' )
31 Spreadsheet::WriteExcel::close( '' )
32 __END_EXPECTED__
33
34 __DATA__
35 <workbook>
36   <worksheet autofilter='A1:D11' />
37   <worksheet autofilter='0, 0, 10, 3' />
38 </workbook>