summaryrefslogtreecommitdiffstats
path: root/t/cell-to-row-col.t
blob: c20432e40c25ab4ec76e022340b3904b5403af59 (plain) (blame)
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
#!/usr/bin/env perl
use strict;
use warnings;
use Test::More;

use Spreadsheet::Template::Helpers::Xslate;

my %tests = (
    A1    => [0,   0],
    Z3    => [2,   25],
    AA5   => [4,   26],
    IV256 => [255, 255],
    ZZ10  => [9,   701],
    AAA8  => [7,   702],
    XFD22 => [21,  16383],
);

for my $cell (sort keys %tests) {
    # XXX not public API, but i'm lazy
    is_deeply(
        Spreadsheet::Template::Helpers::Xslate::_cell_to_row_col($cell),
        $tests{$cell},
        "correct value for $cell"
    );
}

done_testing;