summaryrefslogtreecommitdiff
path: root/lib_test.go
diff options
context:
space:
mode:
Diffstat (limited to 'lib_test.go')
-rw-r--r--lib_test.go228
1 files changed, 191 insertions, 37 deletions
diff --git a/lib_test.go b/lib_test.go
index ef0d8f5..4c19f73 100644
--- a/lib_test.go
+++ b/lib_test.go
@@ -2,59 +2,213 @@ package excelize
import (
"fmt"
+ "strconv"
+ "strings"
"testing"
"github.com/stretchr/testify/assert"
)
-func TestAxisLowerOrEqualThanIsTrue(t *testing.T) {
- trueExpectedInputList := [][2]string{
- {"A", "B"},
- {"A", "AA"},
- {"B", "AA"},
- {"BC", "ABCD"},
- {"1", "2"},
- {"2", "11"},
+var validColumns = []struct {
+ Name string
+ Num int
+}{
+ {Name: "A", Num: 1},
+ {Name: "Z", Num: 26},
+ {Name: "AA", Num: 26 + 1},
+ {Name: "AK", Num: 26 + 11},
+ {Name: "ak", Num: 26 + 11},
+ {Name: "Ak", Num: 26 + 11},
+ {Name: "aK", Num: 26 + 11},
+ {Name: "AZ", Num: 26 + 26},
+ {Name: "ZZ", Num: 26 + 26*26},
+ {Name: "AAA", Num: 26 + 26*26 + 1},
+ {Name: "ZZZ", Num: 26 + 26*26 + 26*26*26},
+}
+
+var invalidColumns = []struct {
+ Name string
+ Num int
+}{
+ {Name: "", Num: -1},
+ {Name: " ", Num: -1},
+ {Name: "_", Num: -1},
+ {Name: "__", Num: -1},
+ {Name: "-1", Num: -1},
+ {Name: "0", Num: -1},
+ {Name: " A", Num: -1},
+ {Name: "A ", Num: -1},
+ {Name: "A1", Num: -1},
+ {Name: "1A", Num: -1},
+ {Name: " a", Num: -1},
+ {Name: "a ", Num: -1},
+ {Name: "a1", Num: -1},
+ {Name: "1a", Num: -1},
+ {Name: " _", Num: -1},
+ {Name: "_ ", Num: -1},
+ {Name: "_1", Num: -1},
+ {Name: "1_", Num: -1},
+}
+
+var invalidCells = []string{"", "A", "AA", " A", "A ", "1A", "A1A", "A1 ", " A1", "1A1", "a-1", "A-1"}
+
+var invalidIndexes = []int{-100, -2, -1, 0}
+
+func TestColumnNameToNumber_OK(t *testing.T) {
+ const msg = "Column %q"
+ for _, col := range validColumns {
+ out, err := ColumnNameToNumber(col.Name)
+ if assert.NoErrorf(t, err, msg, col.Name) {
+ assert.Equalf(t, col.Num, out, msg, col.Name)
+ }
}
+}
+
+func TestColumnNameToNumber_Error(t *testing.T) {
+ const msg = "Column %q"
+ for _, col := range invalidColumns {
+ out, err := ColumnNameToNumber(col.Name)
+ if assert.Errorf(t, err, msg, col.Name) {
+ assert.Equalf(t, col.Num, out, msg, col.Name)
+ }
+ assert.Panicsf(t, func() {
+ MustColumnNameToNumber(col.Name)
+ }, msg, col.Name)
+ }
+}
- for i, trueExpectedInput := range trueExpectedInputList {
- t.Run(fmt.Sprintf("TestData%d", i), func(t *testing.T) {
- assert.True(t, axisLowerOrEqualThan(trueExpectedInput[0], trueExpectedInput[1]))
- })
+func TestColumnNumberToName_OK(t *testing.T) {
+ const msg = "Column %q"
+ for _, col := range validColumns {
+ out, err := ColumnNumberToName(col.Num)
+ if assert.NoErrorf(t, err, msg, col.Name) {
+ assert.Equalf(t, strings.ToUpper(col.Name), out, msg, col.Name)
+ }
}
}
-func TestAxisLowerOrEqualThanIsFalse(t *testing.T) {
- falseExpectedInputList := [][2]string{
- {"B", "A"},
- {"AA", "A"},
- {"AA", "B"},
- {"ABCD", "AB"},
- {"2", "1"},
- {"11", "2"},
+func TestColumnNumberToName_Error(t *testing.T) {
+ out, err := ColumnNumberToName(-1)
+ if assert.Error(t, err) {
+ assert.Equal(t, "", out)
}
- for i, falseExpectedInput := range falseExpectedInputList {
- t.Run(fmt.Sprintf("TestData%d", i), func(t *testing.T) {
- assert.False(t, axisLowerOrEqualThan(falseExpectedInput[0], falseExpectedInput[1]))
- })
+ out, err = ColumnNumberToName(0)
+ if assert.Error(t, err) {
+ assert.Equal(t, "", out)
}
}
-func TestGetCellColRow(t *testing.T) {
- cellExpectedColRowList := [][3]string{
- {"C220", "C", "220"},
- {"aaef42", "aaef", "42"},
- {"bonjour", "bonjour", ""},
- {"59", "", "59"},
- {"", "", ""},
+func TestSplitCellName_OK(t *testing.T) {
+ const msg = "Cell \"%s%d\""
+ for i, col := range validColumns {
+ row := i + 1
+ c, r, err := SplitCellName(col.Name + strconv.Itoa(row))
+ if assert.NoErrorf(t, err, msg, col.Name, row) {
+ assert.Equalf(t, col.Name, c, msg, col.Name, row)
+ assert.Equalf(t, row, r, msg, col.Name, row)
+ }
+ }
+}
+
+func TestSplitCellName_Error(t *testing.T) {
+ const msg = "Cell %q"
+ for _, cell := range invalidCells {
+ c, r, err := SplitCellName(cell)
+ if assert.Errorf(t, err, msg, cell) {
+ assert.Equalf(t, "", c, msg, cell)
+ assert.Equalf(t, -1, r, msg, cell)
+ }
+ }
+}
+
+func TestJoinCellName_OK(t *testing.T) {
+ const msg = "Cell \"%s%d\""
+
+ for i, col := range validColumns {
+ row := i + 1
+ cell, err := JoinCellName(col.Name, row)
+ if assert.NoErrorf(t, err, msg, col.Name, row) {
+ assert.Equalf(t, strings.ToUpper(fmt.Sprintf("%s%d", col.Name, row)), cell, msg, row)
+ }
+ }
+}
+
+func TestJoinCellName_Error(t *testing.T) {
+ const msg = "Cell \"%s%d\""
+
+ test := func(col string, row int) {
+ cell, err := JoinCellName(col, row)
+ if assert.Errorf(t, err, msg, col, row) {
+ assert.Equalf(t, "", cell, msg, col, row)
+ }
+ }
+
+ for _, col := range invalidColumns {
+ test(col.Name, 1)
+ for _, row := range invalidIndexes {
+ test("A", row)
+ test(col.Name, row)
+ }
+ }
+
+}
+
+func TestCellNameToCoordinates_OK(t *testing.T) {
+ const msg = "Cell \"%s%d\""
+ for i, col := range validColumns {
+ row := i + 1
+ c, r, err := CellNameToCoordinates(col.Name + strconv.Itoa(row))
+ if assert.NoErrorf(t, err, msg, col.Name, row) {
+ assert.Equalf(t, col.Num, c, msg, col.Name, row)
+ assert.Equalf(t, i+1, r, msg, col.Name, row)
+ }
+ }
+}
+
+func TestCellNameToCoordinates_Error(t *testing.T) {
+ const msg = "Cell %q"
+ for _, cell := range invalidCells {
+ c, r, err := CellNameToCoordinates(cell)
+ if assert.Errorf(t, err, msg, cell) {
+ assert.Equalf(t, -1, c, msg, cell)
+ assert.Equalf(t, -1, r, msg, cell)
+ }
+ assert.Panicsf(t, func() {
+ MustCellNameToCoordinates(cell)
+ }, msg, cell)
+ }
+}
+
+func TestCoordinatesToCellName_OK(t *testing.T) {
+ const msg = "Coordinates [%d, %d]"
+ for i, col := range validColumns {
+ row := i + 1
+ cell, err := CoordinatesToCellName(col.Num, row)
+ if assert.NoErrorf(t, err, msg, col.Num, row) {
+ assert.Equalf(t, strings.ToUpper(col.Name+strconv.Itoa(row)), cell, msg, col.Num, row)
+ }
+ }
+}
+
+func TestCoordinatesToCellName_Error(t *testing.T) {
+ const msg = "Coordinates [%d, %d]"
+
+ test := func(col, row int) {
+ cell, err := CoordinatesToCellName(col, row)
+ if assert.Errorf(t, err, msg, col, row) {
+ assert.Equalf(t, "", cell, msg, col, row)
+ }
+ assert.Panicsf(t, func() {
+ MustCoordinatesToCellName(col, row)
+ }, msg, col, row)
}
- for i, test := range cellExpectedColRowList {
- t.Run(fmt.Sprintf("TestData%d", i), func(t *testing.T) {
- col, row := getCellColRow(test[0])
- assert.Equal(t, test[1], col, "Unexpected col")
- assert.Equal(t, test[2], row, "Unexpected row")
- })
+ for _, col := range invalidIndexes {
+ test(col, 1)
+ for _, row := range invalidIndexes {
+ test(1, row)
+ test(col, row)
+ }
}
}
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-16 04:22:30 +0000