I use a row field which contains number elements and change the filtering, so only some of the member items of this filed is displayed in the pivot table. If I save this into an XLS file filterins is lost and all items are enabled.
Steps to Reproduce:
1. Open attached ODP file
2. Open Order ID popup button and check only the first item ("1") is enabled
3. Save the document to an XLS file
4. Open it in LO or in MSO and check the popup button.
-> All the three items are enabled and so when you refresh the tabel, it's structure changes.
Filtering of number row field is not saved to XLS.
Filtering should be saved and imported also.
User Profile Reset: No
User-Agent: Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36
Created attachment 136097 [details]
Simple document with filtering on row field
Hi @Tamás, I think this is a dup of https://bugs.documentfoundation.org/show_bug.cgi?id=109016
Already assigned to @Bartosz.
(In reply to m.a.riosv from comment #2)
> Hi @Tamás, I think this is a dup of
> Already assigned to @Bartosz.
Nope. This bug is about XLS and not XLSX.
Please excuse me.
Tamás Zolnai committed a patch related to this issue.
It has been pushed to "master":
tdf#112278: Pivot table: filtering of non-string fields is not exported to XLS
It will be available in 6.0.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.