<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Pivot table (cache) in XLSX corrupted after roundtrip, file crashes Excel"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108343">108343</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Pivot table (cache) in XLSX corrupted after roundtrip, file crashes Excel
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>4.4.0.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Keywords</th>
<td>filter:xlsx
</td>
</tr>
<tr>
<th>Severity</th>
<td>major
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>baron@caesar.elte.hu
</td>
</tr>
<tr>
<th>Blocks</th>
<td>103381
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=133861" name="attach_133861" title="Sample pivot table created in Excel">attachment 133861</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=133861&action=edit" title="Sample pivot table created in Excel">[details]</a></span>
Sample pivot table created in Excel
The attached simple pivot table was created in Excel 2013.
If the file is roundtripped in LibreOffice (just needs to be saved after
loading), it opens asking for recovery in Excel, and produces the following
report after repairs:
"Repaired Records: PivotTable report from
/xl/pivotCache/pivotCacheDefinition1.xml part (PivotTable cache)"
In the repaired file refreshing pivot table data crashes Excel.
Clicking on autofilter dropdown of Country selector also crashes Excel. Note
how "(All)" was changed to "- all -" in LibreOffice.
Observed with LO 5.4beta1 & 4.4.0.3 / Windows 7.
Roundtripping with 4.0.0.3 didn't even preserve the pivot table.
This could be the same as <a class="bz_bug_link
bz_status_NEW "
title="NEW - DATALOSS FILESAVE: xlsx pivot table corrupted after save with LO and re-open with MS Office"
href="show_bug.cgi?id=89139">bug 89139</a> in its current state (gives the same
message after repairs, crashes Excel the same way). Since the original issue of
<a class="bz_bug_link
bz_status_NEW "
title="NEW - DATALOSS FILESAVE: xlsx pivot table corrupted after save with LO and re-open with MS Office"
href="show_bug.cgi?id=89139">bug 89139</a> is gone, and it's preferred to have new bug reports for new issues, I
decided to open this instead.</pre>
</div>
</p>
<div id="referenced">
<hr style="border: 1px dashed #969696">
<b>Referenced Bugs:</b>
<ul>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] Pivot table (aka Data Pilot) bugs and enhancements"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=103381">Bug 103381</a>] [META] Pivot table (aka Data Pilot) bugs and enhancements
</li>
</ul>
</div>
<br>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>