https://bugs.documentfoundation.org/show_bug.cgi?id=154721
--- Comment #4 from ady <[email protected]> --- Without knowing specifics about Persian Calendar, here is the test I performed. Starting with attachment 186548 from comment 2, I added: C1: =A1 D1: =B1 Then I Clear Direct Formatting on C1:D1 ([CTRL]+[M]). The resulting values are different, which means those dates are not the same for Calc. C1: -181861 D1: 45025 Then: _ E1: =D1 _ Clone format from A1 to E1. I copied the result from E1 to some translation web page, and the resulting translation to English was "Sunday, July 9, 2023", which is the same date and day of the week of B1. Using the original text from A1 in the same translation web page, the result is "Friday, April 20, 1402". Using the same serial number from C1, the result is "Fri, January 20, 1402", which is a different date than the translated text ("Friday, April 20, 1402"). We seem to have here a Gregorian vs Julian Calendar issue, before considering what is the date format for the cell and the corresponding calculation of the day of the week for a given date. I think we need more info – I thought that the date was supposed to be the same in A1 and in B1 according to comment 0, but it's not – but we also need someone that understands the 3 different Calendars (or at least 2 of them) and how Calc deals with the '[NatNum1]NNNN""D MMMMYYYY' format. -- You are receiving this mail because: You are the assignee for the bug.
