DocumentServer icon indicating copy to clipboard operation
DocumentServer copied to clipboard

OFFSET function incorrectly trips a circular reference error

Open AronGahagan opened this issue 7 months ago • 1 comments

This issue is unique.

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

Operating System

other (specify in description), Linux (DEB package)

Version information

version 8.3.1.25 (deb)

Expected Behavior

In the spreadsheet editor, the OFFSET() function is incorrectly tripping a circular reference error.

You should be able to put, in cell C3 =OFFSET(C3,-1,0) and have it reference the cell immediate above.

Actual Behavior

In the spreadsheet editor, if you put in cell C3 the formula =OFFSET(C3,-1,0) you get a circular reference error.

Reproduction Steps

Enter the following formula in cell C3: =OFFSET(C3,-1,0)

Additional information

No response

AronGahagan avatar May 09 '25 21:05 AronGahagan

Hello @AronGahagan,

I created bug 74432 for your problem. When some fixes will be done we'll text you here in this issue. Thank you for the report!

Problem can be reproduced in DocumentServer.

Dmitry-Kov avatar May 13 '25 12:05 Dmitry-Kov