https://bugs.documentfoundation.org/show_bug.cgi?id=137626
Bug ID: 137626
Summary: EDITING Handling time in autofilter
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected], [email protected]
Blocks: 123807
Created attachment 166550
--> https://bugs.documentfoundation.org/attachment.cgi?id=166550&action=edit
Example file from Excel with autofilter set to filter time
Autofilter can filter by year – month – day but can not by hour – minute-
seconds, unlike Excel, causing interoperability woes.
Steps to reproduce:
1. Open attached file.
2. The autofilter in A1 was set to filter out a date by a given minute in
Excel.
Actual results:
In the list of the autofilter there is no option to filter by time, so the
options in A2:A5 appear ungrouped and unselected, as if all of them were
hidden, while only one was.
Expected results:
Autofilter should be able to handle the hour – minute – seconds precision.
Saving to / reading from various file standards (ODF/OOXML) should be topic for
subsequent bugs.
LibreOffice details:
Version: 7.1.0.0.alpha0+ (x64)
Build ID: 586f6abee92af3cdabdce034b607b9a046ed3946
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: CL
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=123807
[Bug 123807] [META] XLSX Autofilter-related bugs
--
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
