Bug 89187 - FORMATTING No date format options in Calc header/footer
Summary: FORMATTING No date format options in Calc header/footer
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
: 81997 144570 (view as bug list)
Depends on:
Blocks: Fields Calc-Header-Footer
  Show dependency treegraph
Reported: 2015-02-06 20:32 UTC by Humilulo
Modified: 2022-12-04 04:50 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Humilulo 2015-02-06 20:32:44 UTC
In LibreOffice Calc, when i add the date in a footer, it displays only in MM/DD/YYYY format (in Print Preview). but my OS date format (in Windows) is 'YYYY-MM-DD'. I wouldn't call it a bug if Calc let us choose the format specifically, but forcing us into one set date format when it's not the desired format is certainly a bug to this user. :(
Comment 1 Cor Nouws 2015-02-06 22:13:33 UTC
Hi Humilulo,

thanks for filing. I set this as a enhancement!

Comment 2 QA Administrators 2016-02-21 08:34:16 UTC Comment hidden (obsolete)
Comment 3 Cor Nouws 2016-02-22 20:28:58 UTC
Still the same in 5.2 master
Comment 4 Cor Nouws 2016-10-06 13:19:29 UTC
*** Bug 81997 has been marked as a duplicate of this bug. ***
Comment 5 vertrieb@toplinewindow.com 2020-02-22 12:42:26 UTC Comment hidden (spam)
Comment 6 Michael Warner 2021-09-17 15:19:04 UTC
*** Bug 144570 has been marked as a duplicate of this bug. ***
Comment 7 Franklin Schiftan 2022-12-04 04:50:49 UTC
I also find it erroneous when LibO does not use the system-wide date format (YYYY-MM-TT in this case). However, even better would be the possibility to freely format the date in footer or header - like in a Calc cell or like in Writer date fields.