https://bugs.documentfoundation.org/show_bug.cgi?id=153057
Bug ID: 153057
Summary: Calc and Base can not filter time values
Product: LibreOffice
Version: 7.4.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Calc's standard filter dialog displays the existing time values as formatted in
the respective column. If you choose any of the values with operator =, the
filter result is OK. In the attached song list, there are 4 songs with a lenght
of 00:01:58. When you change the operator or when you manually enter some time
value, the filter always fails with no resulting records. "Advanced filtering"
works well.
The problem affects both forms of the attached database. The form reports an
error and the form document needs to be reloaded in order to be usable again. I
could reproduce the problem with both types of embedded databases.
Steps to Reproduce:
1. Open spreadsheet and test the standard filter with some value in the
"Duration" column.
2. Open the database and test filtering by time values in the "Duration"
column.
3.
Actual Results:
1. fails in most cases with no records
2. always fails with no records, error message and unusable form.
Expected Results:
Properly filtered record sets
Reproducible: Always
User Profile Reset: No
Additional Info:
none
--
You are receiving this mail because:
You are the assignee for the bug.
