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: [email protected]
Reporter: [email protected]
CC: [email protected]
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@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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
