Bug 76389

Summary: Calc: Used AutoFilter not highlighted when set in Calc and saved as XLS
Product: LibreOffice Reporter: a07cd040897db54e103c
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: major    
Priority: highest CC: barta, gtimur
Version: 3.5.7.2 release   
Hardware: Other   
OS: All   
Whiteboard:
i915 platform: i915 features:
Bug Depends on:    
Bug Blocks: 75025    
Attachments: AutoFilter natively set with MS Excel.
AutoFilter changed with Calc, saved as XLS.
A screenshot of the missing filter highlighting.

Description a07cd040897db54e103c 2014-03-20 10:25:46 UTC
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.
Comment 1 a07cd040897db54e103c 2014-03-20 10:27:02 UTC
Created attachment 96090 [details]
AutoFilter natively set with MS Excel.
Comment 2 a07cd040897db54e103c 2014-03-20 10:27:44 UTC
Created attachment 96091 [details]
AutoFilter changed with Calc, saved as XLS.
Comment 3 a07cd040897db54e103c 2014-03-20 10:28:29 UTC
Created attachment 96092 [details]
A screenshot of the missing filter highlighting.
Comment 4 a07cd040897db54e103c 2014-03-20 10:30:32 UTC
MS Excel *correctly* applies and highlights the AutoFilter changed by Calc.
Comment 5 A (Andy) 2014-03-21 21:51:25 UTC
reproducible with LO 4.2.2.1 (Win 8.1)
Comment 6 Timur 2014-10-20 11:07:43 UTC
reproducible with LO 4.2.6 and 4.3.2 (Win 7 x64)
Comment 7 ign_christian 2014-10-22 02:57:04 UTC
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
Comment 8 ign_christian 2014-10-22 03:03:30 UTC
Same behavior in LO 3.5.7.2. Not sure about older release, UI is different in LO 3.3.0.4.
Comment 9 tommy27 2014-12-03 02:45:34 UTC
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.