Bug 153257 - Math formula vanishes if Calc-document is saved as .xlsx
Summary: Math formula vanishes if Calc-document is saved as .xlsx
Status: RESOLVED DUPLICATE of bug 103406
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.7.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-01-28 00:33 UTC by J. S.
Modified: 2023-01-29 08:44 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description J. S. 2023-01-28 00:33:08 UTC 
Description:
The Calc document contains one table, in cell A1 there is the formula object "a^2+b^2=c^2".
If the file is saved as .xlsx, closed; and the .xlsx is (re-)opened, then the formula object is gone, the cell (A1) and the table is "empty".

If the file is saved as .ods, the formula does not vanish.

Steps to Reproduce:
1. Open new Calc document
2. Menu: Insert - Object - Formula object
3. a^2+b^2=c^2
4. Menu: File - Save as "Excel 2007-365 (.xlsx)", Name: test
5. Menu: File - End LibreOffice
6. Open the file "test.xlsx"


Actual Results:
No formula (object) ("a^2+b^2=c^2") existing.

Expected Results:
The formula (object) ("a^2+b^2=c^2") should be there.


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.1
Calc: threaded
Comment 1 m_a_riosv 2023-01-28 14:35:42 UTC 
Reproducible
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 7c3ea0abeff6e0cb9e2893cec8ed63025a274117
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Jumbo
Version: 7.2.7.2 (x64) / LibreOffice Community
Build ID: 8d71d29d553c0f7dcbfa38fbfda25ee34cce99a2
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: es-ES Calc: CL
Comment 2 SUBASHINI K 2023-01-29 07:11:03 UTC 
Not reproduced. 

Steps to Reproduce:
1. Open new Calc document
2. Menu: Insert - Object - Formula object
3. a^2+b^2=c^2
4. Menu: File - Save as "Excel 2007-365 (.xlsx)", Name: test
5. Menu: File - End LibreOffice
6. Open the file "test.xlsx"


Actual Results:
formula (object) ("a^2+b^2=c^2") existing.

Expected Results:
The formula (object) ("a^2+b^2=c^2") should be there.

Environment: 
Linux Mint 21 Cinnamon

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 5e193d854596db714ca786c2a676b5ac9684d5eb
CPU threads: 2; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-IN (en_IN); UI: en-US
Calc: threaded
Comment 3 Stéphane Guillou (stragu) 2023-01-29 08:44:32 UTC 

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