[Bug] Data validation is set to integer - not between, and an error will be prompted when entering a matching value

[oumomomo]

Before you submit this issue, have you checked the following

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

Affected packages and versions

dev

Reproduction link

问题1、
操作步骤：
1、数据验证框选某单元格设置为整数-未介于1与5之间
2、在框选的单元格内输入1-5范围外的数值

问题2、
操作步骤：
1、数据验证框选某单元格设置为文本长度-未介于1与3之间
2、在框选的单元格内输入1-范围外的数值

问题3
操作步骤：
1、数据验证框选某个单元格设置为日期-未介于某时间段与某时间段
2、在框选的单元格内选择范围外的日期

Expected behavior

问题1：
可以正常输入1-5范围外的值

问题2：
不能输入介于1-3之间的长度，可以输入1-3范围外的长度

问题3、
选择范围外的日期会正常提示报错

Actual behavior

问题1、
输入1-5范围外的值会有报错
2024_4_29 15_24_24 commands.json
提示

问题2、可以输入介于1-3之间的长度，输入1-3范围外的长度会报错

Uploading 2024_4_29 15_53_02 video.webm…

问题3、选择无效的日期，也不会有报错提示
Uploading 2024_4_29 16_28_48 video.webm…

System information

No response

[univer-bot]

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

Origin Title: [Bug]数据验证设置为整数-未介于，输入符合的值会提示错误

Title: [Bug] Data validation is set to integer - not between, and an error will be prompted when entering a matching value

---

Before you submit this issue, have you checked the following

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

Affected packages and versions

dev

Reproduction link

Question 1,
Steps:

1. Data validation box selects a cell and sets it to an integer - not between 1 and 5
2. Enter a value outside the range of 1-5 in the selected cell.

Question 2.
Steps:

1. Data validation box selects a cell and sets the text length - not between 1 and 3
2. Enter a value outside the range from 1 to the selected cell.

Question 3
Steps:

1. Data validation box selects a cell and sets it as date - not between a certain time period and a certain time period
2. Select dates outside the range in the selected cells.

Expected behavior

Question 1:
Values ​​outside the range of 1-5 can be entered normally

Question 2:
You cannot enter a length between 1-3. You can enter a length outside the range of 1-3.

Question 3.
If you select a date outside the range, an error will be reported normally.

Actual behavior

Question 1,
If you enter a value outside the range of 1-5, an error will be reported.
2024_4_29 15_24_24 commands.json
hint

Question 2. You can enter a length between 1-3. If you enter a length outside the range of 1-3, an error will be reported.

Uploading 2024_4_29 15_53_02 video.webm…

Question 3. If you select an invalid date, there will be no error message.
Uploading 2024_4_29 16_28_48 video.webm…

System information

No response

[oumomomo]

问题3选择无效的日期还是无报错

[univer-bot]

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

Question 3: No error is reported when selecting an invalid date