diff options
author | Jesse Luehrs <doy@tozt.net> | 2013-08-29 15:41:59 -0400 |
---|---|---|
committer | Jesse Luehrs <doy@tozt.net> | 2013-08-29 15:41:59 -0400 |
commit | 4e03d41c19ee0f70f076934455844fe40b122f3f (patch) | |
tree | a4b39266bc12de61da035630c9674607b4ba6ce6 /t/cell-to-row-col.t | |
parent | 5ff1728282b6bccaa553f97bf4b8d1fc121f92c3 (diff) | |
download | spreadsheet-parsexlsx-4e03d41c19ee0f70f076934455844fe40b122f3f.tar.gz spreadsheet-parsexlsx-4e03d41c19ee0f70f076934455844fe40b122f3f.zip |
fix this algorithm again
Diffstat (limited to 't/cell-to-row-col.t')
-rw-r--r-- | t/cell-to-row-col.t | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/t/cell-to-row-col.t b/t/cell-to-row-col.t new file mode 100644 index 0000000..d2ecbaa --- /dev/null +++ b/t/cell-to-row-col.t @@ -0,0 +1,27 @@ +#!/usr/bin/env perl +use strict; +use warnings; +use Test::More; + +use Spreadsheet::ParseXLSX; + +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::ParseXLSX->_cell_to_row_col($cell) ], + $tests{$cell}, + "correct value for $cell" + ); +} + +done_testing; |