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. Version: 5.4.0.0.alpha1+ 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 4.0.0.3 / Windows 7.
Tamas Bunth committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7e728965b3f5a37a6f0bd75d616d2acb16c40f71 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: http://wiki.documentfoundation.org/Testing_Daily_Builds 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!