Accessing Data
Defining Layouts
Editing Data
Optimizing Performance
   
Add Your Own Functions

Add your own formulas by writing custom functions that implement our WinCalcManager public interface. Your custom formulas can then participate in a calc network just like a built in formula.

Formula Builder

Use the Formula Builder to visually design your formulas from built-in and custom functions. The Formula Builder makes it simple to compose and save your formulas.

Microsoft Excel Functions

The WinCalcManager provides the following functions to your application:

 Mathematical  Financial Text & Data  Date/Time  Information   Statistical
 SUM  PV  UPPER  DATE  NA  COUNT
 AVG  FV  LOWER  DATEVALUE  TYPE  MIN
 MOD  NPV  CONCATENATE  TODAY  ERRORTYPE  MAX
 ROUND  IRR  LEFT  DAY  ISBLANK  STD
 TRUNCATE  NPER  LEN  MONTH  ISERROR  MEDIAN
 EVEN / ODD  PMT  MID  YEAR  ISNA  VAR
 ABSOLUTE  PPMT  HOUR  ISNUMBER    
 CEILING  IPMT  TRIM  MINUTE  ISTEXT  
 FLOOR  RATE  VALUE  SECOND  ISEVEN  
 INT  INTRATE  FIND  NOW  ISODD  
 LOG  DB  REPLACE  TIME    
 LN  DDB  CHAR  TIMEVALUE    
 LOG10  SLN  CODE  DAYS360    
 RAND  SYD  ASC      
 PI    FIXED      
 EXP          
 POWER          
 PRODUCT          
 QUOTIENT          
 ACOS          
 ATAN          
 ATAN2          
 ATANH          
 COS          
 COSH          
 TAN          
 TANH          
 SQRT