Cloud Computing Insider Awards 2022: Vote for ONLYOFFICE
Vote for ONLYOFFICE

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