Hi Dave,
Thank you for your reply, sorry I haven't explained myself properly.
I have a new spread sheet for each month and between each month I insert a
sheet to paste a picture to, in total I use about 25 new sheets for this
project so when I go to Edit - Header/footer and type in the month of January
this copies to every sheet, but what I want is January for January, February
for February and so on.
I hope this is clearer.
Regards
Joan.
Sent from my iPad
On 13 May 2014, at 16:28, Dave Barton d...@tasit.net wrote:
Joan Learmonth wrote:
Hi,
I am having a problem with Open Office 4.01.
I am busy creating a 2015 calendar using the spread sheet, when I go to the
Header and type in the month say January this goes across the whole twelve
months, go to February and repeat the process it changes everything to
February. I have spent hours looking on line how to resolve this and nothing
has worked.
Last year before the upgrade it workedso this is very frustrating,
can you email a solution to this problem?
I look forward to your reply,
Regards,
Joan Learmonth
Hi Joan,
What you describe sounds like you are modifying an existing sheet and you may
have moved/removed one or more rows, which in turn has moved the month cells
(what you call The Header) into a row that is a merge of a number of cells
in that row. Try this:
Click inside the (header) month cell (eg. January).
From Calc's main menu select the Format - Merge Cells - Merge and Center
Cells option.
If my guess is correct, you will then have removed the merge and reinstated
the 12 individual cells.
Hope this helps.
Dave