univer
univer copied to clipboard
[Bug] Documents containing data validation-checkboxes will become drop-down menus after exporting and then importing.
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、保存后导出文档 4、再导入文档
Expected behavior
导入后复选框保持不变
Actual behavior
导入后复选框变成了下拉菜单
样张:https://staging.univer.plus/?unit=1779242142480151164&type=2&subunit=sheet-1
System information
No response
Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑🤝🧑👫🧑🏿🤝🧑🏻👩🏾🤝👨🏿👬🏿
Origin Title: [Bug] 包含数据验证-复选框的文档导出后再导入会变成下拉菜单
Title: [Bug] Documents containing data validation-checkboxes will become drop-down menus after exporting and then importing.
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:
- Added data verification
- Set the box selection range to check box
- Export the document after saving
- Then import the document
Expected behavior
Checkboxes remain unchanged after importing
Actual behavior
After importing, the checkbox becomes a drop-down menu
Sample sheet: https://staging.univer.plus/?unit=1779242142480151164&type=2&subunit=sheet-1
System information
No response
符合预期,因为excel不支持单选框,导出后信息丢失了。需要在excel内支持custome-node 来支持
Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑🤝🧑👫🧑🏿🤝🧑🏻👩🏾🤝👨🏿👬🏿
In line with expectations, because Excel does not support radio buttons, the information is lost after exporting. Need to support custome-node in excel to support