Ask Your Question

How to change date format in a spreadsheet footer?

asked 2017-01-24 13:21:41 +0100

John Jeffrey gravatar image

After I insert a date field in a *.odt document, I can right click on it and select from a variety of different formats. By contrast, if I insert 'date' in the footer of a *.ods spreadsheet, I am stuck with 'dd/mm/yyyy' with no (apparent) way of changing it. This is not a major problem, but I would like to get round it if possible so as to show eg 'Printed 23 Jan 17'. Is there a way I can reformat this field as I can with text documents?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-01-24 13:58:23 +0100

pierre-yves samyn gravatar image


It is a inherited limitation from OOo

See also for LibreOffice.


edit flag offensive delete link more


By the way: Spreadsheet headers and footers are ugly and limited in many ways (imo). I virtually never use them. except, probably, for page numbering. Wherever feasible I prefer a repeated row (or even more than one rows).

Lupp gravatar imageLupp ( 2017-01-24 14:25:05 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-01-24 13:21:41 +0100

Seen: 251 times

Last updated: Jan 24 '17