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

Syntax for referencing current row value by column name?

In Excel data tables, you can very easily reference values within the current row by their column names using the following syntax:

=[@number] * [@price]

That makes formulas very clear and readable when you don’t need to type specific cell numbers, letters.

However, when I’m trying that syntax in OO, I just get “Error while parsing the formula”.

So, is it possible to somehow reference values by column names in OO? And is there any compatibility chart between formula syntax in Excel vs OO?

Links to Excel formula syntax:

Hello @midvok
Would you mind providing us with a test file and step-by-step description about how to reproduce the situation? We would like to take a closer look at it.