Circular reference when using "ROW" or "COLUMN"

0 Answers 58 Views
Spreadsheet
Ryabinin
Top achievements
Rank 1
Ryabinin asked on 01 Nov 2022, 09:43 AM

Hi!

There is a problem, when spreadsheet contains "ROW" or "COLUMN" function with self reference.

To reproduce this, open dojo:

https://dojo.telerik.com/IciGiroC

A3=OFFSET(A3, 1, COLUMN(A3)-1)

A4=1

A1=A3

What is expected: A1 value is 1

Actual result: A1 contains "#CIRCULAR"

Kendo UI Spreadsheet 2022.3.913

No answers yet. Maybe you can help?

Tags
Spreadsheet
Asked by
Ryabinin
Top achievements
Rank 1
Share this question
or