Exporting Formulas to Excel Before You Begin The WinGridExcelExporter™ has the ability to export data from WinGrid™ to Microsoft® Excel® file format. Considering a Grid that has an unbound WinCalcManager™ calculated column, you might want the Grid formula to be translated into an actual Excel function in the creat...
Financial Functions Below is a list of all Microsoft® Excel®-style financial functions provided by the WinCalcManager™ control. DB DDB FV INTRATE IPMT IRR NPER NPV PMT PPMT PV RATE SLN SYD DOLLARDE DOLLARFR Related Topics: Date and Time Functions Engineering Functions Information Functions Logical Functions Lookup...
WinCalcManager Formula and Reference Guide This topic will help you learn about how to create formulas and reference various source items when using WinCalcManager™. The UltraGridColumn and SummarySettings object’s Formula property is used to assign a string that contains WinCalcManager specific formula syntax. He...
WinCalcManager FormulaBuilder Resource Strings Reference You can quickly and easily modify any resource string value that is displayed to a user by a control/component. Resource strings include items such as dialog box captions, warning messages, alerts, etc. The following table lists the names of the resource str...
Information Functions Below is a list of all Microsoft® Excel®-style information functions provided by the WinCalcManager™ control. ERRORTYPE DBNULL NULL ISBLANK ISDBNULL ISERR ISERROR ISLOGICAL ISEVEN ISNA ISNONTEXT ISNULL ISNUMBER ISODD ISREF ISTEXT NA TYPE INFO N Related Topics: Date and Time Functions Engineer...
Logical Functions Below is a list of all Microsoft® Excel®-style logical functions provided by the WinCalcManager™ control. AND FALSE IF NOT OR TRUE Related Topics: Date and Time Functions Engineering Functions Financial Functions Information Functions Lookup and Reference Functions Math Functions Statistical Func...
Lookup and Reference Functions Below is a Microsoft® Excel®-style Lookup and Reference function provided by the WinCalcManager™ control. Choose Related Topics: Date and Time Functions Engineering Functions Financial Functions Information Functions Logical Functions Math Functions Statistical Functions Text and Dat...
Math Functions Below is a list of all Microsoft® Excel®-style math functions provided by the WinCalcManager™ control. ABS ACOS ACOSH ASIN ASINH ATAN ATAN2 ATANH CEILING COS COSH EVEN ODD EXP EXPON FLOOR INT LN LOG LOG10 MOD PI POWER PRODUCT QUOTIENT RAND ROUND SQRT SIN SINH SUM TAN TANH TRUNC COMBIN DEGREES FACT F...
NamedReferences Formula A NamedReference is essentially a formula that is independent of a control. NamedReferences have many uses, such as defining constants or formulas that are used in other calculations but do not need to be visible to the end-user. The most important properties of the NamedReferences are: Pro...
WinCalcManager Resource Strings Reference You can quickly and easily modify any resource string value that is displayed to a user by a control/component. Resource strings include items such as dialog box captions, warning messages, alerts, etc. The following table lists the names of the resource strings that are u...