Bug 125412 - Pivot Table Filter (Calc): Date Code not recognised
Summary: Pivot Table Filter (Calc): Date Code not recognised
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-05-21 10:05 UTC by grac
Modified: 2019-05-21 13:08 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description grac 2019-05-21 10:05:21 UTC 
Description:
Filtering in Pivot Table my original table with a correct Date column (code: YYYY-MM-TT) does not recognise the format of the data. Either it shows no data at all or all data of the table.

Steps to Reproduce:
1. Choose Filter in the Pivot Table
2. Choose date column
3. Choose date <= (oldest entry)
4. Choose AND
5. Choose date >= (youngest entry)

Actual Results:
either no result or all results (unfiltered)

Expected Results:
filtering respecting the date format YYYY-MM-TT


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 Roman Kuznetsov 2019-05-21 12:14:52 UTC 
please add sample document with PIVOT table and add info from Help->About dialog
Comment 2 Mike Kaganski 2019-05-21 12:16:29 UTC 
A condition that a date is older (<=) than oldest entry, and at the same time, is younger (>=) than youngest entry, is an empty set of dates.
Comment 3 grac 2019-05-21 12:55:55 UTC 
"A condition that a date is older (<=) than oldest entry, and at the same time, is younger (>=) than youngest entry, is an empty set of dates."

so, it's the exact opposite than i thought, sorry.

>= means "equal or younger" and
<= means "equal or older"

with this knowledge it works like a charm.

thanks for your hint