diff options
| author | xuri <xuri.me@gmail.com> | 2021-02-02 22:23:16 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2021-02-02 22:23:16 +0800 |
| commit | 1f329e8f968014e26351a729ba7e6e3c846e96db (patch) | |
| tree | 16d5e3629e071eb313e914badd6ec55f369c004e /sheet_test.go | |
| parent | db7b4ee36200df4b4838c2111e81808016b4f6ef (diff) | |
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`
Diffstat (limited to 'sheet_test.go')
| -rw-r--r-- | sheet_test.go | 13 |
1 files changed, 13 insertions, 0 deletions
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) { |