How to fill in merged cells without split them?

[madbear]

Hi !

Here is what I try to do :
I merged two cells ( A1 and B1 ) and enter ‘1’ in that merged cell.
I want to use incremental fill function to have my horizontal serie starting from 1 to 10 with my cells merged ( C1 with D1 contain 2, E1 with F1 contain 3, … and so on )

Here is what I have tryied to do :

I manually merge all the cells I need to be merged. And then I use the fill handle to make my serie over my merged cells.
Result : Fail. The merged cells get split and I get a serie from 1 to 20 in splitted cells instead of a serie of 1 to 10 in my 10 manually merged cells.

I have also tried the " Edit - Fill - Serie " method but the result is worst with strangely merged cells…

Is there a way to do what I want ? I thought the fill function could do that but it appears it can’t or I’m wrong ?

Here is my software infos :
OS : Ubuntu 13.10

LibreOffice :
Version: 4.1.3.2
Build ID: 410m0(Build:2)

Thanks.

PS : Sorry about my bad english… I do my best.

[w_whalley]

I merged cells A1 and B1, then merged cells C1 and D1. Then I entered 1 in merged (A1 B1) and =A1+1 in merged (C1 D1). Then I copied the merged cell (C1 D1) and pasted it into the range E1 to T1. I found that the formula and the merged cell format were both replicated.

[madbear]

Thank you ! That works as expected. Simple and effective !

[rste2000]

Brilliant that worked great thanks