Bug 153298 - A complex formula does not work in Calc 7.4.x
Summary: A complex formula does not work in Calc 7.4.x
Status: RESOLVED DUPLICATE of bug 153297
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.5.1 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-01-31 21:35 UTC by Yurij
Modified: 2023-02-02 07:24 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
The table of monthly results of the work of employees with the forms of output of annual reports. (4.36 MB, application/vnd.oasis.opendocument.spreadsheet)
2023-02-02 07:24 UTC, Yurij
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Yurij 2023-01-31 21:35:08 UTC
Description:
In the Calc table of LibreOffice 7.3.7 and earlier, everything worked. In version 7.4.0 - 7.4.5, in the automatically filled sheet "DOWN" after any change of parameters in the sheets "LIST" ... "Ser", entries disappear.

Steps to Reproduce:
1.The error cannot be described, because it appears in a specific table.
But I don't see how to send it to you.
2.
3.

Actual Results:
When changing any parameter in the "LIST" ... "Ser" sheets, the data in the "DOWN" sheet disappears.

Expected Results:
Data should not disappear


Reproducible: Always


User Profile Reset: No

Additional Info:
The error occurs only in version 7.4.x. When returning to Calc 7.3.7 and earlier, the defect is absent, and then the damaged table can be restored by recalculating the fields of the "DOWN" sheet.

The sample table is ready for you. Its size is slightly larger than 4 Mb. Where should you send it?
Comment 1 m_a_riosv 2023-01-31 21:42:04 UTC

*** This bug has been marked as a duplicate of bug 153297 ***
Comment 2 Yurij 2023-02-02 07:24:03 UTC
Created attachment 185057 [details]
The table of monthly results of the work of employees with the forms of output of annual reports.

Any change in the parameter of any sheet from "LIST" to "Ser" in the "DOWN" sheet will delete all data.