diff options
| author | Jesse Luehrs <doy@tozt.net> | 2013-08-29 15:29:33 -0400 |
|---|---|---|
| committer | Jesse Luehrs <doy@tozt.net> | 2013-08-29 15:29:33 -0400 |
| commit | 6cca8025c28553cd1adbb2a54b43d64685664fb7 (patch) | |
| tree | 1b9cfa8396519e2ca9f727009c9fb4b2af0b39c9 /lib | |
| parent | f79aa6392589db518f7292b89a4c8978f5c7c6a5 (diff) | |
| download | spreadsheet-template-6cca8025c28553cd1adbb2a54b43d64685664fb7.tar.gz spreadsheet-template-6cca8025c28553cd1adbb2a54b43d64685664fb7.zip | |
fix this algorithm, again (jasonshaev)
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/Spreadsheet/Template/Helpers/Xslate.pm | 13 |
1 files changed, 6 insertions, 7 deletions
diff --git a/lib/Spreadsheet/Template/Helpers/Xslate.pm b/lib/Spreadsheet/Template/Helpers/Xslate.pm index 8712656..56df981 100644 --- a/lib/Spreadsheet/Template/Helpers/Xslate.pm +++ b/lib/Spreadsheet/Template/Helpers/Xslate.pm @@ -3,7 +3,6 @@ use strict; use warnings; use JSON; -use POSIX; my $JSON = JSON->new; @@ -82,13 +81,13 @@ sub _cell_to_row_col { my ($col, $row) = $cell =~ /([A-Z]+)([0-9]+)/; - (my $ncol = $col) =~ tr/A-Z/1-9A-Q/; - $ncol = POSIX::strtol($ncol, 27); - $ncol -= 1; + my $ncol = 0; + for my $char (split //, $col) { + $ncol *= 26; + $ncol += ord($char) - ord('A') + 1; + } - my $nrow = $row - 1; - - return [ $nrow, $ncol ]; + return [ $row - 1, $ncol - 1 ]; } sub _formats { |