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
Also reproduced with 184.108.40.206 / Windows 7.
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.
Verified that autofilter behaves the same in the following daily build:
2017-08-15_01:59:49 (bebaac5eb6ebd2db3e1ea22b1630111343a9c25c) / Windows 7.
Thanks for the fix!