[Libreoffice-bugs] [Bug 107858] New: Autofilter is created differently in Excel macro compared to manual creation

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=107858

            Bug ID: 107858
           Summary: Autofilter is created differently in Excel macro
                    compared to manual creation
           Product: LibreOffice
           Version: 4.0.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: baron at caesar.elte.hu
                CC: szymon.klos at collabora.com

Created attachment 133319
  --> https://bugs.documentfoundation.org/attachment.cgi?id=133319&action=edit
Sample XLSM that behaves differently in Calc and Excel

- Open the attached Excel spreadsheet (a slightly modified version of
attachment 132647 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 at 39, Branch:master, Time: 2017-05-14_07:04:56
Locale: hu-HU (hu_HU); Calc: CL

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170515/0c8653a7/attachment.html>