Spreadsheet Workbench: Difference between revisions
Renatorivo (talk | contribs) (Marked this version for translation) |
No edit summary |
||
Line 1: | Line 1: | ||
<translate> |
<translate> |
||
<!--T:6--> |
<!--T:6--> |
||
{{Version|0.15}}The spreadsheet workbench allows you to create and edit spreadsheets, perform calculations, and retrieve data from a model, and export its |
{{Version|0.15}}The spreadsheet workbench allows you to create and edit spreadsheets, perform calculations, and retrieve data from a model, and export its data to other spreadsheet applications such as LibreOffice or Microsoft Excel. |
||
[[File:Spreadsheet_screenshot.jpg]] |
|||
== Supported Functions == |
|||
Line 8: | Line 14: | ||
<!--T:8--> |
<!--T:8--> |
||
The following aggregate functions are supported: average, count, max, min, stddev, sum |
The following aggregate functions are supported: average, count, max, min, stddev, sum. |
||
Aggregate functions are written with a colon: =average(B1:B8) |
|||
<!--T:9--> |
<!--T:9--> |
||
Line 21: | Line 29: | ||
<!--T:12--> |
<!--T:12--> |
||
Cell-references have to be written with upper letters. |
Cell-references have to be written with upper letters. |
||
== Reference To CAD-Data == |
|||
It is possible to use data from the construction in the spreadsheet. |
|||
The following table shows some examples |
|||
{|{{Prettytable}} |
|||
!CAD-Data |
|||
!Call in Spreadsheet |
|||
!Result |
|||
|--- |
|||
|Parametric Length of a Part-Workbench Cube |
|||
|=Cube.Length |
|||
|Length with units mm |
|||
|--- |
|||
|Volume of the Cube |
|||
|=Cube.Shape.Volume |
|||
|Volume without units im mm3 |
|||
|--- |
|||
|Type of the Cube-shape |
|||
|=Cube.Shape.ShapeType |
|||
|String: Solid |
|||
|--- |
|||
|} |
|||
Revision as of 17:25, 9 August 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 data to other spreadsheet applications such as LibreOffice or Microsoft Excel.
Supported Functions
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.
Aggregate functions are written with a colon: =average(B1:B8)
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.
Reference To CAD-Data
It is possible to use data from the construction in the spreadsheet. The following table shows some examples
CAD-Data | Call in Spreadsheet | Result |
---|---|---|
Parametric Length of a Part-Workbench Cube | =Cube.Length | Length with units mm |
Volume of the Cube | =Cube.Shape.Volume | Volume without units im mm3 |
Type of the Cube-shape | =Cube.Shape.ShapeType | String: Solid |
For FreeCAD earlier versions see Spreadhseet legacy