xuri
f58dabd492
* Change `func (f *File) NewConditionalStyle(style string) (int, error)` to `func (f *File) NewConditionalStyle(style *Style) (int, error)` * Change `func (f *File) NewStyle(style interface{}) (int, error)` to `func (f *File) NewStyle(style *Style) (int, error)` * Change `func (f *File) AddChart(sheet, cell, opts string, combo ...string) error` to `func (f *File) AddChart(sheet, cell string, chart *ChartOptions, combo ...*ChartOptions) error` * Change `func (f *File) AddChartSheet(sheet, opts string, combo ...string) error` to `func (f *File) AddChartSheet(sheet string, chart *ChartOptions, combo ...*ChartOptions) error` * Change `func (f *File) AddShape(sheet, cell, opts string) error` to `func (f *File) AddShape(sheet, cell string, opts *Shape) error` * Change `func (f *File) AddPictureFromBytes(sheet, cell, opts, name, extension string, file []byte) error` to `func (f *File) AddPictureFromBytes(sheet, cell, name, extension string, file []byte, opts *PictureOptions) error` * Change `func (f *File) AddTable(sheet, hCell, vCell, opts string) error` to `func (f *File) AddTable(sheet, reference string, opts *TableOptions) error` * Change `func (sw *StreamWriter) AddTable(hCell, vCell, opts string) error` to `func (sw *StreamWriter) AddTable(reference string, opts *TableOptions) error` * Change `func (f *File) AutoFilter(sheet, hCell, vCell, opts string) error` to `func (f *File) AutoFilter(sheet, reference string, opts *AutoFilterOptions) error` * Change `func (f *File) SetPanes(sheet, panes string) error` to `func (f *File) SetPanes(sheet string, panes *Panes) error` * Change `func (sw *StreamWriter) AddTable(hCell, vCell, opts string) error` to `func (sw *StreamWriter) AddTable(reference string, opts *TableOptions) error` * Change `func (f *File) SetConditionalFormat(sheet, reference, opts string) error` to `func (f *File) SetConditionalFormat(sheet, reference string, opts []ConditionalFormatOptions) error` * Add exported types: * AutoFilterListOptions * AutoFilterOptions * Chart * ChartAxis * ChartDimension * ChartLegend * ChartLine * ChartMarker * ChartPlotArea * ChartSeries * ChartTitle * ConditionalFormatOptions * PaneOptions * Panes * PictureOptions * Shape * ShapeColor * ShapeLine * ShapeParagraph * TableOptions * This added support for set sheet visible as very hidden * Return error when missing required parameters for set defined name * Update unit test and comments
51 lines
1.7 KiB
Go
51 lines
1.7 KiB
Go
package excelize
|
|
|
|
import (
|
|
"testing"
|
|
|
|
"github.com/stretchr/testify/assert"
|
|
)
|
|
|
|
func TestSetView(t *testing.T) {
|
|
f := NewFile()
|
|
assert.NoError(t, f.SetSheetView("Sheet1", -1, nil))
|
|
ws, ok := f.Sheet.Load("xl/worksheets/sheet1.xml")
|
|
assert.True(t, ok)
|
|
ws.(*xlsxWorksheet).SheetViews = nil
|
|
expected := ViewOptions{
|
|
DefaultGridColor: boolPtr(false),
|
|
RightToLeft: boolPtr(false),
|
|
ShowFormulas: boolPtr(false),
|
|
ShowGridLines: boolPtr(false),
|
|
ShowRowColHeaders: boolPtr(false),
|
|
ShowRuler: boolPtr(false),
|
|
ShowZeros: boolPtr(false),
|
|
TopLeftCell: stringPtr("A1"),
|
|
View: stringPtr("normal"),
|
|
ZoomScale: float64Ptr(120),
|
|
}
|
|
assert.NoError(t, f.SetSheetView("Sheet1", 0, &expected))
|
|
opts, err := f.GetSheetView("Sheet1", 0)
|
|
assert.NoError(t, err)
|
|
assert.Equal(t, expected, opts)
|
|
// Test set sheet view options with invalid view index
|
|
assert.EqualError(t, f.SetSheetView("Sheet1", 1, nil), "view index 1 out of range")
|
|
assert.EqualError(t, f.SetSheetView("Sheet1", -2, nil), "view index -2 out of range")
|
|
// Test set sheet view options on not exists worksheet
|
|
assert.EqualError(t, f.SetSheetView("SheetN", 0, nil), "sheet SheetN does not exist")
|
|
}
|
|
|
|
func TestGetView(t *testing.T) {
|
|
f := NewFile()
|
|
_, err := f.getSheetView("SheetN", 0)
|
|
assert.EqualError(t, err, "sheet SheetN does not exist")
|
|
// Test get sheet view options with invalid view index
|
|
_, err = f.GetSheetView("Sheet1", 1)
|
|
assert.EqualError(t, err, "view index 1 out of range")
|
|
_, err = f.GetSheetView("Sheet1", -2)
|
|
assert.EqualError(t, err, "view index -2 out of range")
|
|
// Test get sheet view options on not exists worksheet
|
|
_, err = f.GetSheetView("SheetN", 0)
|
|
assert.EqualError(t, err, "sheet SheetN does not exist")
|
|
}
|