This repository has been archived by the owner on Mar 9, 2020. It is now read-only.

ROW and COLUMN function targetting same cell work in Excel, EPPlus throws CircularReferenceException when Calculate enhancement #600

Open

jochenwezel opened this issue Dec 31, 2019 · 0 comments

jochenwezel commented Dec 31, 2019

Given is a cell

A1 with formula =ROW(A1) (so: self-targetting!)
B1 with formula =COLUMN(B1) (so: self-targetting!)

When EPPlus calculates

Then

EPPlus currently throws a CircularReferenceException (=misbehaviour)
EPPlus should correctly calculate
- expression ROW(A1) in A1 to value 1 and
- expression COLUMN(B1) in B1 to value 2

The text was updated successfully, but these errors were encountered:

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.