Structured references

Docs
,
1

Hello Community,

I need help with using structured references in OnlyOffice. I have a worksheet named “rawdata2025” that contains my account transactions from the previous month. I want to transfer specific columns from this worksheet to a new worksheet (Sheet 2), and I want this transfer to happen automatically whenever I update “rawdata2025” with new data.

My Attempts So Far:

  1. Structured References: I tried to transfer the column “Name Zahlungsbeteiligter” using the following formula:

=rawdata2025[[#Headers],[Name Zahlungsbeteiligter]]

However, this resulted in an error. I also tried using “Titel” instead of “Headers” since I’m using OnlyOffice in German, but that didn’t work either.

  1. Table Definition Check: I ensured that the range in “rawdata2025” is defined as a table.

  2. Simple Cell References: I tried using simple cell references, but this is not the preferred method as I need dynamic updates.

  3. Name Manager: I considered defining the range manually using the Name Manager, but I’m not sure if this is the best solution.

Question for the Community:

Is there a specific syntax or setting in OnlyOffice that I need to consider to use structured references correctly? Are there any known limitations or alternative methods to solve this issue?

I would appreciate any help or suggestions!

Thank you in advance!

2

Hello @laurey :wave:

Thank you for reaching out to us with your question!
We’re happy to assist you with your issue regarding structured references in OnlyOffice. We’ll need a little time to investigate this matter thoroughly and figure out what might be going wrong.

If it’s not too much trouble, we’d be incredibly grateful if you could record a short video demonstrating the issue. It would really help us see the problem more clearly and find the best solution for you.

We’ll get back to you as soon as we can! :hugs:

4

Hi @laurey,

For your scenario to work as expected, functionality that is currently unavailable is required.

We have added your request to an existing known issue regarding spilled arrays. This feature allows formulas to return multiple values that automatically populate adjacent cells.

We appreciate your feedback and will keep you updated on any progress.