When an autofilter is used in a table (natively created with ms excel and saved as xls) then Calc correctly applies AND highlights the *used* filter (colors the normally black arrow into blue). If you then change the filter using Calc and save the file as XLS, reopening in calc correctly *applies* the formerly defined filter, but does not longer *highlight* which filters are used. This is very annoying, especially when many columns contain filters.
Created attachment 96090 [details] AutoFilter natively set with MS Excel.
Created attachment 96091 [details] AutoFilter changed with Calc, saved as XLS.
Created attachment 96092 [details] A screenshot of the missing filter highlighting.
MS Excel *correctly* applies and highlights the AutoFilter changed by Calc.
reproducible with LO 4.2.2.1 (Win 8.1)
reproducible with LO 4.2.6 and 4.3.2 (Win 7 x64)
Anyway it's not correctly applied if we resave file in comment 1 as XLS. Hit the dropdown arrow and we can see all numbers (from 1 to 5) checked. What is displayed (4 only) is incorrect. Tested with LO 4.2.7.2 - Ubuntu 12.04 x86
Same behavior in LO 3.5.7.2. Not sure about older release, UI is different in LO 3.3.0.4.
I can reproduce it under Win8.1x64 using LibO 4.3.3.2 and 4.5.0.0.alpha0+ Build ID: f20043a0805c3a75eb4024ed59f45291aea93ac0 TinderBox: Win-x86@39, Branch:master, Time: 2014-12-03_01:16:50 Locale: it_IT moving it to mab4.3 list since 4.2.x is EOL
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.