dream-num / univer

Univer is an open-source alternative to Google Sheets, Slides, and Docs
https://univer.ai
Apache License 2.0
6.24k stars 530 forks source link

[Bug] After exporting and then importing the conditional formatting data bar, the color color changes. #2149

Open zhaolixin7 opened 3 months ago

zhaolixin7 commented 3 months ago

在您提交此问题之前,您是否检查了以下内容?

受影响的包和版本

dev

复现链接

样张:https://dev.univer.plus/sheet/?unit=3k-KKwDGRmKubG98d9hfBg&type=2&subunit=yVg31OA238Taky-MpUl-b 1、导出样张后再导入

预期行为

数据条配色一致 image

实际行为

导入后的表格:https://dev.univer.plus/sheet/?unit=KvR9TaTrTsa73KaGAKjkVA&type=2&subunit=uni1 1、导入后数据条配色如截图、导出是黄绿配色,导入后是白绿配色 image

2、导出后再导入,规则的顺序反了(这个是否处理?) image

运行环境

No response

系统信息

No response

univer-bot[bot] commented 3 months ago

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

Origin Title: [Bug] 导出后再导入条件格式数据条配色变了

Title: [Bug] After exporting and then importing the conditional formatting data bar, the color color changes.


Before you submitted this question, did you check the following?

Affected packages and versions

dev

Recurrence link

Sample: https://dev.univer.plus/sheet/?unit=3k-KKwDGRmKubG98d9hfBg&type=2&subunit=yVg31OA238Taky-MpUl-b

  1. Export the sample and then import it

Expected behavior

The data strips have the same color image

Actual behavior

Imported table: https://dev.univer.plus/sheet/?unit=KvR9TaTrTsa73KaGAKjkVA&type=2&subunit=uni1

  1. After importing, the color of the data bar is as shown in the screenshot, exporting is yellow and green, and after importing is white and green. image

  2. After exporting and then importing, the order of the rules is reversed (will this be processed?) image

Running environment

No response

system message

No response

DR-Univer commented 1 month ago

https://staging.univer.plus/sheet/?unit=lYDE7lt0Tdu_f4ErIJO6zQ&type=2&subunit=S34gwbZJNxgOXAuo3BEXN

我用这个链接无法复现,是否还有其他步骤

univer-bot[bot] commented 1 month ago

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

https://staging.univer.plus/sheet/?unit=lYDE7lt0Tdu_f4ErIJO6zQ&type=2&subunit=S34gwbZJNxgOXAuo3BEXN

I can't reproduce it using this link. Are there any other steps?

zhaolixin7 commented 1 month ago

https://staging.univer.plus/sheet/?unit=lYDE7lt0Tdu_f4ErIJO6zQ&type=2&subunit=S34gwbZJNxgOXAuo3BEXN

我用这个链接无法复现,是否还有其他步骤 @DR-Univer 可以用新的链接复现(上面的链接已更新),之前的表格无权限打开了

univer-bot[bot] commented 1 month ago

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

https://staging.univer.plus/sheet/?unit=lYDE7lt0Tdu_f4ErIJO6zQ&type=2&subunit=S34gwbZJNxgOXAuo3BEXN

I can't reproduce using this link. Are there any other steps? @DR-Univer can be reproduced with a new link (the link above has been updated), the previous form does not have permission to open

zhaolixin7 commented 5 days ago

@DR-Univer 1、导出后再导入数据条颜色不对2、全部规则顺序与原表相反https://dev.univer.plus/sheet/?unit=3k-KKwDGRmKubG98d9hfBg&type=2&subunit=yVg31OA238Taky-MpUl-b image

univer-bot[bot] commented 5 days ago

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

@DR-Univer 1. The color of the data bar is wrong after exporting and then imported. 2. The order of all rules is opposite to the original table https://dev.univer.plus/sheet/?unit=3k-KKwDGRmKubG98d9hfBg&type=2&subunit=yVg31OA238Taky-MpUl-b image