[Libreoffice-bugs] [Bug 142546] New: LO 7.1.3 breaks formulas in .FODT files

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142546

            Bug ID: 142546
           Summary: LO 7.1.3 breaks formulas in .FODT files
           Product: LibreOffice
           Version: 7.1.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Writer
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dave.docfound at nathanson.org

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210528/d02c6a81/attachment.htm>