https://issues.apache.org/ooo/show_bug.cgi?id=63813
mroe <mroellig.n...@gmx.net> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |mroellig.n...@gmx.net --- Comment #11 from mroe <mroellig.n...@gmx.net> --- Created attachment 83375 --> https://issues.apache.org/ooo/attachment.cgi?id=83375&action=edit test spreadsheet with different locale dates With the attached test spreadsheet you can try how the AutoFilter in Calc for dates works. A. Calc retrieves the values, the type of the value and the locale from the cells. B. With this information Calc creates the entries for the sorted filter list. C. If you pick an entry from the filter list and it is a date, Calc uses the locale setting of AOO to calculate the datevalue. => BUG: If the order of the day and month differs from the locale setting of AOO the wrong date is calculated: 01/05/2014 ↔ 05/01/2014 and vice versa. EXCEPTION: Is the day greater than 12 it will always been treated as day: 05/13/2014 stays 05/13/2014. Possible solution: a) The AutoFilter must remember the used locale for a date or b) it must remember the datevalue itself. -- You are receiving this mail because: You are on the CC list for the issue. You are watching all issue changes.