Created attachment 136075 [details] spreadsheet to demonstrate the behavior - same file as in Bug 112258 When in a sheet autofilter is set on date cells, the filter list is displayed not properly. In the filter list opened by click on the autofilter arrow the marked year is displayed only with 3 instead 4 digits. When other year is marked (not checked/unchecked!), the year marked before is displayed correctly and the newly marked year is displayed wrongly. When the wrongly displayed year or "All" is unchecked (resp. checked) in the list, all years are displayed correctly. Reproduce the bug: - open the attached file "Test_Autofilter_Date.ods" Step 1: - click on the autofilter arrow in column A ("Datum" Result: - expected: all years are displayed with 4 digits - actually: The first dispayed is "201" instead "2010" Step 2: - click on the string "2011" (not the check box) Actual result: Year "2010" is displayed correctly and instead "2011" is diplayed "201" Step 3: - Uncheck "All" or the wrongly displayed year ("201" instead "2011") --> all years are displayed correctly Reproduce with Version 6.0.0.0.alpha0+ (x64), Time: 2017-09-05_22:34:16 In LO 5.3.5 and 5.4.0/5.4.1 I could not reproduce this behavior.
Works for me. Version: 6.0.0.0.alpha0+ Build ID: 4f6bf3d64cf3fcbe92be3ceb4b572ad038c131a8 CPU threads: 4; OS: Windows 6.19; UI render: GL; Locale: es-ES (es_ES); Calc: CL
Created attachment 136086 [details] Screenshot from my test Maybe it is a problem of one of my computers. I have made the test on 2 other Windows computers (1x x86 + 1x x64) and on both the filter list is displayed correctly: all years with 4 digits. On the computer where I have seen the problem first I have deinstalled and then reinstalled LO 6.0: Version: 6.0.0.0.alpha0+ (x64) Build-ID: 571abca0461485380017095087ebe39bc8280b67 CPU-Threads: 4; Betriebssystem:Windows 6.19; UI-Render: GL; TinderBox: Win-x86_64@62-TDF, Branch:master, Time: 2017-09-05_22:34:16 Gebietsschema: de-DE (de_DE); Calc: CL but the problem still exists, see attached screenshot!
Please use Menu/Help/Restart in safe mode, so it's possible to test with a clean profile.
Created attachment 136094 [details] zip file with screenshot and zipped user profile I have tested with all levels of safe mode and in all tests occurred the problem of incorrectly displayed years in the filter list. Finally I have created a zip file of the user profile. Version: 6.0.0.0.alpha0+ (x64) Build ID: 115bed941d7b7ed1b95d6424bfb98456c1d87546 CPU threads: 4; OS: Windows 6.19; UI render: default; TinderBox: Win-x86_64@42, Branch:master, Time: 2017-09-06_23:35:50 Locale: de-DE (de_DE); Calc: group
After I have newly set up my test computer because of problems at installation of a Windows 10 Preview Build 16288 (now installed Build 16296) some days ago, I have repeated the test today with Version: 6.0.0.0.alpha0+ (x64) Build ID: 46fa042b94a0364c09482e8a09f8874119db231c CPU threads: 4; OS: Windows 6.19; UI render: GL; TinderBox: Win-x86_64@42, Branch:master, Time: 2017-09-21_23:32:46 Locale: de-DE (de_DE); Calc: CL and I could not reproduce the behavior described above. Therefore I propose to close this bug, OK?