Spreadsheet Workbench/it

L'ambiente Spreadsheet consente di creare e modificare un foglio di calcolo, inoltre permette di eseguire le operazioni, di recuperare i dati da un modello e di esportare i sui dati in altre applicazioni analoghe, come LibreOffice o Microsoft Excel.



Supported Functions
Il foglio di calcolo fornisce le seguenti funzioni che accettano uno o due argomenti: 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)

Le costanti pi greco ed e sono predefinite

L'istruzione condizionale funziona così: = condition ? resultTrue : resultFalse

Le formule sono scritte in questo modo: =A2+A3

I riferimenti alle celle devono essere scritti con lettere maiuscole.

Reference To CAD-Data
It is possible to use data from the construction in the spreadsheet. The following table shows some examples:

Cell Properties
The properties of a spreadsheet cell can be edited with a right-click on a cell. The following dialog pops up:



It has several tabs. The following properties can be changed:


 * Text color and background color
 * Text horizontal and vertical alignment
 * Text style: bold, italic, underline
 * Display unit for this cell. Please read the section below.
 * Define an alias-name for this cell. This alias-name can be used in cell-formulas and also in FreeCAD-Expressions

Units
The Spreadsheet uses units. If a number has a unit, this unit will be used in all calculations. The multiplication of two length with the unit mm gives an area with the unit mm&sup2;.

You can switch the length-unit from mm to inch in the dialog, you get with a right-click on a cell. The cell will now show the length in inches. The value used for calculations does not change. The results of a formula using this value do not change, when the shown unit of an input was changed. The result is still calculated from the length in mm.

A number without a unit cannot be changed in a number with unit by the cell properties dialog. One can put in a unit string, that will also be shown, but the cell still contains only a number without unit.

Sometime it is desirably to get rid of a unit. This can only to be done by multiplying with 1 with a reciprocal unit.

Current Limitations
It is not possible to select and copy multiple cells. Only the content of a cell from the input field can be copied and paste into the input field of another cell.

Per le versioni precedenti di FreeCAD vedere Foglio di calcolo - Versione in via di sostituzione