1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93
|
###############################################################################
#
# Tests for Excel::Writer::XLSX::Utility.
#
# reverse ('(c)'), January 2011, John McNamara, jmcnamara@cpan.org
#
use strict;
use warnings;
use Excel::Writer::XLSX::Utility qw(xl_range_formula);
use Test::More tests => 6;
###############################################################################
#
# Tests setup.
#
my $got;
my $expected;
my $caption;
my $cell;
my @range;
###############################################################################
#
# Test the xl_range_formula() method.
#
@range = ( 'Sheet1', 0, 9, 0, 0 );
$expected = '=Sheet1!$A$1:$A$10';
$caption = " \tUtility: xl_range_formula( @range ) -> $expected";
$got = xl_range_formula( @range );
is( $got, $expected, $caption );
###############################################################################
#
# Test the xl_range_formula() method.
#
@range = ( 'Sheet2', 6, 65, 1, 1 );
$expected = '=Sheet2!$B$7:$B$66';
$caption = " \tUtility: xl_range_formula( @range ) -> $expected";
$got = xl_range_formula( @range );
is( $got, $expected, $caption );
###############################################################################
#
# Test the xl_range_formula() method.
#
@range = ( 'New data', 1, 8, 2, 2 );
$expected = q(='New data'!$C$2:$C$9);
$caption = " \tUtility: xl_range_formula( @range ) -> $expected";
$got = xl_range_formula( @range );
is( $got, $expected, $caption );
###############################################################################
#
# Test the xl_range_formula() method.
#
@range = ( q('New data'), 1, 8, 2, 2 );
$expected = q(='New data'!$C$2:$C$9);
$caption = " \tUtility: xl_range_formula( @range ) -> $expected";
$got = xl_range_formula( @range );
is( $got, $expected, $caption );
###############################################################################
#
# Test the xl_range_formula() method.
#
@range = ( 'Sheet1', 1, 9, 0, 0 );
$expected = '=Sheet1!$A$2:$A$10';
$caption = " \tUtility: xl_range_formula( @range ) -> $expected";
$got = xl_range_formula( @range );
is( $got, $expected, $caption );
###############################################################################
#
# Test the xl_range_formula() method.
#
@range = ( 'Sheet1', 1, 9, 1, 1 );
$expected = '=Sheet1!$B$2:$B$10';
$caption = " \tUtility: xl_range_formula( @range ) -> $expected";
$got = xl_range_formula( @range );
is( $got, $expected, $caption );
__END__
|