<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 - Formatting in pivot table saved as XLSX degrades after refreshing table in Excel"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124772">124772</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Formatting in pivot table saved as XLSX degrades after refreshing table in Excel
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.0.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>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>BASIC
</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>CC</th>
<td>mikekaganski@hotmail.com
</td>
</tr>
<tr>
<th>Blocks</th>
<td>112416
</td>
</tr></table>
<p>
<div>
<pre>The samples are two similar pivot tables, one created in Excel (<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - FILESAVE XLSX Calc creates corrupted pivot table"
href="show_bug.cgi?id=123421">bug 123421</a>),
and another in Calc (<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED DUPLICATE - Pivot table (cache) in XLSX corrupted after roundtrip, file crashes Excel"
href="show_bug.cgi?id=108343">bug 108343</a>).
- Open Calc-created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=149245" name="attach_149245" title="Sample ODS">attachment 149245</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=149245&action=edit" title="Sample ODS">[details]</a></span> (<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - FILESAVE XLSX Calc creates corrupted pivot table"
href="show_bug.cgi?id=123421">bug 123421</a>) and save it as XLSX, or
Excel-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> (<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED DUPLICATE - Pivot table (cache) in XLSX corrupted after roundtrip, file crashes Excel"
href="show_bug.cgi?id=108343">bug 108343</a>) and save it again as XLSX.
- Open in Excel (the first sample needs <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - FILESAVE XLSX Calc creates corrupted pivot table"
href="show_bug.cgi?id=123421">bug 123421</a>'s fix to work), right-click
table and choose Refresh.
=> Note the following:
- number formats disappear,
- the borders fade,
- the grey background of the fields (Country, Product) disappears (already upon
import).
Out of these the first two are particularly problematic, the third is nice to
have.
A couple of other smaller differences worth noting (but no need to deal with
them):
- Calc's format for unfiltered values is "- all -", while Excel's is "(All)",
probably can't be handled in a consistent way (ie. if "(All)" is exported, then
Calc will again change it when working on the file again, if it's changed
internally for Excel files, then it won't be consistent within Calc),
- similarly, Calc uses "Total Result", while Excel uses "Grand Total",
- the header of the sum column, which is "Sum - Amount" disappears in Excel
upon Refresh (in the Excel sample the original column header is "Sum of
Amount"),
- in the Excel-created sample the "Product" field is originally "Row Labels"
instead, not sure why,
- in the Excel-created sample the original formatting is fancy, the styles are
likely be hard ot support, perhaps roundtripping it in the grab-bag could be
considered.
Observed using LO 6.3.0.0.alpha0+ (2e3b0c5d42d60d46cd9f8b8eda9424b095c63418),
6.0.0.3 / Windows 7.</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] XLSX pivot table bugs"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=112416">Bug 112416</a>] [META] XLSX pivot table bugs
</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>