Gets the number of columns in the cell or range reference.
Syntax
Visual Basic (Declaration) | |
---|
Public MustOverride ReadOnly Property ColumnCount As Integer |
Visual Basic (Usage) | Copy Code |
---|
Dim instance As CalcReference
Dim value As Integer
value = instance.ColumnCount |
C# | |
---|
public abstract int ColumnCount {get;} |
Property Value
Integer number of columns in the cell or range reference
Example
This example creates a custom function.
C# | Copy Code |
---|
public class Cube : FarPoint.CalcEngine.FunctionInfo
{
public override string Name
{
get
{
return "Cube";
}
}
public override int MaxArgs
{
get
{
return 1;
}
}
public override int MinArgs
{
get
{
return 1;
}
}
public override bool AcceptsReference(int i)
{
if (i == 0)
{
return true;
}
else
{
return false;
}
}
public override object Evaluate(object[] args)
{
double total;
FarPoint.CalcEngine.CalcReference cellref;
object value;
if (args[0] is FarPoint.CalcEngine.CalcArray)
{
return FarPoint.CalcEngine.CalcError.Value;
}
if (args[0] is FarPoint.CalcEngine.CalcReference)
{
cellref = ((FarPoint.CalcEngine.CalcReference)(args[0]));
if (cellref.ColumnCount > 1 | cellref.RowCount > 1)
{
return FarPoint.CalcEngine.CalcError.Value;
}
value = cellref.GetValue(cellref.Row, cellref.Column);
try
{
total = Math.Pow(FarPoint.CalcEngine.CalcConvert.ToDouble(args[0]), 3);
}
catch
{
}
}
else
{
try
{
total = Math.Pow(FarPoint.CalcEngine.CalcConvert.ToDouble(args[0]), 3);
}
catch
{
}
}
return total;
}
} |
Visual Basic | Copy Code |
---|
Public Class Cube
Inherits FarPoint.CalcEngine.FunctionInfo
Public Overrides ReadOnly Property Name() As String
Get
Return "Cube"
End Get
End Property
Public Overrides ReadOnly Property MaxArgs() As Integer
Get
Return 1
End Get
End Property
Public Overrides ReadOnly Property MinArgs() As Integer
Get
Return 1
End Get
End Property
Public Overrides Function AcceptsReference(ByVal i As Integer) As Boolean
If i = 0 Then
Return True
Else
Return False
End If
End Function
Public Overrides Function Evaluate(ByVal args() As Object) As Object
Dim total As Double
Dim cellref As FarPoint.CalcEngine.CalcReference
Dim value As Object
If TypeOf args(0) Is FarPoint.CalcEngine.CalcArray Then Return FarPoint.CalcEngine.CalcError.Value
If TypeOf args(0) Is FarPoint.CalcEngine.CalcReference Then
cellref = CType(args(0), FarPoint.CalcEngine.CalcReference)
If cellref.ColumnCount > 1 Or cellref.RowCount > 1 Then Return FarPoint.CalcEngine.CalcError.Value
value = cellref.GetValue(cellref.Row, cellref.Column)
Try
total = FarPoint.CalcEngine.CalcConvert.ToDouble(value) ^ 3
Catch
End Try
Else
Try
total = FarPoint.CalcEngine.CalcConvert.ToDouble(args(0)) ^ 3
Catch
End Try
End If
Return total
End Function
End Class |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also