<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 - Structure of pivot table coming from XLS is altered in LO"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108352">108352</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Structure of pivot table coming from XLS is altered in LO
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>4.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:xls
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</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>CC</th>
<td>michael.meeks@collabora.com
</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=133866" name="attach_133866" title="Sample XLS">attachment 133866</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=133866&action=edit" title="Sample XLS">[details]</a></span>
Sample XLS
The attached simple pivot table was created in Excel 2013 with the same method
as in <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Pivot table (cache) in XLSX corrupted after roundtrip, file crashes Excel"
href="show_bug.cgi?id=108343">bug 108343</a>, but as an XLS.
In this case if the file is opened in LibreOffice, the structure is different,
instead of "Row Labels", the first item (Banana) is the selector, but if you
click into Country or Banana cells, the view changes slightly, the table
becomes a row taller, and Product becomes the selector again (see attached
comparative screenshots).
The roundtripped table looks similar in Excel as its state in Calc, but the
border is blue when the pivot area has been clicked into.
Observed with LO 5.4beta1 & 4.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] 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>