Ask Your Question

How to split multiple rows in Calc?

asked 2015-02-11 09:31:43 +0100

aditsu gravatar image

updated 2015-02-20 14:17:37 +0100

I have a spreadsheet with about 20 rows, and I'd like to split each of them into 2 rows. The new rows should be merged with the current ones so the spreadsheet looks the same, or if not feasible, then every 2nd row could be empty.

Here are some examples:

Initial spreadsheet:

What I want to get:

Or alternatively, I could also use this:

The goal is to add some stuff on some of the cells in rows 2, 4, etc.

edit retag flag offensive close merge delete


It's a puzzle for me. 2nd image: If you actually have merged A1:A4, B1:C2 and B3:C4 - what sense in it? Double row height, double column width for B and omitting C would do everything not only simpler but better, too.

Lupp gravatar imageLupp ( 2015-02-20 14:58:55 +0100 )edit

@Lupp each cell has double the height (in rows) compared to the first image, it makes perfect sense. Double row height, double column width for B and omitting C are 100% USELESS because the whole point is I want to be able to add stuff in cells like A2 or C4 (unmerging some of the big cells), separately from "foo" and "baz".

aditsu gravatar imageaditsu ( 2015-02-20 22:41:49 +0100 )edit

@Lupp I guess you thought image 2 was the final goal? No, it's just an intermediary step so that I can make further changes. Having the cells already merged like that is good because I can start making a few additions without having to fix the whole sheet (as in the 3rd image).

aditsu gravatar imageaditsu ( 2015-02-20 22:56:37 +0100 )edit

Do you mean, it's just a matter of colours and borders?

I really cannot understand where this should lead to. I still cannot see any functionality/purpose. Having just abut 20 rows and no calculations needed should mean: No complicated tricks! Just do it "by hand".

Lupp gravatar imageLupp ( 2015-02-20 23:30:11 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2015-02-11 13:14:20 +0100

Lupp gravatar image

updated 2015-02-20 22:32:34 +0100

Create a second sheet and fill in there the contents as you want them referring to the cells in the original sheet with the help of OFFSET.

To simply get some kind of better overview there can be used different means, and wich one might be preferable will depend on details of the data, and also on proposed further usage.

You may upload an example or describe it in detail if you want additional advice.

Taking your question literally: Why don't you simply increase the row height?


With regard to the most recent comments I attach an example file. I will now retreat into my galaxy. ask46156EnlargedCells001.ods

edit flag offensive delete link more


Please add more details about the first paragraph (what is that about filling in the contents and using OFFSET?)

Also, I'm not sure what you mean by "better overview".

Increasing the row height won't help because the number of rows won't change. I want to add more information "between" the existing rows.

aditsu gravatar imageaditsu ( 2015-02-11 15:11:36 +0100 )edit

I simply cannot understand. If you want to only use your sheet as a visual grid for something typed in: Just draw your grid and type. If you actually want to use it as a spreadsheet, this will include applying some formulae and Calculations. Keeping information partly in the "main" rows and partly in intermediary rows would cause complications over and over. Add a column for your "remarks", whether in one piece or for every primary column extra.

Lupp gravatar imageLupp ( 2015-02-20 14:53:43 +0100 )edit

I think we must be from different galaxies as we can't seem to understand each other at all. Yes, the sheet is mostly a visual grid, in this case I'm not doing any calculations, but how is that relevant? What do you mean "draw your grid and type"?! Draw what where, using what? And how is that going to help solve my problem?

aditsu gravatar imageaditsu ( 2015-02-20 20:17:59 +0100 )edit

And what complications are you talking about regarding "main" and "intermediary" rows?! I just want to double the number of rows (inserting a new row after each initial row) and treat them all as regular rows afterwards. I don't want to add "remarks" and I don't want new columns. If you still can't grasp the concept, think of a time table that currently has a row for each hour and I want to have a row for each half hour instead.

aditsu gravatar imageaditsu ( 2015-02-20 20:23:27 +0100 )edit

There isn't a thing like "merged rows". Calc allows for merging cells, not for merging rows or columns. The so called merged cell is an enlarged display of a foreground cell hiding one or more background cells. As I suppose spreadsheets not performing any calculations being rather useless, I assumed you also would have some formulae there. This is what regularly causes problems when merging cells. What you want might better be implemented by a text table in Writer.

Lupp gravatar imageLupp ( 2015-02-20 22:16:17 +0100 )edit

When I said the new rows should be merged with the current ones, I meant each cell in a new row should be merged with the corresponding cell from the initial row. This extends to already-merged cells. About Writer, I tried it there and surprisingly it has a split feature that's very close to what I want. It's not as convenient as Calc though.

aditsu gravatar imageaditsu ( 2015-02-20 22:34:13 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-02-11 09:31:43 +0100

Seen: 1,596 times

Last updated: Feb 20 '15