https://issues.apache.org/ooo/show_bug.cgi?id=63813
Rainer Bielefeld <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Locale mismatch causes |(Auto-) Filter on date |problems: Autofilter on |fields does not find cells |date fields does not find |where Day-Month order is |cells matching with |opposite to AOO Locale |selector items | --- Comment #12 from Rainer Bielefeld <[email protected]> --- Currently I can't find any exception from rule "Autofilter on date fields does not find cells where {Day-Month order of cell Format Locale} is opposite to AOO Menu 'Tools -> Options -> Language Settings -> Languages -> Locale', what more or less is the same what what mroe found out. Not the real Day-Month-order in cell does matter, but the Day-Month-order of cell format Locale? I still do not understand Example: With AOO Locale EN-US (M-D-Y) 2014-01-08 (eighth of January) will be found if cell has German (D-M-Y) ??? 2014-01-09 (ninth of January) will NOT be found if cell has EN-GB (D-M-Y) 2014-01-10 (tenth of January) will be found if cell has EN-US (M-D-Y) 2014-01-11 (11th of January) will NOT be found if cell has Italian (D-M-Y) For me it's plausible that B3 will not be found (Ger locale) and that B12 will not found (Italian locale, same order as German). But why does filter find B9 with German locale? Might "somehow" have to do with order of application of AOO Locale and Cell locale? -- You are receiving this mail because: You are on the CC list for the issue. You are watching all issue changes.
