https://bugs.freedesktop.org/show_bug.cgi?id=63998
Ferry Toth <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |UNCONFIRMED Ever confirmed|1 |0 --- Comment #4 from Ferry Toth <[email protected]> --- Hello Joel, The filter has already been set to the 'Project Name'. You don't need to change that. Steps to reproduce: - download the spreadsheet (don't open embedded in your browser) - goto the sheet Draaitabel_blad1_1 - you will see the project hours are already filtered on APL-01-1 by the Page field (not the filter button) - the total Resultaat (sum of billable and non-billable hours) is 10:45:00 - right click in table and select Renew or Refresh or similar depending on your interface language - in LibO 3.6.2.2 nothing will change, you will have 13 rows of data - in LibO 4.0.2.2 you will 61 rows of data, the total will change to 2:59:00. - The sum of the time is not shown correctly because the format of the style needs to be changed to [UU]:mm. However the name of the Style depends on your language, a minor irritation for now. Just note that the total in 4.0.2.2 equals to the sum of the column Timespent on the sheet 'Blad1'. This means all rows are shown in the Pivot Table, not just the ones for APL-01-1 as intended and functioning correctly in 3.6.2.2. Next: - go to sheet Draaitabel_Blad1_1_2 - in the drop down box next to Project Name select APL-01-1 (in LibO 4.0.2.2 you need to first unselect All, then select APL-01-1) - right click in the Pivot Table and Renew or Refresh - in 3.6.2.2 you get 13 rows, split our per year, month and day - in 4.0.2.2 you get 100 rows Further in 4.0.2.2 if you continue after the last step: - click on Filter and fill in Project Name = APL-01-1, now the correct rows are shown It seems that there are 2 filters: - one accessed by clicking on Filter. This one I never use, but it seems to be working. - the second is the Page Field in the Pivot Table design, in this example 'Project Name'. In 4.0.2.2 this filter is not working. Ferry -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
