Bug 155466 - Calc: Merging cells with outside border only would make the right (and bottom) border disappeared
Summary: Calc: Merging cells with outside border only would make the right (and bottom...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Merge-Split
  Show dependency tree / graph
 
Reported: 2023-05-24 02:39 UTC by Franklin Weng
Modified: 2023-07-15 04:16 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
test border after merging cells (8.19 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-05-24 02:39 UTC, Franklin Weng 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.