Issue 5489 - Merging cells can erase the borders of the cells on the far right and lower edge of the selected area. Excel in contrast maintains the outside borders.
Summary: Merging cells can erase the borders of the cells on the far right and lower e...
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 1.0.0
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: ms_interoperability, rfe_eval_ok, usability
: 5490 (view as issue list)
Depends on:
Reported: 2002-06-02 11:06 UTC by Unknown
Modified: 2013-08-07 15:12 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2002-06-02 11:06:32 UTC
First : I don't know the word used for the french term "Cellules fusionnées", so
I call it "joined cells"

Make a border on a table, then join all the cells in a row of this table.
Only the left border will be kept, the right one will disappear (I suppose the
created cell take the format of the left cell, which is right, except for the
right border of course)

The same problem exists vertically.

Tested on Ooo1.0 under NT4 SP6 and Linux MDK 8.2.

I don'k know how M$ Excel does that.
Comment 1 peter.junge 2002-06-10 15:16:32 UTC
Hi Christophe,
I guess (being not an native speaker too) joined cells is OK but we
use to call them merged cells.

- Select range
- Define Border
- Merge top row
-> Right border disappears

Excel handles it correct.

Best regards, Peter
Comment 2 niklas.nebel 2002-06-26 19:37:29 UTC
It works as intended. When cells are merged, the top left cell is
displayed in the whole merged area, including its formatting like borders.
Comment 3 Unknown 2002-06-26 19:45:19 UTC
IMHO it's a shame. When the user chooses to merge cells, 
he wants to merge cells, not to suppress borders.
Comment 4 peter.junge 2002-06-27 07:56:27 UTC
Ok, in this case it's a poor design of the feature. This _*HAS*_ to
change. I declare this as enhancement. I declare as well that I will
strain nervs to get this issue done.

now you're the one to take action.

Best regards, Peter
P.S.: Christophe you're right.
Comment 5 peter.junge 2002-06-27 07:57:47 UTC
Forgot to change owner.
Comment 6 falko.tesch 2003-10-01 11:48:43 UTC
- Define a range of cells (A1 - D6)
- Add a border to this range
- Now one has a "bordered" range from A1 - D6
- Select A1 - D1 and combine those cells (Format - Merge)
- The right border in this row (1) is gone
While there is a good technical reason for this (the dominant merged
cell A1 has no right border) it is very confusing for the user.
We need to change this
Comment 7 falko.tesch 2003-10-01 11:48:56 UTC
Comment 8 falko.tesch 2003-10-01 11:50:02 UTC
*** Issue 5490 has been marked as a duplicate of this issue. ***
Comment 9 erwin.tenhumberg 2004-10-01 14:27:58 UTC
enhanced summary, set keywords and reassigned issue according to RFE process