From e780e41e0222517caa9c69030b5955ab2b458a49 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Olivier=20Mengu=C3=A9?= <dolmen@cpan.org>
Date: Sat, 2 Feb 2019 04:05:01 +0100
Subject: Faster TitleToNumber (#343)

* TestTitleToNumber: more test cases

* TitleToNumber: drop use of math.Pow()

Compute using pure integers

* TitleToNumber: simplify

Remove unecessary casts to int
---
 excelize_test.go | 4 ++++
 1 file changed, 4 insertions(+)

(limited to 'excelize_test.go')

diff --git a/excelize_test.go b/excelize_test.go
index 6a106ec..ebbfcf7 100644
--- a/excelize_test.go
+++ b/excelize_test.go
@@ -1546,8 +1546,12 @@ func TestConditionalFormatError(t *testing.T) {
 }
 
 func TestTitleToNumber(t *testing.T) {
+	assert.Equal(t, 0, TitleToNumber("A"))
+	assert.Equal(t, 25, TitleToNumber("Z"))
+	assert.Equal(t, 26, TitleToNumber("AA"))
 	assert.Equal(t, 36, TitleToNumber("AK"))
 	assert.Equal(t, 36, TitleToNumber("ak"))
+	assert.Equal(t, 51, TitleToNumber("AZ"))
 }
 
 func TestSharedStrings(t *testing.T) {
-- 
cgit v1.2.1