<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 - FILESAVE XLSX Calculating with column labels doesn’t work"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124224">124224</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILESAVE XLSX Calculating with column labels doesn’t work
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>4.1.0.4 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>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>libreoffice@nisz.hu
</td>
</tr></table>
<p>
<div>
<pre>Description:
Calculating with column labels in XLSX documents created with LibreOffice Calc
6.3.0.0.alpha0+ doesn’t work when the document is opened in LibreOffice Calc
6.3.0.0.alpha0+.
Steps to Reproduce:
1. Turn on Options – Calc – Calculate – Automatically find column and row
labels.
2. Open the attached ODS file in LibreOffice Calc. It contains a column
label (that can be automatically found) in A1 and a formula =SUM('numbers') in
A10.
3. Open the attached XLSX file in LibreOffice Calc. It was saved from the
ODS file.
4. Type a value in the A8 cell in each document.
5. Compare the A10 cells in ODS and XLSX file.
6. View the attached screenshot.
7. Notice, that in XLSX file the value of A10 cell doesn’t change.
8. Opening the XLSX file in Excel gives “Part of this file is corrupted,
should we try to restore” error.
Actual Results:
Calculating with column labels doesn’t work when the document is opened in
LibreOffice Calc 6.3.0.0.alpha0+.
Expected Results:
Calculating with column labels doesn’t work should work the same way as the ODS
file when the document is opened in LibreOffice Calc 6.3.0.0.alpha0+.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 6.3.0.0.alpha0+
Build ID: 0faf4e5c2e98219b17e042594710f6872bf6a615
CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win;
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: threaded
Verzió: 5.0.0.5
Build az.: 1b1a90865e348b492231e1c451437d7a15bb262b
Területi beállítások: hu-HU (hu_HU)
Verzió: 4.2.0.4
Build az.: 05dceb5d363845f2cf968344d7adab8dcfb2ba71
Verzió: 4.1.0.4
Build az.: 89ea49ddacd9aa532507cbf852f2bb22b1ace28
But not with:
Verzió: 4.0.0.3 (Build az.: 7545bee9c2a0782548772a21bc84a9dcc583b89)</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>