Bug 155466

Summary: Calc: Merging cells with outside border only would make the right (and bottom) border disappeared
Product: LibreOffice Reporter: Franklin Weng <franklin>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: buzea.bogdan, miguelangelrv
Priority: medium    
Version: 3.6.7.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108320    
Attachments: test border after merging cells

Description Franklin Weng 2023-05-24 02:39:35 UTC
Description:
Merging cells with outside border only would make the right (and bottom) border disappeared.  Different results from different border type.  For some border type the right and bottom border would disappear after merging; for some other (thicker) border type would make right border disappeared, but bottom border still there just thinner.

Steps to Reproduce:
1. Start a new Calc spreadsheet
2. Mark a range (say, B3:F12)
3. Set up a border with outside only (no inner grid)
4. Merge these cells

Actual Results:
The right (and sometimes bottom also) border would disappear

Expected Results:
The border should be complete


Reproducible: Always


User Profile Reset: No

Additional Info:
Earliest tested version: 版本 3.6.7.2 (組建 ID:e183d5b)

Should be inherited from OOo
Comment 1 Franklin Weng 2023-05-24 02:39:57 UTC
Created attachment 187470 [details]
test border after merging cells
Comment 2 m_a_riosv 2023-05-24 12:09:09 UTC
Seems because of the right border, it's inherited from the first cell in the merged range, not from the last.
Comment 3 ferhataslan1398 2023-06-23 17:31:31 UTC
After checking the last month's unconfirmed bugs, it was found out that the bug report is not duplicate. 

As a result of of reproducing the bug with stable and master build, it has been confirmed that the bug report is correct. 

Actual and expected results are different as mentioned by Franklin Weng. Merging cells with outside border only would make the right (and bottom) border disappeared.

Therefore the status has been changed to "NEW" from "unconfirmed".
Comment 4 ady 2023-06-24 00:31:36 UTC
(In reply to Franklin Weng from comment #0)
> Actual Results:
> The right (and sometimes bottom also) border would disappear

Right and bottom sides are the corresponding left and top sides of the adjacent surrounding cells.

BTW, the "_sometimes_ bottom also" comment is just a graphical glitch; simply scroll down and up again so to refresh the screen and you should see that the bottom border is not there, just the same as the right side border of the merged range.

Now, if the right and bottom borders are kept after merging, some users will report that the borders of the surrounding cells are lost, and such behavior would be unexpected.