diff options
| author | xuri <xuri.me@gmail.com> | 2022-01-12 00:18:15 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2022-01-12 00:18:15 +0800 |
| commit | b96329cc88b87da25a4389f1d4d5ad08cd40605a (patch) | |
| tree | 4f05daa1402bbbd27bc35ecb7ad9e95b5cb31e76 /datavalidation.go | |
| parent | 891e5baac1a6ac67123fbc6a68f801720882b8ec (diff) | |
Breaking change for data validation and fixed #1117
- Remove second useless parameter `isCurrentSheet` of the function `SetSqrefDropList`
- Fix missing page setup of worksheet after re-saving the spreadsheet
Diffstat (limited to 'datavalidation.go')
| -rw-r--r-- | datavalidation.go | 12 |
1 files changed, 4 insertions, 8 deletions
diff --git a/datavalidation.go b/datavalidation.go index 4b0c4f3..c8c9141 100644 --- a/datavalidation.go +++ b/datavalidation.go @@ -168,16 +168,12 @@ func (dd *DataValidation) SetRange(f1, f2 interface{}, t DataValidationType, o D // // dvRange := excelize.NewDataValidation(true) // dvRange.Sqref = "A7:B8" -// dvRange.SetSqrefDropList("$E$1:$E$3", true) +// dvRange.SetSqrefDropList("$E$1:$E$3") // f.AddDataValidation("Sheet1", dvRange) // -func (dd *DataValidation) SetSqrefDropList(sqref string, isCurrentSheet bool) error { - if isCurrentSheet { - dd.Formula1 = fmt.Sprintf("<formula1>%s</formula1>", sqref) - dd.Type = convDataValidationType(typeList) - return nil - } - return fmt.Errorf("cross-sheet sqref cell are not supported") +func (dd *DataValidation) SetSqrefDropList(sqref string) { + dd.Formula1 = fmt.Sprintf("<formula1>%s</formula1>", sqref) + dd.Type = convDataValidationType(typeList) } // SetSqref provides function to set data validation range in drop list. |