Created attachment 160071 [details] test data file In the Pivot table, the filter by year in Drop-down filter window doesn't work. It doesn't not group items by year same as standard filter. Please see the screenshots.
Created attachment 160072 [details] Correct behavior
Created attachment 160073 [details] Wrong Behavior
Confirmed. It happens even group for years. So: To the sample, add a group for years -> filter for years doesn't work. After that delete 'Date' field -> filter for years fine. Add again the 'Date' field -> filter for years fine. Version: 6.4.3.2 (x64) Build ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8 CPU threads: 4; OS: Windows 10.0 Build 19608; UI render: GL; VCL: win; Locale: es-ES (es_ES); UI-Language: en-US Calc: CL Version: 7.0.0.0.alpha0+ (x64) Build ID: 7459b9ecb54a298f02d19089620149718f8d8d48 CPU threads: 4; OS: Windows 10.0 Build 19608; UI render: Skia/Raster; VCL: win; Locale: es-ES (es_ES); UI-Language: en-US Calc: CL
I find a workaround for this issue as follows: 1- edit the pivot table by right click on it and choose Proprieties. 2- Drag the Date field from Filter section to Row Fields. Then click on OK. 3- left click on any cells of Date, then from menu bar select "Data ---> Group and Outline ---> Group". 4- On the "Group by" section select "Years" only. Then click on "OK" button. 5- repeat steps 1 to 2 but now return Date field to the Filter Section. Then OK button. Now you can filter by year in Drop-down filter.
Unfortunately, there are some flaws in the pivot table especially with date and time. Some testing code: bool ScSheetDPData::IsDateDimension(sal_Int32 nDim) { CreateCacheTable(); const ScDPCache::ScDPItemDataVec& rItems = aCacheTable.getCache().GetDimMemberValues(nDim); for (const ScDPItemData& rItem : rItems) { if (rItem.GetType() == ScDPItemData::Type::Date) { return false; } } return true; } However, in initFromCell in dpcache.cxx there is no check for a date/time cell, therefore the above code will not work. In addition, it conflicts with isDataDimension (Data vs Date) and causes a crash. There is even some dead code in dptabsrc.cxx [1] because isDateDimension checks only if the dimension is the first one [2]. [1] https://opengrok.libreoffice.org/xref/core/sc/source/core/data/dptabsrc.cxx?r=f528fff9#1990 [2] https://opengrok.libreoffice.org/xref/core/sc/source/core/data/dpshttab.cxx?r=f477b54e#103
(In reply to Zayed from comment #4) > I find a workaround for this issue as follows: > 1- edit the pivot table by right click on it and choose Proprieties. > 2- Drag the Date field from Filter section to Row Fields. Then click on OK. > 3- left click on any cells of Date, then from menu bar select "Data ---> > Group and Outline ---> Group". > 4- On the "Group by" section select "Years" only. Then click on "OK" > button. > 5- repeat steps 1 to 2 but now return Date field to the Filter Section. Then > OK button. > > Now you can filter by year in Drop-down filter. one more step, make sure the cells are Date not text.
Dear Zayed, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Still open in version: 7.6.4.1