Trouble using cell merge in Calc

Some months ago I asked a question about merging two or more rows of data. I thought I had the method worked out
using “merge” but I am having a problem.

This is my method-
Select cell 1 (row 1)
Slide right corner indicator to last cell (eg row 5) (same column)
1st cell now covers all cells selected
Click “Merge”
“Should contents of the hidden cells be moved into the first cell?”

Instead of all the cells appearing in cell 1, I get multiple copies of cell one only.
Am I doing the impossible or is there a setting I haven’t found ?

Thank-you anybody who may have an answer. Maurice.

I am using Libre Office on a Macbook OSX 10.6.8


i’m using LO with win xp.

In a sheet i’m feeling values 1,2,3,4,5 in the first row and clicking merge. I’m asked if i want the values of the cells into the first cell. I’m answering yes and as a result i have 1 2 3 4 5 in the cell A1.

The result is the same if i use text or if i use auto fill to instert values to the cells.

Perhaps try testing again with the 2nd and 4th columns hidden as the OP has indicated there are hidden columns and these may be influencing the outcome.

My mistake. I didn’t understand that there are hidden columns or rows. I tested again by hiding columns or rows and the result is the same. All the values can be seen in the cell A1 as i described to my answer. I tested it by inserting values vertically (A1,A2,A3,A4,A5) and horizontally (A1,B1,C1,D1,E1).

Hi- Thanks for the comments. I have found a work around which works .

  1. Select 1st Row

  2. Slide right corner indicator to last Row - 1st Row now covers all rows.

  3. “Edit” “Undo Fill” - Uncovers all Rows but leaves them as highlighted.

  4. “Format” “Merge Cells” “Merge Cells”

  5. “Should contents of the hidden cells be moved into the first cell”

  6. “Yes”

  7. “Edit” “Delete” - all Rows except the newly merged first one.

A bit messy but it does what I want. Maurice.