Critical Issue: Formula References to Other Sheets Become Corrupted (#REF! Errors)

[eSkry]

This issue is unique.

• [x] I have used the search tool and did not find an issue describing my bug.

Operating System

Linux (RPM package)

Version information

8.3.3.21 (flatpak)

Expected Behavior

I use formulas linking to cells on another sheet. When saving and reopening the document, everything should continue functioning correctly.

Actual Behavior

I'm working with a document containing links to cells from another sheet within the same document. At random times upon opening the document, I receive permanently corrupted formulas resulting in an entirely damaged document.

Reproduction Steps

1. Create a new document and enter formulas that reference cells from another sheet.
2. Save the document.
3. Over the course of several days, repeatedly open the document, make changes, and save it.
4. After some period of time, notice that the document becomes corrupted (even though it was saved properly before).

Additional information

ONLYOFFICE DesktopEditors has a critical issue when working with formulas that reference other sheets.

Create a formula referencing cells in another sheet and save the document. You can work with it for some time without any problems. The formula works fine even after several days of usage. However, one day you open the file again and see "#VALUE!" instead of the expected results in the cells. In the formulas themselves, the sheet name and cell references are replaced by "#REF!". Despite this, the referenced sheet still exists and hasn't been deleted. Unfortunately, the formula is irreversibly DAMAGED! For example, we end up with something like this:

"=SUMIFS(#REF!,CONCATENATE("",MID(B5,1,3),""),#REF!)+SUMIFS(#REF!,"All",#REF!)". There is no information about which sheet or cells were used. THIS IS A COMPLETELY CORRUPTED DOCUMENT THAT WAS PREVIOUSLY SAVED IN A VALID STATE.

[Dmitry-Kov]

Hello @eSkry, Could you kindly attach the problematic file so that we can investigate and identify the issue?

[Rita-Bubnova]

This issue was closed due to no response.

[kay1979]

I can reproduce this issue with Community-Version 9.0.4.50 (flatpak) on linux (Pop!_OS 22.04 LTS) (german).

Steps to reproduce

• The workbook contains at least two sheets.
• A cell in Sheet1 references to a cell in Sheet2 (e.g. "=Sheet2!A1"): See Bugreport.xlsx
• Move Sheet2 (e.g. in front of Sheet1)
• Save and close the file
• Reopen the file: REF! / #BEZUG! Error is displayed (see Bugreport.Sheet2_reordered.xlsx)

[Rita-Bubnova]

@Dmitry-Kov, Take a look, please.

[Dmitry-Kov]

Hello @kay1979 ,

I can confirm - this is bug 74793. When some fixes will be done we'll text you here in this issue. Thank you for the report!

Problem can be reproduced in DocumentServer.

[naeemshah]

Any updates?

[Dmitry-Kov]

Hello @naeemshah,

This issue is still in progress. We’ll post an update here once there are any changes.