Hello Support,
We are using the Win CalcManager to fetch the in-built formulas, Following is the function we use for fetching the in-built columns :
Private Sub LoadFunction()
Dim FormulaBuilderInfo As IFormulaBuilderInfo
FormulaBuilderInfo =
DirectCast (UltraCalcManager1, IFormulaBuilderInfo)
Dim i As Integer = 0
For i = 0 To FormulaBuilderInfo.GetAllFunctions.Length - 1
lstFunction.Items.Add(FormulaBuilderInfo.GetAllFunctions(i).Name.ToString)
Next
End
Sub
Suppose we have columns like :
Length
Width
Area (Length * Width)
and Area column has a formula as (Length * Width) .
We want to use the 'AND' and the 'RADIANS' function, these functions are missing in the Calcmanager, how do we get the functionality for these function. say if we give a formula as 'IIF ( LENGTH = WIDTH AND LENGTH > 0, 0, LENGTH * WIDTH). if we give this formula to a column the 'AND' function is ignored and it gives error. Is there any other functions having same functionality as 'AND" and 'Radians'.
Also what is the equivalent function for ROUND (same as round function in excel) ?
Hi,
I'm afraid I am having a hard time understand your question. Why are you using The FormulaBuilderInfo to get the functions? You don't need to do that in order to create a formula. A Formula is simply a string.
There is an And function, but all CalcManager functions have a syntax where you use parens. So And looks like this:
"AND(condition1, condition2)"
So the formula you have here would be written like so:
'IIF ( AND([LENGTH] = [WIDTH], [LENGTH > 0], 0, [LENGTH] * [WIDTH] )"
And there IS a RADIANS function, so I am not sure why you are having trouble locating it. All of the functions show up in the FormulaBuilder at design-time, and Radians is on the list, as is AND.
Dear Mike,
Thanks a lot for the reply.