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