Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

#

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Jump to bottom

使用IImportResultFilter 动态生成模板时，MappingValues绑定的数据过大，报The total length of a DataValidation list cannot exceed 255 characters #196

Closed
Nokecy opened this issue Nov 24, 2020 · 2 comments · Fixed by #197
Closed

使用IImportResultFilter 动态生成模板时，MappingValues绑定的数据过大，报The total length of a DataValidation list cannot exceed 255 characters #196

Nokecy opened this issue Nov 24, 2020 · 2 comments · Fixed by #197
Labels
area-excel excel

Comments

@Nokecy
Copy link
Contributor

Nokecy commented Nov 24, 2020

版本 v2.4.0
@hueifeng hueifeng added the area-excel excel label Nov 24, 2020
@hueifeng
Copy link
Member

We did a survey and got the following.

The ListDataValidation rule is indeed limited to 255 symbols (including the commas). This is because in Excel itself you can only define a DataValidation List with no more than 255 symbols. Since Excel doesn’t support DataValidation Lists longer than 255 characters, our engine also can’t support it.

@Nokecy
Copy link
Contributor Author

Nokecy commented Nov 24, 2020

https://blog.csdn.net/wangchaox123/article/details/97787470
使用隐藏域是否可以规避

@Nokecy Nokecy mentioned this issue Nov 25, 2020
Merged
# for free to join this conversation on GitHub. Already have an account? # to comment
Assignees
No one assigned
Labels
area-excel excel
Projects
None yet
Milestone
No milestone
2 participants
@Nokecy @hueifeng