From f0244c00161ad6372ceb1ec951f3a82c741cd46a Mon Sep 17 00:00:00 2001 From: xuri Date: Sun, 24 Mar 2019 13:08:32 +0800 Subject: Add unit test to improve testing coverage --- adjust_test.go | 66 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 66 insertions(+) create mode 100644 adjust_test.go (limited to 'adjust_test.go') diff --git a/adjust_test.go b/adjust_test.go new file mode 100644 index 0000000..104eff9 --- /dev/null +++ b/adjust_test.go @@ -0,0 +1,66 @@ +package excelize + +import ( + "testing" + + "github.com/stretchr/testify/assert" +) + +func TestAdjustMergeCells(t *testing.T) { + f := NewFile() + // testing adjustAutoFilter with illegal cell coordinates. + assert.EqualError(t, f.adjustMergeCells(&xlsxWorksheet{ + MergeCells: &xlsxMergeCells{ + Cells: []*xlsxMergeCell{ + &xlsxMergeCell{ + Ref: "A:B1", + }, + }, + }, + }, rows, 0, 0), `cannot convert cell "A" to coordinates: invalid cell name "A"`) + assert.EqualError(t, f.adjustMergeCells(&xlsxWorksheet{ + MergeCells: &xlsxMergeCells{ + Cells: []*xlsxMergeCell{ + &xlsxMergeCell{ + Ref: "A1:B", + }, + }, + }, + }, rows, 0, 0), `cannot convert cell "B" to coordinates: invalid cell name "B"`) +} + +func TestAdjustAutoFilter(t *testing.T) { + f := NewFile() + // testing adjustAutoFilter with illegal cell coordinates. + assert.EqualError(t, f.adjustAutoFilter(&xlsxWorksheet{ + AutoFilter: &xlsxAutoFilter{ + Ref: "A:B1", + }, + }, rows, 0, 0), `cannot convert cell "A" to coordinates: invalid cell name "A"`) + assert.EqualError(t, f.adjustAutoFilter(&xlsxWorksheet{ + AutoFilter: &xlsxAutoFilter{ + Ref: "A1:B", + }, + }, rows, 0, 0), `cannot convert cell "B" to coordinates: invalid cell name "B"`) +} + +func TestAdjustHelper(t *testing.T) { + f := NewFile() + f.Sheet["xl/worksheets/sheet1.xml"] = &xlsxWorksheet{ + MergeCells: &xlsxMergeCells{ + Cells: []*xlsxMergeCell{ + &xlsxMergeCell{ + Ref: "A:B1", + }, + }, + }, + } + f.Sheet["xl/worksheets/sheet2.xml"] = &xlsxWorksheet{ + AutoFilter: &xlsxAutoFilter{ + Ref: "A1:B", + }, + } + // testing adjustHelper with illegal cell coordinates. + assert.EqualError(t, f.adjustHelper("sheet1", rows, 0, 0), `cannot convert cell "A" to coordinates: invalid cell name "A"`) + assert.EqualError(t, f.adjustHelper("sheet2", rows, 0, 0), `cannot convert cell "B" to coordinates: invalid cell name "B"`) +} -- cgit v1.2.1