[Bug] When importing a table containing multiple settings in data validation, some settings are not saved.

[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、 1、数据验证设置为数据无效时-拒绝输入 2、在文字提示内输入内容后导出该表 3、导入该表后查看刚刚设置的数据验证

问题2、 1、条件类型设置为下拉菜单 2、高级设置-显示样式设置为箭头&纯文本后导入该表 3、导入该表后查看刚刚设置的数据验证

Expected behavior

预期是导入后设置均跟之前保持一致嘛？

Actual behavior

导入后，数据无效时恢复成了显示警告，输入的文字提示也被清空、显示样式均恢复成条状标签 样张：https://staging.univer.plus/?unit=T0wjUPp3QmOrnrTwmVmXPg&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] When importing a table containing multiple settings in data validation, some settings are not saved.

---

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

Question 1,

1. When data validation is set to invalid data - input is rejected
2. Enter the content in the text prompt and export the table.
3. After importing the table, view the data validation just set

Question 2.

1. Set the condition type to drop-down menu
2. Advanced Settings - Set the display style to arrow & plain text and then import the table
3. After importing the table, view the data validation just set

Expected behavior

Is it expected that the settings after importing will remain the same as before?

Actual behavior

After importing, the display warning is restored when the data is invalid, the input text prompts are also cleared, and the display style is restored to a bar label. Sample sheet: https://staging.univer.plus/?unit=T0wjUPp3QmOrnrTwmVmXPg&type=2&subunit=sheet-1

System information

No response

[DR-Univer]

在staging环境验证即可

[univer-bot[bot]]

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

Just verify it in the staging environment

[zhaolixin7]

@DR-Univer 导出后再导入显示样式不一致 导出表格：https://dev.univer.plus/sheet/?unit=CRBMCrJQRYuQwz75gezxJw&type=2&subunit=whMLKAu1ACsYlm1UkxJgl

[univer-bot[bot]]

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

@DR-Univer The display style is inconsistent after exporting and then importing Export table: https://dev.univer.plus/sheet/?unit=CRBMCrJQRYuQwz75gezxJw&type=2&subunit=whMLKAu1ACsYlm1UkxJgl