Bug 76389

Summary:	Calc: Used AutoFilter not highlighted when set in Calc and saved as XLS
Product:	LibreOffice	Reporter:	a07cd040897db54e103c
Component:	Spreadsheet	Assignee:	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.