public static ErrorValue Circularity {get;}
There is no error constant for a circularity in Microsoft Excel and a circularity cannot be the result of a formula in Microsoft Excel. However, for run-time purposes, after loading or before saving a workbook, this error value will be used for the result of formulas which cause circular references when the owning workbook has Workbook.IterativeCalculationsEnabled set to False.
In Microsoft Excel, setting a circular reference formula on a cell will show an error dialog the first time the problem occurs. Subsequent formulas violating the circular reference restriction will just evaluate to zero. Therefore, when this value is encountered in a cell, it can be treated as a zero for calculation purposes. This error value will be returned though so an actual zero value in a cell can be differentiated from a circularity error.
Note: Because there is no circularity error constant in Microsoft Excel, this error value cannot be assigned to a cell manually. Attempting to assign this error value to a cell will result in an InvalidOperationException to be thrown. This error value will only be valid as the result of a formula which has been applied to a cell.
Target Platforms: Android 4.4+, iOS 8+
Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+