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