https://bugs.freedesktop.org/show_bug.cgi?id=69211
--- Comment #8 from Ady <[email protected]> --- (In reply to comment #7) > You just correctly observed that a number format such as a date format is a > DISPLAY format, not a data entry mask. Date input is evaluated according to > the date acceptance patterns that can be viewed and changed under Tools -> > Options -> LanguageSettings -> Languages. My tests are showing that the additional "Date acceptance patterns" are not working as expected (a.k.a BUG). The "Date acceptance patterns" is supposed to help the user introduce dates using alternative date formats (other than its default in Calc Language settings). I can insert the date in my default format and then change the format of the cell as I want; but then there is no point for the "Date acceptance patterns". The whole point of "Date acceptance patterns" is for the user to be able to insert _other_ date formats and Calc should identify (format) it as date "automatically". Hopefully I am being more clear now. Perhaps this incorrect behavior is more relevant for bug #71664, as it is not a problem exclusive to DATEDIF. Regards, Ady. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
