Bug 160476 - insert object formula in calc disappears when saving as xlsx format
Summary: insert object formula in calc disappears when saving as xlsx format
Status: RESOLVED DUPLICATE of bug 103406
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.8.1 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-04-02 09:40 UTC by Paul Frost
Modified: 2024-04-02 15:49 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 Paul Frost 2024-04-02 09:40:36 UTC
Description:
in libre office calc if I add a mathematical formula using the insert | object | formula option and then save the file selecting the xlsx format the formula is missing when the file is re-opened

Steps to Reproduce:
1.open calc application and create new file
2.select a cell
3.from the menu select insert then object then formula
4.add a formula (just choose one from the examples)
5.save the file as xlsx format
6.close calc application
7.re-open the file
8.the formula is gone

Actual Results:
blank cell where formula should be

Expected Results:
formula to be retained


Reproducible: Always


User Profile Reset: No

Additional Info:
tried with both xlsx and xlsx open xml format

Version: 7.1.8.1
Build ID: 10(Build:1)
CPU threads: 8; OS: Linux 5.14; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-US
Calc: threaded
Comment 1 Paul Frost 2024-04-02 09:48:38 UTC
Tried reset of profile and in safe mode a warning is provided saying some formatting may be lost when saving in xlsx format.  May not be a supported feature.  Has caused me significant data loss.  Understand the message didn't display as I had ticked to supress message..  Would be good if it did work.
Comment 2 m_a_riosv 2024-04-02 15:49:01 UTC

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