<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 - Calc should correctly import and roundtrip data field names as defined in XLSX"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124883">124883</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Calc should correctly import and roundtrip data field names as defined in XLSX
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</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>mikekaganski@hotmail.com
</td>
</tr></table>
<p>
<div>
<pre>Something like a follow-up of <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - In XLSX pivot table exported from LO, data field name disappears after refresh in Excel"
href="show_bug.cgi?id=124881">bug 124881</a>.
1. Open <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> from <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> in Excel;
2. Change the name of the Data field (Values area in PivotTable Fields sidebar)
from "Sum of Amount" to, say, "FooBar";
3. Save it in Excel;
4. Open it in current LO master;
5. Save as XLSX again;
6. Re-open in Excel.
The data field in the original XLSX is initially named "Sum of Amount" (default
name automatically assigned by Excel on creation), changed to user-defined
"FooBar". When imported to Calc, it's shown as "Sum - Amount". Prior to [1],
Calc didn't export anything as the field's name; which allowed Excel (older
than 2016) to re-construct the name *as default "Sum of Amount"*. After the
said commit, Calc started to export empty string, forcing the name to be empty.
With [2], it now exports a name *as generated by Calc*.
The problem is, Calc should read, use, and export the name as defined in
original XLSX.
[1] <a href="https://git.libreoffice.org/core/+/1a28b0a602bb3c10f75c3c6408cf9bc555020d34">https://git.libreoffice.org/core/+/1a28b0a602bb3c10f75c3c6408cf9bc555020d34</a>
[2] <a href="https://git.libreoffice.org/core/+/e913727c7ee3af0bb4031c6829abfb3373306492">https://git.libreoffice.org/core/+/e913727c7ee3af0bb4031c6829abfb3373306492</a></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>