dream-num / univer

Univer is an open-source productivity tool dev kit helping you integrate spreadsheets, docs and slides into your applications.
https://univer.ai
Apache License 2.0
6.93k stars 601 forks source link

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

Open oumomomo opened 6 months ago

oumomomo commented 6 months ago

Before you submit this issue, have you checked the following

Affected packages and versions

dev

Reproduction link

操作步骤: 1、新增数据验证,选择下拉菜单-多选-引用数据 2、框选范围后设置选项颜色点击确认 3、在单元格内选择多个选项 4、将文档导出后导入

Expected behavior

导入后下拉菜单-多选胶囊颜色被保存

Actual behavior

导入后下拉菜单-多选胶囊颜色未被保存 样张:https://staging.univer.plus/?unit=SlyuInCYQjCCa_gDtc2Ftw&type=2&subunit=sheet-1 image

System information

No response

univer-bot[bot] commented 6 months ago

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

Affected packages and versions

dev

Reproduction link

Steps:

  1. Add data verification, select drop-down menu-multiple selection-reference data
  2. After selecting the range, set the option color and click Confirm.
  3. Select multiple options within a cell
  4. Export the document and then import it

Expected behavior

Drop-down menu after import - multi-select capsule color is saved

Actual behavior

Drop-down menu after import - multi-select capsule color is not saved Sample sheet: https://staging.univer.plus/?unit=SlyuInCYQjCCa_gDtc2Ftw&type=2&subunit=sheet-1 image

System information

No response

DR-Univer commented 4 months ago

这个应该符合预期,因为excel不支持胶囊颜色,得想办法在excel内生成一个custom-node来保存颜色信息。目前暂时不支持

univer-bot[bot] commented 4 months ago

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

This should be in line with expectations, because excel does not support capsule color, so you have to find a way to generate a custom-node in excel to save the color information. Currently not supported