Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
How to retrieve a WorksheetRegion from an ExcelCalcValue


I've defined a custom function in Excel CalcEngine.

Some of the function parameters are Regions defined in Excel


In my code, when I receive the parameters, they are ExcelCalcValue.

How can I get the WorksheetRegion from the ExcelCalcValue ?

The Value property returns a Infragistics.Documents.Excel.FormulaUtilities.CalcEngine.RegionCalcReference type, which is not accessible, so I can't cast the result and access its Region property.

The GetResolvedValue() or ToArrayProxy returns a Infragistics.Documents.Excel.FormulaUtilities.CalcEngine.RegionCalcReference.RegionArrayProxy which is not accessible.

ToString() returns the class Type

Is there any way to retrieve the region ?

Thank you