https://bugs.freedesktop.org/show_bug.cgi?id=63998
Priority: medium
Bug ID: 63998
Assignee: [email protected]
Summary: PIVOTTABLE: Does not filter on page field any more
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.0.2.2 release
Component: Spreadsheet
Product: LibreOffice
When you create a pivot table you can drop a field in the 'page field' area.
This adds a drop down list box to the pivot table on which you can filter the
data use for the pivot table (in my case: show only the data for a project).
We use this to create time sheets that go into our invoices, it is therefore of
great importance to us :-)
This has worked for a long time very nicely at least until libo 3.6.2.2 (Ubuntu
Quantal). Now with Raring libo 4.0.2.2 the functionality is broken.
I will attach a spreadsheet with the data embedded, although normally the pivot
table is run directly against our pgsql database.
Tab 1 shows the data,
Tab 2 show a normal pivot table
Tab 3 shows the same pivot table with data grouped per year, month, day
In libo 3.6 you can refresh the table, or select other projects as is supposed
to, in libo 4 after refresh all the times from all projects are shown, no
matter which project is selected.
I hope this can be fixed in a minor update that can go into ubuntu raring,
otherwise we can not upgrade to raring and must block the windows users from
upgrading as well to 4.xx.
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
