univer icon indicating copy to clipboard operation
univer copied to clipboard

[Bug] Documents containing data validation-checkboxes will become drop-down menus after exporting and then importing.

Open oumomomo opened this issue 9 months ago • 3 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、保存后导出文档 4、再导入文档

Expected behavior

导入后复选框保持不变

Actual behavior

导入后复选框变成了下拉菜单 样张:https://staging.univer.plus/?unit=1779242142480151164&type=2&subunit=sheet-1 image

System information

No response

oumomomo avatar Apr 29 '24 12:04 oumomomo

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:

  1. Added data verification
  2. Set the box selection range to check box
  3. Export the document after saving
  4. 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 image

System information

No response

univer-bot[bot] avatar Apr 29 '24 12:04 univer-bot[bot]

符合预期,因为excel不支持单选框,导出后信息丢失了。需要在excel内支持custome-node 来支持

DR-Univer avatar Jun 29 '24 11:06 DR-Univer

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

univer-bot[bot] avatar Jun 29 '24 11:06 univer-bot[bot]