<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 when save-ing document as .xlsx messes up formula, if save-ing as .xls works fine."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=139910">139910</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Calc when save-ing document as .xlsx messes up formula, if save-ing as .xls works fine.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.0.0.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (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>chaser.bruce@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
Example:
When using a formula to sum same cells (B12) on every sheet with formula
=SUM($'01 2020'.B12:$'12 2020'.B12) and afterwords saving the document as
.xlsx, on reopening the new .xlsx document the formula changes to =SUM('01
2020':$'12 2020'.B12:B12) and the field throws a #NAME? error and of course the
calculation does not work.
Steps to Reproduce:
1.Create 3 sheets with spaces like so Sheet 1, Sheet 2, Sheet 3
2.On sheets 2 and 3 enter some value into fields A1
3.On Sheet 1 under A1 enter formula =SUM($'Sheet 2'.A1:$'Sheet 3'.A1) and
calculate the SUM
4.Save file as .xlsx type and close the document.
5.Reopen the document and check the formula. It has now changed to =SUM('sheet
2':$'Sheet 3'.A1:A1)
6.The formula is now wrong and entering new values in A1 fields does nothing.
Actual Results:
The formula is changed and wrong and entering new values in A1 fields does
nothing.
This only happens if you save the document as .xlsx
Expected Results:
/
Reproducible: Always
User Profile Reset: Yes
Additional Info:
/</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>