GrapeCity.Documents.Excel.Parameter.AcceptReference

AcceptReference Property

AcceptReference

Gets whether the parameter accepts a reference value.

Use this property to determine whether a custom function parameter can receive a cell or range reference instead of only the referenced value.

Declaration

public bool AcceptReference { get; }

Public ReadOnly Property AcceptReference As Boolean

Examples

Parameter rangeParameter = new Parameter(FunctionValueType.Object, true);
Workbook.AddCustomFunction(new SumRangeFunction(new[] { rangeParameter }), true);
worksheet.Range["A1:A3"].Value = new object[,] {{1}, {2}, {3}};
worksheet.Range["B1"].Formula = "=SUM_RANGE(A1:A3)";
bool acceptReference = rangeParameter.AcceptReference;