https://bugs.freedesktop.org/show_bug.cgi?id=73845
Priority: medium
Bug ID: 73845
Assignee: [email protected]
Summary: PIVOTTABLE: Filter lost on refresh after FILEOPEN
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 3.5.0 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 92484
--> https://bugs.freedesktop.org/attachment.cgi?id=92484&action=edit
Sample Spreadsheet that exhibits the faulty behavior
This looks a lot like bug 66969, but that one is closed for good, so I opened
another one, this time with my own Sample.ods. (Check that bug for the
beginning of the discussion)
I was checking 4.1.5 RC1 and it still exhibited almost the same faulty
behavior:
Just instead of the first two filter fields being forgotten, it's just the
first one now.
I reduced my spreadsheet to the bare minimums and attach it to this comment,
same as the 'corrected' filter (how it looked, when I saved the file).
Steps to reproduce:
* Open the file PivotProblem.ods
* refresh the Pivot Table in tab 'due'
=> Table collapses
==> Reason: The filter was not restored correctly when opening the file. The
first 'field name' is actually the very first field in the source table, not
the one that used to be in the filter when the file was saved. The saving seems
to be OK though, since files I saved in 3.5+ were opened just fine (with the
correct filter) in 3.4.x.
Steps to resolve:
* Open the Pivot-Filter (e.g. Double-Click on 'Filter')
* Change the first 'Field Name' to "Eingang", like shown on the attached pic
* Hit 'OK' => table is back
Additional problem as described before (different bug?):
* Try deselect values in the column filter (e.g. 'debitor')
=> the only ones you can de-select are the ones not present (e.g. 'empty')
(You'll have to refresh the table, before you can do anything with the column
filters, because internally the PT is actually 'empty' before you set the
filter again to something including some data. It just displays the contents
from the last save)
I hope this helps narrow it down...
--
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
