Ambiente Spreadsheet
introduced in version 0.15The spreadsheet workbench allows you to create and edit spreadsheets, perform calculations, and retrieve data from a model, and export its contents to other spreadsheet applications such as LibreOffice or Microsoft Excel.
The spreadsheet provides the following functions taking one or two arguments: abs, acos, asin, atan, atan2, cos, cosh, exp, log, log10, mod, pow, sin, sinh, sqrt, tan, tanh
The following aggregate functions are supported: average, count, max, min, stddev, sum
The constants pi and e are predefined.
The conditional statement works like this: = condition ? resultTrue : resultFalse
Formulas are written as follows: =A2+A3
Cell-references have to be written with upper letters.
For FreeCAD earlier versions see Spreadhseet legacy