<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 - XLSX FILEOPEN Issues with partially grouped pivot table fields in Calc"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126702">126702</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>XLSX FILEOPEN Issues with partially grouped pivot table fields in Calc
</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>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>112416
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=153132" name="attach_153132" title="Sample XLSX with one partially grouped row field">attachment 153132</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=153132&action=edit" title="Sample XLSX with one partially grouped row field">[details]</a></span>
Sample XLSX with one partially grouped row field
In Excel, in a pivot table you can select a couple of entries, open right-click
menu, and select Group to create arbitrary grouping (repeat any number of
times). The group name can be changed by editing its cell. In the PivotTable
Fields you also have the option to remove the original field from the rows, and
only keep the grouped one.
The two attached samples were created this way, one has both the grouped and
non-grouped rows (the layout has also been switched from Compact to Outline
Form), the other only has the grouped row.
In Calc:
- for the file with the one, partially grouped row field no content is
displayed, only the sum at the end,
- for the file with both row fields only the ungrouped one is shown.
Observed using LO 6.4.0.0.alpha0+ (ed882d693f37779e3a09641e7cd43b7a925d2312),
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>