univer icon indicating copy to clipboard operation
univer copied to clipboard

[Bug] When importing a document whose data validation is a custom formula, no warning is displayed for cells with invalid data.

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

导入后原本无效的数据不显示警告 样张:https://dev.univer.plus/sheet/?unit=GLpQBajhRTmQrGlnwWrqIw&type=2&subunit=O2m6ix42zxbFhAv80CwRQ image

System information

No response

oumomomo avatar Apr 30 '24 07:04 oumomomo

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

Origin Title: [Bug] 导入数据验证为自定义公式的文档,数据无效的单元格未展示警告

Title: [Bug] When importing a document whose data validation is a custom formula, no warning is displayed for cells with invalid data.


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. Add new data verification as custom formula
  2. Set the application scope = a certain selection and then export
  3. View data verification after importing the document

Expected behavior

Invalid data display warning

Actual behavior

No warning is displayed for data that was originally invalid after importing Sample: https://dev.univer.plus/sheet/?unit=GLpQBajhRTmQrGlnwWrqIw&type=2&subunit=O2m6ix42zxbFhAv80CwRQ image

System information

No response

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

已经无法在dev中复现

weird94 avatar Sep 12 '24 17:09 weird94

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

It can no longer be reproduced in dev

univer-bot[bot] avatar Sep 12 '24 17:09 univer-bot[bot]