Ubuntu
openoffice.org package

Howto AutoFill merged cells - is it a bug ?

Asked by David Genest

I want to autofill a series of dates, but in merged cells. I need to have a header row that is composed of 4 merge cells that states dates incrementally:
E.G. :

--------------------------------------------
                         |------------------
Date |------------------
                         |------------------
--------------------------------------------
I want to |------------------
autofill |------------------
increments here |------------------
---------------------------------------------

right now when I use the autofil feature, the increments are 4 instead of what I would expect to be 1 (because there are now 1 merged cell and not 4 separate cells). I tried to use the fill series function, but it fools the spreadsheet and fills each row, as if the cells were not merged.

Is there a way to accomplish this without having to enter each date manually ?

Thank you for your time,

David.

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
GercoKees (gercokees) said : 		#1

Hi,
I had to fiddle around before i understood your problem. Maybe you can try to fill in the dates above the merged cells, start with the formula: =A4+1 (where A4 points to the previous date, adding one day), and then use autofill again....
If this is not clear enough please submit a file,
succes

Can you help with this problem?

Provide an answer of your own, or ask David Genest for more information if necessary.

To post a message you must log in.