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 treegraph
 
Reported: 2023-05-24 02:39 UTC by Franklin Weng
Modified: 2025-07-16 12:06 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

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.
Comment 5 QA Administrators 2025-07-15 03:11:46 UTC Comment hidden (obsolete)
Comment 6 Franklin Weng 2025-07-15 03:16:20 UTC
(In reply to QA Administrators from comment #5)
> Dear Franklin Weng,
> 
> To make sure we're focusing on the bugs that affect our users today,
> LibreOffice QA is asking bug reporters and confirmers to retest open,
> confirmed bugs which have not been touched for over a year.
> 
> There have been thousands of bug fixes and commits since anyone checked on
> this bug report. During that time, it's possible that the bug has been
> fixed, or the details of the problem have changed. We'd really appreciate
> your help in getting confirmation that the bug is still present.
> 
> If you have time, please do the following:
> 
> Test to see if the bug is still present with the latest version of
> LibreOffice from https://www.libreoffice.org/download/
> 
> If the bug is present, please leave a comment that includes the information
> from Help - About LibreOffice.
>  

Still reproducible in

Version: 25.2.2.2 (X86_64) / LibreOffice Community
Build ID: 7370d4be9e3cf6031a51beef54ff3bda878e3fac
CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb)
Locale: zh-TW (zh_TW.UTF-8); UI: zh-TW
Calc: threaded
Comment 7 Takenori Yasuda 2025-07-15 03:51:04 UTC
Excuse me, is Bug 167510 the same as this one?