Spreadsheet Editor formulas break upon interaction

Hi,

I just reported a bug on connector app’s Github and wanted to follow up here with a discussion as I do not know whether this is specifically the connector app issue.

This affects spreadsheets that previously worked fine.

Let me describe the issue in more detail: if you add SUMIF or any more nuanced formulas, or if you edit one variable in a existing formula, the cell displays raw content of the formula rather than calculating the value. It is in fact sufficient to click into a cell and click out of it to make the formula turn from the previously working value into a raw formula text.

The issue prevails even if I copy the content of the tab into a new spreadsheet. It is an absolutely critical bug that makes it impossible to use ONLYOFFICE Spreadsheet editor.

Please investigate this issue and provide a fix in a future update. In the meantime, any workarounds or temporary solutions would be greatly appreciated.

Hello @szanimorph

What version of Document Server is used? We have just released new version 8.2.1, does the same behavior occurs with it?

If it does, can you share an example of file with such formula and step-by-step scenario on how to reproduce it on real example?

Hello,
I appreciate your response.
We are unable to reproduce this beyond one specific issue, I just closed the Github issue for now.

1 Like

Good to know. I’m closing the topic as solved.