https://bugs.freedesktop.org/show_bug.cgi?id=46448
--- Comment #2 from [email protected] 2012-05-07 04:27:29 PDT --- Pasting a date into a date formatted cell will convert the date to the locale of the cell and apply styles afterwards. Example: A cell is set to English with date format DD.MM.YY and a date is pasted into that cell. The date will be treated as MM.DD.YY and then converted to the cell style DD.MM.YY. This will switch the original day to month and vice versa. E.g. 11.02.12 (DD.MM.YY) will be converted to 02.11.12 (DD.MM.YY) because Calc treats the pasted date as MM/DD/YY, even though the cell was formatted to show DD.MM.YY! Even worse, if the day in this example is a >12, Calc will treat the pasted date as text instead! Shouldn't Calc treat input as defined by the cells style, not it's locale?! -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- 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
