Remark: Actually, the "bug" (why is it called a bug if I am filing an enhancement request??) hasn't appeared with a certain version, because it isn't a bug, just a lacking feature.
Headers and footers in spreadsheets cannot be formatted the same way as in LO Writer. It is especially annoying that the only internationally accepted way of writing a date (ISO8601, which should be the default anywhere and everywhere in LO, but it isn't) cannot be chosen for a date in headers and footers, only in cells.
Steps to reproduce:
1. format, page
2. header (or footer, for that matter)
4. put cursor in one of the three fields
5. click the last but one button to insert the date
7. print the page
8. get annoyed by the date in non-8601 format
date cannot be formatted AND the default is not the ISO standard
date can be formatted (like in cells and in footers of LO Writer) AND ISO standard is the default
Operating System: All
Version: 22.214.171.124 release
Changed from normal to enhancement.
Or/And if at least was possible make reference to a sheet cell, like in Lotus 123.
set as dupe of 89187, that has some more details
*** This bug has been marked as a duplicate of bug 89187 ***