Spreadsheet Workbench: Difference between revisions

From FreeCAD Documentation
(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 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 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