<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: empty / blank item is not imported from XLS"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=112337">112337</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Pivot table: empty / blank item is not imported from XLS
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.0.0.0.alpha0+ Master
</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>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>zolnaitamas2000@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
Both in MSO and LO pivot table fields can have empty items which means the
source range has an empty cell for one of the source columns. In MSO it's
identified ba the name "(blank)", while LO it is called "(empty)". If I save a
pivot table with an empty field item into an XLS file in Excel, it is not
imported to Calc
Steps to Reproduce:
1. Open attached file
2. Check the row field's member (open the popup button on cell A4)
Actual Results:
Empty item is missing
Expected Results:
Empty item should be imported
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/60.0.3112.113 Safari/537.36</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>