Page 1 of 1

[Solved, sort of] Date format in sheet header

Posted: Thu May 23, 2013 9:15 pm
by Richarda44
My default header makes a date like - 23/05/2013

The "Header Page style: default" box only allows text attributes.

So is it possible to have - 23 May 2013 in the header, and how ?

thanks, Richard

Re: Date format in sheet header

Posted: Thu May 23, 2013 9:31 pm
by gerard24
Sorry but you can't choose a format for the header in Calc.
The format for this field is the default date format of your locale.

There is an bug report since 2003...
https://issues.apache.org/ooo/show_bug.cgi?id=22183

Re: Date format in sheet header

Posted: Fri May 24, 2013 1:14 pm
by Richarda44
Thanks Gerald

At least we can use rows to repeat as headers and format the row how we like.

Richard