[Bug] Data validation is set to Data Invalid-Reject Input, and values ​​calculated using formulas are not rejected.

[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

问题2、
操作步骤：
1、设置数据验证为数据无效-文字提示
2、输入无效的数字查看提示

问题3、
操作步骤：
1、设置数据验证为日期-数据无效时拒绝输入
2、输入无效的日期

Expected behavior

问题2、输入错误时显示设置好的提示语

问题3、通过日期选择器勾选的日期会弹窗拒绝输入

Actual behavior

问题2、
输入错误时未显示设置好的提示语
2024_4_29 15_00_18 video.webm

问题3、
通过日期选择器勾选的日期不会弹窗提示
Uploading 2024_4_29 16_18_55 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 Data Invalid-Reject Input, and values ​​calculated using formulas are not rejected.

---

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 2.
Steps:

1. Set data verification to invalid data - text prompt
2. Enter invalid numbers to view prompts

Question 3.
Steps:

1. Set data validation to date - reject input when data is invalid
2. Enter an invalid date

Expected behavior

Question 2. When an input error is made, the set prompt is displayed.

Problem 3. The date selected through the date picker will pop up to refuse input.

Actual behavior

Question 2.
The set prompt is not displayed when an input error is made.
2024_4_29 15_00_18 video.webm

Question 3.
The date selected through the date picker will not prompt a pop-up window
Uploading 2024_4_29 16_18_55 video.webm…

System information

No response