<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 - LO 7.1.3 breaks formulas in .FODT files"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142546">142546</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>LO 7.1.3 breaks formulas in .FODT files
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.1.3.2 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>Writer
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>dave.docfound@nathanson.org
</td>
</tr></table>
<p>
<div>
<pre>Description:
Files were created in LO 7.0.6.2 Stable. Files are a report with embedded
spreadsheet saved as .FODT. When opened with LO 7.1.3 all formulas are broken.
Every formula has =of: prepended and status line at window bottom reports
"Error: Variable missing". Deleting the unexpected extra 4 characters fixes the
problem. See attached screenshot.
If file is closed without saving, the file still works fine in LO 7.0.6.2
Stable. However saving the document with LO 7.1.3 makes the problem permanent,
even if opened with the older version of LO.
This is a problem with .FODT files, does not happen with .XLSX files. Probably
limited to files saved as FODT format.
Once the formulas are repaired by deleting the extra 4 characters in every
formula and the file is saved, it remains fixed if file is opened by either
mentioned LO version.
Steps to Reproduce:
1.Create a file with embedded spreadsheet with some formulas in LO 7.0.6.2 or
older, save as .FODT
2.quit app
3.Open LO 7.1.3, open FODT file. Notice all formulas are damaged, and are
prepended with 4 unexpected characters =of:
Actual Results:
On opening the file in LO 7.1.3, all formulas are damaged, and are prepended
with 4 unexpected characters =of:
Expected Results:
File should open without causing damage to spreadsheet formulas in any version
of LO.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.0.6.2
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 12; OS: Mac OS X 10.14.6; UI render: default; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
=-=-=-=-=-===-=-=-=-=--=-==-
Version: 7.1.3.2 / LibreOffice Community
Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1
CPU threads: 12; OS: Mac OS X 10.14.6; UI render: default; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded</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>