Unable to use formula like =Table1[@[Column1]]

[rokam]

This issue is unique.

• I have used the search tool and did not find an issue describing my bug.

Operating System

Linux (DEB package)

Version information

8.0.1.31

Expected Behavior

When creating a formula, if I reference a cell inside a Table, it uses the direct sheet address (eg. A2) instead of
TableName[@[ColumnName]]. And if I force the TableName[@[ColumnName]] I receive a formula error message.

Actual Behavior

It should return the value of cell C11.

Reproduction Steps

1. Create a table in your spreadsheet
2. Inside the table create a formula that references any cell in the same line.
3. Replace the address value with the equivalent Table formula format.

Additional information

No response

[rsnegirev]

Hi @rokam

Can you please attach a file example?

[rokam]

I can't set the formula due to the alert. I can send you a file with a table in it, but that's all.
Does this help?
sample.xlsx

[StevePirateX]

This happens to me as well when I try the formats :

• Table1[@Fieldname] (this automatically comes up when clicking on the cell in the same row)
• Table1[@[FieldName]]
• Table1[@;[FieldName]]
• Table1[[@];[FieldName]]

I can type in Table1[[#This Row]] Table1[[@]] and Table1[@] and it highlights the row but not sure how to make it reference just the named cell.

Im using 8.1.0.169 (deb)

[rsnegirev]

Hi everyone

The problem was fixed in this one commit:
ONLYOFFICE/sdkjs@e4fe04f

Fixes will be released in the 8.1.1 version pretty soon.

[Rita-Bubnova]

DocumentServer v8.1.1 is released so I close this issue. Feel free to comment or reopen it if you got further questions.