From 1f329e8f968014e26351a729ba7e6e3c846e96db Mon Sep 17 00:00:00 2001 From: xuri Date: Tue, 2 Feb 2021 22:23:16 +0800 Subject: This closes #774, closes #775 and closes #776 - correct adjust calculation chain in duplicate rows - correct adjust defined name in the workbook when delete worksheet - use absolute reference in the auto filters defined name to make it compatible with OpenOffice - API `CoordinatesToCellName` have a new optional param to specify if using an absolute reference format - Fix cyclomatic complexity issue of internal function `newFills` and `parseToken` --- sheet_test.go | 13 +++++++++++++ 1 file changed, 13 insertions(+) (limited to 'sheet_test.go') diff --git a/sheet_test.go b/sheet_test.go index d68327e..f218da7 100644 --- a/sheet_test.go +++ b/sheet_test.go @@ -383,6 +383,19 @@ func TestDeleteSheet(t *testing.T) { f.DeleteSheet("Sheet1") assert.Equal(t, "Sheet2", f.GetSheetName(f.GetActiveSheetIndex())) assert.NoError(t, f.SaveAs(filepath.Join("test", "TestDeleteSheet.xlsx"))) + // Test with auto filter defined names + f = NewFile() + f.NewSheet("Sheet2") + f.NewSheet("Sheet3") + assert.NoError(t, f.SetCellValue("Sheet1", "A1", "A")) + assert.NoError(t, f.SetCellValue("Sheet2", "A1", "A")) + assert.NoError(t, f.SetCellValue("Sheet3", "A1", "A")) + assert.NoError(t, f.AutoFilter("Sheet1", "A1", "A1", "")) + assert.NoError(t, f.AutoFilter("Sheet2", "A1", "A1", "")) + assert.NoError(t, f.AutoFilter("Sheet3", "A1", "A1", "")) + f.DeleteSheet("Sheet2") + f.DeleteSheet("Sheet1") + assert.NoError(t, f.SaveAs(filepath.Join("test", "TestDeleteSheet2.xlsx"))) } func BenchmarkNewSheet(b *testing.B) { -- cgit v1.2.1