univer icon indicating copy to clipboard operation
univer copied to clipboard

[Bug] Invalid values ​​calculated using formulas are not prohibited from entering

Open oumomomo opened this issue 9 months ago • 1 comments

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、使用公式计算出设置的值

Expected behavior

使用公式计算的值被禁止输入

Actual behavior

326350876-f7abff3c-2cab-4935-97a5-a8fa8ad3b21d.webm 使用公式计算的值不会被禁止输入

System information

No response

oumomomo avatar Apr 30 '24 09:04 oumomomo

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

Origin Title: [Bug] 使用公式计算的无效值不会被禁止输入

Title: [Bug] Invalid values ​​calculated using formulas are not prohibited from entering


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. Set data validation to invalid data - reject input
  2. Set the data to a certain value and click Confirm to save.
  3. Use the formula to calculate the set value

Expected behavior

Values ​​calculated using formulas are prohibited from entry

Actual behavior

326350876-f7abff3c-2cab-4935-97a5-a8fa8ad3b21d.webm Values ​​calculated using formulas are not blocked from entry

System information

No response

univer-bot[bot] avatar Apr 30 '24 09:04 univer-bot[bot]