Is3DReference Property

Is3DReference

Declaration

public bool Is3DReference { get; }

Public ReadOnly Property Is3DReference As Boolean

Examples

CustomFunction function = new Ref3DFunction();
Workbook.AddCustomFunction(function, true);
worksheet.Range["A1:B2"].Value = new object[,] {{1, 2}, {3, 4}};
worksheet.Range["C1"].Formula = "=IS3DREF(A1:B2)";
object is3D = worksheet.Range["C1"].Value;

class Ref3DFunction : CustomFunction
{
    public Ref3DFunction()
        : base("IS3DREF", FunctionValueType.Boolean, new Parameter[] { new Parameter(FunctionValueType.Object, true, false) })
    {
    }

    public override object Evaluate(object[] arguments, ICalcContext context)
    {
        CalcReference reference = (CalcReference)arguments[0];
        return reference.Is3DReference;
    }
}