Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
Setting Formulas - Notice for Non-English Users
Contents
[
Hide
]
Aspose.Cells for Python via .NET 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 for Python via .NET 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.
Notice for Non-English Users
There are two tips that non‑English users must follow when creating formulas with Aspose.Cells for Python via .NET:
- Formulas must be entered in English. For example, use the English “
=SUM()” instead of the German “=SUMME()”. - Always use a comma (
,) to delimit function parameters. In some language options or settings, the delimiter for function parameters is a semicolon, but Aspose.Cells for Python via .NET uses the English‑style comma. For example, use “=IF(C5=0,0,C3/C4)” instead of “=IF(C5=0;0;C3/C4)”.