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
135
How to retrieve a WorksheetRegion from an ExcelCalcValue
posted

Hello,

I've defined a custom function in Excel CalcEngine.

Some of the function parameters are Regions defined in Excel

=MyFunction(125,A1:A23,D5:D56)

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