https://bugs.documentfoundation.org/show_bug.cgi?id=146167
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |WORKSFORME Status|UNCONFIRMED |RESOLVED --- Comment #5 from Eike Rathke <[email protected]> --- I don't see anything wrong opening the first document either. With the second document the date displayed in Index1.B2 (1899-12-31 in whatever current locale's date format of DD/MM/YYYY) is the value 1 (obtained by =INDEX($Main.B2:$C$27;1;1)) explicitly formatted as date, which is already saved in the file as formula result office:value-type="date" office:date-value="1899-12-31" calcext:value-type="date" with table:style-name="ce1" which is style:data-style-name="N36" which is <number:date-style style:name="N36" number:automatic-order="true"> <number:month number:style="long"/> <number:text>/</number:text> <number:day number:style="long"/> <number:text>/</number:text> <number:year number:style="long"/> </number:date-style> I don't see anything wrong. I assume the cell Index1.B2 was created by copy-pasting Index1.A2 that copied the format along. Assign the General number format to B2 and you'll see. Fwiw, the "unknown numbers" 44538 and 44536 in A2 and A3 of the original description are the date serial numbers of 2021-12-08 and 2021-12-06 just formatted as General (or any other number) instead of date. I tried to reproduce by entering such formulas taking indexed values of date cells in unformatted cells but nothing wrong, date formats were applied automatically. I assume the date formats of the two cells mentioned were simply cleared after entering the formula (e.g. by hitting Ctrl+M). Closing as works-for-me. -- You are receiving this mail because: You are the assignee for the bug.
