search

tealeg / xlsx

Go library for reading and writing XLSX files.
Other
5.81k stars 810 forks source link

fix datavalidation dorplist size #720

Closed yixinin closed 2 years ago

yixinin commented 3 years ago

ms office allow max 255 runes in datavalidation input, not 255 bytes.

yixinin commented 3 years ago

pls also fix v1 and v2 tag, thx!!!

rentiansheng commented 2 years ago

Is this an error caused by the encoding problem causing the character length to be different? I don't understand coding. 257 is the limit of ms office excel, if it exceeds the excel opening, it will need to be repaired

yixinin commented 2 years ago

实际上excel (office 2016)的数据校验是支持256个字符的，亲测，256个中文字符~~

rentiansheng commented 2 years ago

实际上excel (office 2016)的数据校验是支持256个字符的，亲测，256个中文字符~~

This is the problem of character set and encoding. I don’t know if there is a compatibility problem, such as across systems and machines. @yixinin