[Solved, sort of] Date format in sheet header

Discuss the spreadsheet application
Post Reply
Richarda44
Posts: 351
Joined: Sat May 24, 2008 6:59 pm

[Solved, sort of] Date format in sheet header

Post 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
Last edited by Richarda44 on Fri May 24, 2013 1:15 pm, edited 1 time in total.
OOo 4.1.1. bld 9593 on MS Windows 10 64 SP1 Chillblast fusion i5 and Acer Aspire E1-572 Laptop

There's got to be a better way
And for all accountants - The change is coming
gerard24
Volunteer
Posts: 958
Joined: Sat Oct 30, 2010 5:12 pm
Location: France

Re: Date format in sheet header

Post 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
LibreOffice 6.4.5 on Windows 10
Richarda44
Posts: 351
Joined: Sat May 24, 2008 6:59 pm

Re: Date format in sheet header

Post by Richarda44 »

Thanks Gerald

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

Richard
OOo 4.1.1. bld 9593 on MS Windows 10 64 SP1 Chillblast fusion i5 and Acer Aspire E1-572 Laptop

There's got to be a better way
And for all accountants - The change is coming
Post Reply