Spreadsheet Workbench/de: Difference between revisions
Renatorivo (talk | contribs) (Created page with "Category:User Documentation/de") |
(Updating to match new version of source page) |
||
| Line 1: | Line 1: | ||
The 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 |
{{Version|0.15}}The 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. |
||
[[Image:Arch tutorial 53.jpg]] |
|||
== Tools == |
|||
* [[Image:Spreadsheet Create.png|16px]] [[Spreadsheet Create|Spreadsheet]]: Creates a new spreadsheet object in the active document. |
|||
* [[Image:Spreadsheet Controller.png|16px]] [[Spreadsheet Controller|Cell Controller]]: Adds a cell controller to a selected spreadsheet. |
|||
* [[Image:Spreadsheet PropertyController.png|16px]] [[Spreadsheet PropertyController|Property Controller]]: Adds a property controller to a selected spreadsheet. |
|||
== File formats == |
|||
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 |
|||
* [[Spreadsheet CSV|Comma-separated values (.CSV)]]: Imports and exports spreadsheet data from/to a .csv file |
|||
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|Spreadhseet legacy]] |
|||
{{Docnav| | }} |
{{Docnav| | }} |
||
[[Category: |
[[Category:User_Documentation]] |
||
{{clear}} |
{{clear}} |
||
Revision as of 22:07, 5 March 2015
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
