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
94
95
96
97
98
99
100
101
102
103
104
105
|
package coords
import (
"testing"
)
func TestAlphaStream(t *testing.T) {
if colstream[26] != "AA" {
t.Errorf("The test expected AA, got %v.", colstream[26])
}
if len(colstream) > maxCols {
t.Errorf(`Number of columns in alphastream exceeds Excel maximum.
alphastream contains %d, maxCols is %d`, len(colstream), maxCols)
}
}
func TestAlphaSingle(t *testing.T) {
ab := alphabet()
if ab[0] != "A" {
t.Errorf("The test expected A, got %v.", ab[0])
}
if ab[1] != "B" {
t.Errorf("The test expected B, got %v.", ab[1])
}
if ab[25] != "Z" {
t.Errorf("The test expected Z, got %v.", ab[25])
}
}
func TestAlphas(t *testing.T) {
a := 2 // two alphabets long
ecs := cols(a)
cases := []struct {
col int
val string
}{
{0, "A"},
{25, "Z"},
{26, "AA"},
{52, "BA"},
}
for _, c := range cases {
// we're making sure we can pass that index
r := 26 * a
if c.col > r {
t.Fatalf("Cannot use %d as index to array of %d", c.col, r)
}
if got := ecs[c.col]; got != c.val {
t.Errorf("The test expected ecs[%d] to be %s - got %s.",
c.col, c.val, ecs[c.col])
}
}
}
func TestGetColApha(t *testing.T) {
cases := []struct {
index int
alpha string
}{
{0, "A"},
{1, "B"},
{2, "C"},
{16377, "XEX"},
}
for _, c := range cases {
s, err := ColIndexToAlpha(c.index)
if err != nil {
t.Fatal(err)
}
if s != c.alpha {
t.Errorf("Expected %s, got %s\n", c.alpha, s)
}
}
}
func TestColAlphaToIndex(t *testing.T) {
type args struct {
letters string
}
tests := []struct {
name string
args args
want int
wantErr bool
}{
{"TestColAlphaToIndex", args{"XEZ"}, 16379, false},
{"TestColAlphaToIndex", args{"XEY"}, 16378, false},
{"TestColAlphaToIndex", args{"XEX"}, 16377, false},
{"TestColAlphaToIndex", args{"A"}, 0, false},
{"TestColAlphaToIndex", args{"B"}, 1, false},
{"TestColAlphaToIndex", args{"AA"}, 26, false},
}
for _, tt := range tests {
t.Run(tt.name, func(t *testing.T) {
got, err := ColAlphaToIndex(tt.args.letters)
if (err != nil) != tt.wantErr {
t.Errorf("ColAlphaToIndex() error = %v, wantErr %v", err, tt.wantErr)
return
}
if got != tt.want {
t.Errorf("ColAlphaToIndex() = %v, want %v", got, tt.want)
}
})
}
}
|
