Bug 153298

Summary:	A complex formula does not work in Calc 7.4.x
Product:	LibreOffice	Reporter:	Yurij <yurijivanovych>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	miguelangelrv
Priority:	medium
Version:	7.4.5.1 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	The table of monthly results of the work of employees with the forms of output of annual reports.

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.