Functions & formulas

Last review or update: May 4, 2025

Appizy supports most of Excel and OpenDocument spreadsheet formula using the Formula.js library.

Spreadsheet formulas to JavaScript

Web calculators are written in JavaScript. The syntax is quite different from what you might encounter in the formula bar of your spreadsheet tool. Appizy takes care of the translation.

Appizy uses the open-source library Formula.js to recreate the spreadsheet functions. It supports more than 280 spreadsheet functions.

If your spreadsheet tool uses a function not yet supported, you will get a notification during the conversion process. Check the error tab to get live feedback. In this case, some parts of your tool might look frozen because the formulas are being converted. Don’t hesitate to contact us. We can give you tips and workarounds for missing functions.

Formula accuracy

You must check the output accuracy of your web application. Although we are pleased to help you fix calculation bugs and divergences, we cannot be held responsible for calculation errors in the generated application.