dream-num / univer

Univer is a full-stack productivity dev kit helping you integrate spreadsheets, docs and slides into your systems.
https://univer.ai
Apache License 2.0
7.02k stars 613 forks source link

[Bug] Merged cell border line rendering problem #2509

Open waterhydroxyl opened 4 months ago

waterhydroxyl commented 4 months ago

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

受影响的包和版本

https://univer.ai/zh-CN/examples/sheets

复现链接

1、对某块区域单元格进行合并操作(全部合并)。 2、对同区域设置边框(所有边框)。 3、在合并单元格的相邻区域设置边框(空边框)。

预期行为

excel对应场景的预期表现 image

实际行为

合并单元格与区域相邻的列的边框线会被全部取消掉。 image

运行环境

Chrome

系统信息

System: OS: Windows 11 10.0.22631 CPU: (12) x64 12th Gen Intel(R) Core(TM) i5-12490F Memory: 7.76 GB / 31.82 GB Binaries: Node: 16.16.0 - C:\Program Files\nodejs\node.EXE Yarn: 1.22.22 - C:\Program Files\nodejs\yarn.CMD npm: 8.11.0 - C:\Program Files\nodejs\npm.CMD Browsers: Edge: Chromium (125.0.2535.92) Internet Explorer: 11.0.22621.3527

univer-bot[bot] commented 4 months ago

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

Origin Title: [Bug] 合并单元格边框线渲染问题

Title: [Bug] Merged cell border line rendering problem


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

Affected packages and versions

https://univer.ai/zh-CN/examples/sheets

Recurrence link

  1. Merge cells in a certain area (merge all).
  2. Set borders (all borders) for the same area.
  3. Set a border (empty border) in the adjacent area of ​​the merged cells.

Expected behavior

The expected performance of excel corresponding to the scenario image

Actual behavior

The border lines of columns adjacent to merged cells and ranges will all be canceled. image

Running environment

Chrome

system message

System: OS: Windows 11 10.0.22631 CPU: (12) x64 12th Gen Intel(R) Core(TM) i5-12490F Memory: 7.76 GB / 31.82 GB Binaries: Node: 16.16.0 - C:\Program Files\nodejs\node.EXE Yarn: 1.22.22 - C:\Program Files\nodejs\yarn.CMD npm: 8.11.0 - C:\Program Files\nodejs\npm.CMD Browsers: Edge: Chromium (125.0.2535.92) Internet Explorer: 11.0.22621.3527

ybzky commented 4 months ago

@DR-Univer @lumixraku cc 数据应该是对的 应该是边框线的渲染规则不太一致

univer-bot[bot] commented 4 months ago

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

@DR-Univer @lumixraku cc The data should be correct. It should be that the rendering rules of the border lines are not consistent.

waterhydroxyl commented 4 months ago

还有这个操作场景,渲染结果也不符合预期 image

univer-bot[bot] commented 4 months ago

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

There is also this operation scenario, and the rendering results are not as expected. image

lumixraku commented 1 month ago

Consistent with Google Sheets, but different from Excel. It is designed this way.

image
waterhydroxyl commented 1 month ago

If I perform the same operation in Google Sheets, the border lines do not change in any way. However, the expected scenario is to match Excel. I tried Tencent Docs, and it also allows clearing some border lines of merged cells. image