[Bug] When importing a document with data validation set but not edited, and adding rows and columns, the selection within the data validation will change accordingly.

[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、框选B1单元格新增数据验证 2、不在单元格内输入内容直接导出 3、导入该表后在B1单元格插入列 4、观察数据验证内的应用范围

Expected behavior

预期是新增列到B1时应用范围不变嘛？

Actual behavior

新增B1列时，应用范围显示为C1 样张：https://staging.univer.plus/?unit=zE36he-kR6O41AUPpcJNQw&type=2&subunit=uni1

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 document with data validation set but not edited, and adding rows and columns, the selection within the data validation will change accordingly.

---

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. Frame-select cell B1 to add new data for verification
2. Export directly without entering content in the cell.
3. After importing the table, insert a column in cell B1
4. Observe the scope of application within data verification

Expected behavior

Is it expected that the application scope will not change when the column is added to B1?

Actual behavior

When adding column B1, the application scope is displayed as C1 Sample: https://staging.univer.plus/?unit=zE36he-kR6O41AUPpcJNQw&type=2&subunit=uni1

System information

No response

[DR-Univer]

这个问题应该是ref的变更文本，与导入导出无关

[univer-bot[bot]]

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

This problem should be the change text of ref and has nothing to do with import and export.