diff options
| author | xuri <xuri.me@gmail.com> | 2020-01-23 10:20:03 +0800 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-01-23 10:20:03 +0800 |
| commit | a691c1048d2575d70ce97d2da80c2c40a2c37fb2 (patch) | |
| tree | 45bf129232779f754af4a51e988a5d838e36ff83 /col_test.go | |
| parent | cbc3fd21b79fbb819c1c341fc825701c04a0b473 (diff) | |
| parent | 68754a2075f12ba3c2bdf3646e4a3e7a3fd829f5 (diff) | |
Merge pull request #565 from Amodio/master
SetColVisible() can parse a column range + typos.
Diffstat (limited to 'col_test.go')
| -rw-r--r-- | col_test.go | 28 |
1 files changed, 26 insertions, 2 deletions
diff --git a/col_test.go b/col_test.go index cdb7edf..08fac1c 100644 --- a/col_test.go +++ b/col_test.go @@ -12,17 +12,41 @@ func TestColumnVisibility(t *testing.T) { f, err := prepareTestBook1() assert.NoError(t, err) + // Hide/display a column with SetColVisible assert.NoError(t, f.SetColVisible("Sheet1", "F", false)) assert.NoError(t, f.SetColVisible("Sheet1", "F", true)) visible, err := f.GetColVisible("Sheet1", "F") assert.Equal(t, true, visible) assert.NoError(t, err) - // Test get column visiable on not exists worksheet. + // Test hiding a few columns SetColVisible(...false)... + assert.NoError(t, f.SetColVisible("Sheet1", "F:V", false)) + visible, err = f.GetColVisible("Sheet1", "F") + assert.Equal(t, false, visible) + assert.NoError(t, err) + visible, err = f.GetColVisible("Sheet1", "U") + assert.Equal(t, false, visible) + assert.NoError(t, err) + visible, err = f.GetColVisible("Sheet1", "V") + assert.Equal(t, false, visible) + assert.NoError(t, err) + // ...and displaying them back SetColVisible(...true) + assert.NoError(t, f.SetColVisible("Sheet1", "F:V", true)) + visible, err = f.GetColVisible("Sheet1", "F") + assert.Equal(t, true, visible) + assert.NoError(t, err) + visible, err = f.GetColVisible("Sheet1", "U") + assert.Equal(t, true, visible) + assert.NoError(t, err) + visible, err = f.GetColVisible("Sheet1", "G") + assert.Equal(t, true, visible) + assert.NoError(t, err) + + // Test get column visible on an inexistent worksheet. _, err = f.GetColVisible("SheetN", "F") assert.EqualError(t, err, "sheet SheetN is not exist") - // Test get column visiable with illegal cell coordinates. + // Test get column visible with illegal cell coordinates. _, err = f.GetColVisible("Sheet1", "*") assert.EqualError(t, err, `invalid column name "*"`) assert.EqualError(t, f.SetColVisible("Sheet1", "*", false), `invalid column name "*"`) |