Formula recalculation engine

Some facts in short:
  • XLSX and ODS export/import: all formulas are supported.
  • XLS export/import: see the following table for supported functions.
  • CSV export: the result of a formula is automatically calculated and exported. See the following table for supported functions.

Supported functions by the XLS format and recalculation engine of OExport

ROWCOLUMNSINCOSTAN
ATANPISQRTEXPLN
LOG10ABSINTSIGNROUND
DATETIMEDAYMONTHYEAR
WEEKDAYHOURMINUTESECONDNOW
ASINACOSDATEVALUETIMEVALUETODAY
ROUNDUPROUNDDOWNSINHCOSHTANH
ASINHACOSHATANH
SUMAVERAGEMINMAXTRUNC



I'd like to use an Excel/Calc build-in function, but I don't know the appropriate function name, what should I do?

If you try to store some function and Excel/Calc doesn't want to open your document, you probably misstyped the formula string. Be sure you use English function names in functions.

First, check the list of Excel functions in the Microsoft help file.

If it hasn't helped, use the OExportSimpleDemo.exe (full source code is included) to import the document formula strings (tab Import, Button Read formulas).

Categories