Bug 103406 - FILTER: smath OLE formula is lost saving as xlsx
Summary: FILTER: smath OLE formula is lost saving as xlsx
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: All All
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: dataLoss, filter:xlsx
: 140344 153257 160476 (view as bug list)
Depends on:
Blocks: XLSX Formula-Object
  Show dependency treegraph
 
Reported: 2016-10-22 11:00 UTC by m_a_riosv
Modified: 2024-04-02 15:49 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:


Attachments
Ods file with a math formula (10.65 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-10-22 11:01 UTC, m_a_riosv
Details
.xlsx formula converted from .ods by MS Office 2010 (13.42 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2016-12-20 23:44 UTC, Bartosz
Details

Note You need to log in before you can comment on or make changes to this bug.
Description m_a_riosv 2016-10-22 11:00:43 UTC
Description:
Math formulas are lost saving as xlsx.

Steps to Reproduce:
1.Open attached file (ods)
2.There is a math formula.
3.Save as xlsx
4.Reopen the xlsx file.
5.Math formula is not there.

Actual Results:  
Math formula is lost.

Expected Results:
Math formula is not lost.


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:49.0) Gecko/20100101 Firefox/49.0
Comment 1 m_a_riosv 2016-10-22 11:01:18 UTC
Created attachment 128152 [details]
Ods file with a math formula
Comment 2 m_a_riosv 2016-10-22 11:06:40 UTC
Repro since
LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4
Version 3.6.7.2 (Build ID: e183d5b)
Comment 3 MM 2016-10-22 11:18:47 UTC
Confirmed with v5.1.6.1 under windows 7 x64.
Comment 4 Bartosz 2016-12-20 23:44:54 UTC
Created attachment 129830 [details]
.xlsx formula converted from .ods by MS Office 2010
Comment 5 QA Administrators 2017-12-22 03:36:14 UTC Comment hidden (obsolete)
Comment 6 MM 2018-08-27 21:34:08 UTC
Confirmed on windows 7 x64 with Version: 6.0.6.2 (x64)
Build ID: 0c292870b25a325b5ed35f6b45599d2ea4458e77
CPU threads: 3; OS: Windows 6.1; UI render: default
Comment 7 QA Administrators 2020-12-20 03:45:26 UTC Comment hidden (obsolete)
Comment 8 m_a_riosv 2020-12-20 15:57:45 UTC
Still
Version: 7.2.0.0.alpha0+ (x64)
Build ID: e97a81e94511b52987a50b7bdb72c922899da588
CPU threads: 4; OS: Windows 10.0 Build 20180; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: es-ES Calc: CL
Comment 9 m_a_riosv 2021-02-11 17:01:17 UTC
*** Bug 140344 has been marked as a duplicate of this bug. ***
Comment 10 Stéphane Guillou (stragu) 2023-01-29 08:44:32 UTC
*** Bug 153257 has been marked as a duplicate of this bug. ***
Comment 11 Stéphane Guillou (stragu) 2023-01-29 08:51:37 UTC
Reproduced in recent master build:

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 69c6f7bccec838b7288a25a29a83b7f782ba7586
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

Saving as XLS, the formula persists!
Comment 12 m_a_riosv 2024-04-02 15:49:01 UTC
*** Bug 160476 has been marked as a duplicate of this bug. ***