Setting Formulas - Notice for Non-English Users

Aspose.Cells supports most of the formulas/functions that are part of Microsoft Excel. Developers can use these formulas with either the API or designer spreadsheets. Aspose.Cells supports a huge set of mathematical, string, Boolean, date/time, statistical, database, lookup and reference formulas. The formulas should be specified using English (US) style.

There are two tips that non-English users must follow when creating formulas with Aspose.Cells:

1. Formulas must be entered in English.
   For example, use the English “=SUM()” not the German “=SUMME()”.
2. Always use a comma (,) to delimit function parameters.
   For some language options or settings, the delimiter for function parameters is a semicolon but Aspose.Cells uses the English style comma. For example, use “=IF(C5=0,0,C3/C4)” not “=IF(C5=0;0;C3/C4)”