Bug 140344 - Math formulas embedded in a calc file disappears when exporting for Excel
Summary: Math formulas embedded in a calc file disappears when exporting for Excel
Status: RESOLVED DUPLICATE of bug 103406
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.0.3 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-02-11 15:22 UTC by Andy
Modified: 2021-02-11 17:01 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Andy 2021-02-11 15:22:02 UTC
When embedding math formulas (mathematical expressions created with the formula editor - aka equation editor, not calc formulas to compute data in the spreadsheet) in a calc file, if you save the file in any format (ods, xlsx, xls) and open it with Excel 2019 they disappear altogether. This is specific to Calc, since the same equations embedded in a writer file (saved both as odt or docx) are imported perfectly in Word.
Notice that with legacy LO releases (I have a 3.3 portable), the same ods file when exported in xls format (old Excel) does maintain the equations.
This is really unfortunate since very often in Calc you perform computations using some complex equation and thus embed the equation to clarify what you're doing.
At the moment, when exporting to Excel the spreadsheet loses all equations. NB equations do not even display as images or metafiles; they simply cease to exist when the file is opened in MS Excel.
Comment 1 m_a_riosv 2021-02-11 17:01:17 UTC

*** This bug has been marked as a duplicate of bug 103406 ***