https://bugs.documentfoundation.org/show_bug.cgi?id=170806
--- Comment #3 from Regina Henschel <[email protected]> --- (In reply to ady from comment #2) > TY for replying. > > (In reply to Regina Henschel from comment #1) [..] > Let's take another example, "01/02/2026". If cell A1 contains that Text (not > formatted as Date, but as Text, or as General/Standard with an initial > "hidden" apostrophe), and the same cell A1 is locale en-US, then > DATEVALUE(A1) should give you the serial number for the second day of the > month of January of the year 2026. But, if the locale of cell A1 matches a > language-country that has the other default pattern (D/M/Y), then the same > DATEVALUE(A1) should result in the internal serial number for the first day > of the month of February of the year 2026. This should be independent of the > "Date Acceptance Pattern" setting, which the user could had modified for > whichever reason. A cell does not have a locale. The locale is only determined by Tools > Options > Languages and Locales. However, you are right, that if the conversion of text to date is unambiguous, LibreOffice could convert it. The standard specifies "Evaluators may accept other formats that will convert to numbers, and those conversions may be locale-dependent, as long as they do not conflict with the above." Only that LibreOffice needs to document it, that is describe the rules in its help. -- You are receiving this mail because: You are the assignee for the bug.
