Meet ONLYOFFICE Docs Cloud, complete office software as a service
Meet ONLYOFFICE Docs Cloud

Inserting/deleting rows/columns breaks formulas with $

OS version: MacOS 12.4
App version: 7.1 (532)
Downloaded from: ONLYOFFICE website

Every formula including fixed references (with $) will stay not updated after inserting/deleting rows/columns, not only in cells but also in conditional formatting. Undoing (Command-Z or Ctrl-Z) won’t get things back as they were. So there are two bugs involved here.

Thank you for developing OnlyOffice!

1 Like

Hello @lodgmar
Could you please provide us with a file where the issue reproduces and step-by-step description how to reproduce it?

Hi,
I’m having the same issue. I think the formula breaks when I close the file and then open it again. If I don’t close the file formula works correctly when adding or deleting rows/columns (at least on my case).
Update: tried to reproduce the error but I can’t yet

Capture
Another error that frequently occurs is the attached.
The cell shows the error “#NAME?”, but if you see the formula there is not anything that could be wrong. And this error affects all the concatenated cells.
Then if you just double click the source cell (F16) and press enter, the error is gone

Hello @mnar2
Sorry for the late reply.
Could you please share a test file where described issue reproduces?

Hi Alexandre,

I’m attaching a similar error.
Here it’s the file link: Formula Break2.xlsx - RapidShare

If you just double click cell B18 and press Enter, the formula then returns the value “8”.

Thank you for the file, we are checking the situation.

1 Like

@mnar2
Thank you for pointing us to this situation, we have reproduced the issue and we added a bug to internal tracksystem (internal number - 58888). We have started working on it

1 Like

Sorry for the big delay. Really busy this last month.

Have you done any upgrade? Because I can’t reproduce the issue in the same file that was failing.

Hello @lodgmar
We have checked the issue with @mnar2 's file and we added a bug to internal tracksystem (we are working on it).
As for your scenario, unfortunately we didn’t get requested file\exact scenario. As far as I understand your issue has gone.
Anyway, if you face similar situation, please provide us with a test file and exact issue scenario.