Bug 107858 - Autofilter is created differently in Excel macro compared to manual creation
Summary: Autofilter is created differently in Excel macro compared to manual creation
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Tamas Bunth
Whiteboard: target:6.0.0
Keywords: filter:xlsx
Depends on:
Blocks: Macro-VBA XLSX-Autofilter
  Show dependency treegraph
Reported: 2017-05-15 04:14 UTC by Aron Budea
Modified: 2019-03-02 18:13 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Sample XLSM that behaves differently in Calc and Excel (13.54 KB, application/vnd.ms-excel.sheet.macroEnabled.12)
2017-05-15 04:14 UTC, Aron Budea

Note You need to log in before you can comment on or make changes to this bug.
Description Aron Budea 2017-05-15 04:14:17 UTC
Created attachment 133319 [details]
Sample XLSM that behaves differently in Calc and Excel

- Open the attached Excel spreadsheet (a slightly modified version of attachment 132647 [details] from bug 107238, but otherwise they are not related).
- For reference, create an autofilter by hitting AutoFilter button.

=> 1) Note that column B's autofilter dropdown contains 1, 2 and 3. This is correct.

- Undo the autofilter creation, or reload the spreadsheet.
- Run macro "AF" from the file.

=> 2) Now column B's autofilter dropdown also contains the date 2017-01-01.

Excel behaves like 1), so that would be the correct behavior.

Build ID: 68a1cb23ede1d4ae6195850190fca6953c30417f
CPU threads: 4; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86@39, Branch:master, Time: 2017-05-14_07:04:56
Locale: hu-HU (hu_HU); Calc: CL
Comment 1 Aron Budea 2017-05-15 04:17:14 UTC
Also reproduced with / Windows 7.
Comment 2 Commit Notification 2017-08-10 20:28:05 UTC
Tamas Bunth committed a patch related to this issue.
It has been pushed to "master":


tdf#107858 oovbaapi: Autofilter always has header

It will be available in 6.0.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:

Affected users are encouraged to test the fix and report feedback.
Comment 3 Aron Budea 2017-08-15 23:49:47 UTC
Verified that autofilter behaves the same in the following daily build:
2017-08-15_01:59:49 (bebaac5eb6ebd2db3e1ea22b1630111343a9c25c) / Windows 7.

Thanks for the fix!