search

ONLYOFFICE / DesktopEditors

An office suite that combines text, spreadsheet and presentation editors allowing to create, view and edit local documents
https://www.onlyoffice.com
Other
2.64k stars 311 forks source link

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

Open rokam opened 2 months ago

rokam commented 2 months ago

This issue is unique.

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. image

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 commented 2 months ago

Hi @rokam

Can you please attach a file example?

rokam commented 2 months ago

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