[Bug] Documents containing data validation-checkboxes will become drop-down menus after exporting and then importing.

[oumomomo]

Before you submit this issue, have you checked the following

• [X] Is this really a problem?
• [X] I have searched the Github Issues for similar issues, but did not find anything.

Affected packages and versions

dev

Reproduction link

操作步骤： 1、新增数据验证，选择下拉菜单-多选-引用数据 2、框选范围后设置选项颜色点击确认 3、在单元格内选择多个选项 4、将文档导出后导入

Expected behavior

导入后下拉菜单-多选胶囊颜色被保存

Actual behavior

导入后下拉菜单-多选胶囊颜色未被保存 样张：https://staging.univer.plus/?unit=SlyuInCYQjCCa_gDtc2Ftw&type=2&subunit=sheet-1

System information

No response

[univer-bot[bot]]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

Origin Title: [Bug] 包含数据验证-复选框的文档导出后再导入会变成下拉菜单

Title: [Bug] Documents containing data validation-checkboxes will become drop-down menus after exporting and then importing.

---

Before you submit this issue, have you checked the following

• [X] Is this really a problem?
• [X] I have searched the Github Issues for similar issues, but did not find anything.

Affected packages and versions

dev

Reproduction link

Steps:

1. Add data verification, select drop-down menu-multiple selection-reference data
2. After selecting the range, set the option color and click Confirm.
3. Select multiple options within a cell
4. Export the document and then import it

Expected behavior

Drop-down menu after import - multi-select capsule color is saved

Actual behavior

Drop-down menu after import - multi-select capsule color is not saved Sample sheet: https://staging.univer.plus/?unit=SlyuInCYQjCCa_gDtc2Ftw&type=2&subunit=sheet-1

System information

No response

[DR-Univer]

这个应该符合预期，因为excel不支持胶囊颜色，得想办法在excel内生成一个custom-node来保存颜色信息。目前暂时不支持

[univer-bot[bot]]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

This should be in line with expectations, because excel does not support capsule color, so you have to find a way to generate a custom-node in excel to save the color information. Currently not supported