search

nissl-lab / npoi

a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop.
Apache License 2.0
5.73k stars 1.43k forks source link

Iterative Calculation feature #1245

Open honix opened 10 months ago

honix commented 10 months ago

NPOI Version Used

2.6.2

File Type

Use Case

I love the possibility to interpret my spreadsheets in C#! But I meet some difficulties with evaluating cells with circular references. Some of my formulas depends on its previous state. If it detects circular reference, the value of cell evaluated to ~CIRCULAR~REF~.

I know there is optional Iterative Calculation feature in Excel, and Google Spreadsheets. Is there any possibilities to evalute cells with circular reference using NPOI?

Thanks!

tonyqus commented 6 months ago

What will Microsoft Excel show if it detects circular reference? nothing?