Bug 76389 - Calc: Used AutoFilter not highlighted when set in Calc and saved as XLS
Summary: Calc: Used AutoFilter not highlighted when set in Calc and saved as XLS
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 3.5.7.2 release
Hardware: Other All
: highest major
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: mab4.3
  Show dependency treegraph
 
Reported: 2014-03-20 10:25 UTC by a07cd040897db54e103c
Modified: 2014-12-03 02:45 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:


Attachments
AutoFilter natively set with MS Excel. (18.00 KB, application/vnd.ms-excel)
2014-03-20 10:27 UTC, a07cd040897db54e103c
Details
AutoFilter changed with Calc, saved as XLS. (6.00 KB, application/vnd.ms-excel)
2014-03-20 10:27 UTC, a07cd040897db54e103c
Details
A screenshot of the missing filter highlighting. (17.80 KB, image/png)
2014-03-20 10:28 UTC, a07cd040897db54e103c
Details

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.