Forums Ultimate UI for Windows Forms
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
Close
Vishal Vohra
4341
RADIANS function in CalcManager
posted

 

 

 

 

 

 

 

 

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) ?

  • 469350
    Offline posted

    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.