Created attachment 134539 [details] Sample document with row field filter set Attached ods file contains a row field filter in cell A3, set to hide the (empty) values. When saved to XLSX in a current 6.0 master build this filter setting is lost and all three row fields are shown.
Created attachment 134540 [details] The same file saved as XLSX
Created attachment 134541 [details] Screenshot of the problem with the ods file opened on the right, xlsx on the left
Created attachment 134542 [details] Same document saved from Excel 2013 for comparison If the same content is saved from Excel then reading the row fields filter is no problem.
Repro Version: 6.0.0.0.alpha0+ Build ID: 054dab1b9d4985c473e07c2618e5d6bf6ebc5466 CPU threads: 4; OS: Windows 6.19; UI render: GL; TinderBox: Win-x86@42, Branch:master, Time: 2017-07-05_06:06:48 Locale: es-ES (es_ES); Calc: group With bug#89139 was solved save the pt on xlsx format.
Also reproducible with LibreOffice 5.3.2.2 on MacOS. The issue is inside: /xl/pivotCache/pivotCacheDefinition1.xml part (PivotTable cache)
Created attachment 135035 [details] Simple document which shows the issue
Created attachment 135036 [details] Example of .xlsx file with containsSemiMixedTypes field usage
Created attachment 136254 [details] Same document saved as XLSX by LibreOffice 6.0 Thanks to fixes from tdf#89139, the filter is working correctly (there is no empty field). Also there is no error during import by MS Excel 2013
Created attachment 136335 [details] Screenshot of the document in Excel 2013 Indeed the filtering of your example looks fixed, thanks. However, it looks like the pivot table itself is completely gone. Is that a known regression?
Maybe this one https://bugs.documentfoundation.org/show_bug.cgi?id=89139
Hi Gabor, Some new pivot table related fixes were pushed to master branch. This document seems good now for me. Can you check whether you still experience this issue. Otherwise would be good to close this bug.
Hi Tamas I can confirm that on a build with commit 5c977ea903b26471877eecaad63766f5e70fd0b2 from yesterday the exported XLSX looks and works okay, the original problem is gone. Resaving the XLSX file however results in a seemingly endless loop - do you see something similar? Maybe it's just me, I'm not sure.
mmm I can still reproduce the issue in Version: 6.0.0.0.alpha0+ Build ID: 7901ede8a63f41aea707bd19c22f834253161378 CPU threads: 4; OS: Linux 4.10; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); Calc: group are you on Win ?
(In reply to Xisco Faulí from comment #13) > mmm I can still reproduce the issue in > > Version: 6.0.0.0.alpha0+ > Build ID: 7901ede8a63f41aea707bd19c22f834253161378 > CPU threads: 4; OS: Linux 4.10; UI render: default; VCL: gtk3; > Locale: ca-ES (ca_ES.UTF-8); Calc: group > > are you on Win ? No, I use Ubuntu 14.04. But we can recheck under Win from a fresh build.
Ok, I've just retested and it seems OK in Version: 6.0.0.0.alpha0+ Build ID: ad439ded005cffd525ffe874f535fca7a4da1f49 CPU threads: 4; OS: Linux 4.10; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); Calc: group However, I guess an error when I open the file in MSO Excel 2010
More than an error, it's a repairing warning: Repaired Records: PivotTable report from /xl/pivotTables/pivotTable1.xml part (PivotTable view)
Hi, Sorry, I forgot to add myself to CC, so can't see the discussion. I tested the test document again on master today and I also get the repair dialog when opening the saved XLSX in Excel. I'll check what the issue there, must be a recent regression.
Tamás Zolnai committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=fe6ea004872c86c4a2e5849c7c9e75905711d6f3 tdf#109016: Avoid to write the same pivot item member more times 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: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Hi Gabor, The corruption issue is fixed now. I don't experience endless loop. It's not clear when it comes up for you. Do you save XLSX, then open it again in Calc and save it again in XLSX? or what the actual steps? Anyway, this endless loop might be related to the same issue my commit fixed, so please test again and if still experience an issue, add some more specific reproducer steps. Thanks,
A polite ping to Tamás Zolnai: is this bug fixed? if so, could you please close it as RESOLVED FIXED ? Thanks