[Libreoffice-bugs] [Bug 124736] New: XLSX Doesn't work filter by Date correct in Pivot table

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 124736
           Summary: XLSX Doesn't work filter by Date correct in Pivot
                    table
           Product: LibreOffice
           Version: 6.3.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: 79045_79045 at mail.ru

Description:
Doesn't work filter by Date in Pivot table

this bug follows from partially fixed bug 113908

QA: for check it you should use build from 14 April and more new


Steps to Reproduce:
1. Open file from attach
2. Export it into XLSX
3. Open XLSX into MS Excel (I tried 2016)
4. Go to sheet with pivot table
5. Select Date filter on top 
6. Select item Nov (Ноя), press OK
7. Pivot shows October data instead November data
8. Select in Date filter item October
9. Pivot table shows no data instead October data


Actual Results:
pivot table in XLSX format shows incorrect data when filter by Date

Expected Results:
pivot table in XLSX format shows correct data when filter by Date


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.3.0.0.alpha0+ (x64)
Build ID: 2e3b0c5d42d60d46cd9f8b8eda9424b095c63418
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
TinderBox: Win-x86_64 at 42, Branch:master, Time: 2019-04-14_00:37:08
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

-- 
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/20190414/47380ec8/attachment-0001.html>