How to troubleshoot formulas?

Hi everyone,
Made the switch from windows to linux a while ago, and along with it I went from MS Office to ONLYOFFICE. I have to say, I dreaded the switch, but your software is very polished and thought out.

However, some formulas I have used for years don´t seem to work exactly the way they did in MS Office. I want to evaluate these but I cannot find how to do it. I have found the “Function” button in the Formula tab, but I was hoping to trace this step by step (in MS Office this is called Evaluate).

I’m optimistic this is also possible in ONLYOFFICE, but how?

Thank you in advance!

Hello @Lemodile,
Here you can learn more about our formulas functionality - Use formulas in tables - ONLYOFFICE
If you need additional clarification, please ask more specifically, describe what issues did you face in particular

Hi Dimitri,
Thank you for your reply, unfortunately it does not help me. I know how to enter functions, but sometimes I make a mistake and get a #value error. In MS Excel I can evaluate these step by step using several methods.

A good explanation of the functionality I’m looking for is here: How to Use the "Evaluate Formula" Feature in Excel

Is something like this possible in ONLYOFFICE?

There is currently no such functionality, but we will consider the possibility of adding it on one of the future versions