The droplist length is limited to 258 bytes in creating validation, what is the purpose of the limitation, is there a way to set a longer droplist

[wsyzxcn]

No description provided.

[painkuter]

You can create list on hidden sheet, then add excelize.DefinedName and formula with it:

definedName := &excelize.DefinedName{
	Name:     "uname",
	Comment:  "comment,
	RefersTo: "HiddenSheet!$A$1:$A$10",
	Scope:    "",
}
err := f.SetDefinedName(definedName)
if err != nil {
	return nil, err
}
validation := excelize.NewDataValidation(true)
validation.Formula1 = fmt.Sprintf("<formula1>%s</formula1>", definedName.Name)
validation.Sqref = "B1:B1"
validation.Type = "list"