Spreadsheet Workbench/it: Difference between revisions
Renatorivo (talk | contribs) No edit summary |
(Updating to match new version of source page) |
||
Line 1: | Line 1: | ||
{{Version|0.15}}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 il suo contenuto in altre applicazioni analoghe, come LibreOffice o Microsoft Excel. |
{{Version|0.15}}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 il suo contenuto in altre applicazioni analoghe, come LibreOffice o Microsoft Excel. |
||
[[File:Spreadsheet_screenshot.jpg]] |
|||
== Supported Functions == |
|||
Line 5: | Line 11: | ||
Sono supportate le seguenti funzioni di aggregazione: average, count, max, min, stddev, sum |
Sono supportate le seguenti funzioni di aggregazione: average, count, max, min, stddev, sum |
||
Aggregate functions are written with a colon: =average(B1:B8) |
|||
Le costanti pi greco ed e sono predefinite |
Le costanti pi greco ed e sono predefinite |
||
Line 14: | Line 22: | ||
I riferimenti alle celle devono essere scritti con lettere maiuscole. |
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: |
|||
{|{{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 in mm³ without units |
|||
|- |
|||
|Type of the Cube-shape |
|||
|=Cube.Shape.ShapeType |
|||
|String: Solid |
|||
|- |
|||
|Label of the Cube |
|||
|=Cube.Label |
|||
|String: Cube |
|||
|- |
|||
|x-coordinate of center of mass of the Cube |
|||
|=Cube.Shape.CenterOfMass.x |
|||
|x-coordinate in mm without units |
|||
|} |
|||
== Cell Properties == |
|||
The properties of a spreadsheet cell can be edited with a right-click on a cell. The following |
|||
dialog pops up: |
|||
[[File:SpreadsheetCellPropDialog.png]] |
|||
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{{Version|0.16-in Development}} |
|||
== 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². |
|||
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 [[Spreadhseet_legacy/it|Foglio di calcolo - Versione in via di sostituzione]] |
Per le versioni precedenti di FreeCAD vedere [[Spreadhseet_legacy/it|Foglio di calcolo - Versione in via di sostituzione]] |
Revision as of 21:06, 11 August 2015
introduced in version 0.15L'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 il suo contenuto 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
Sono supportate le seguenti funzioni di aggregazione: 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:
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 in mm³ without units |
Type of the Cube-shape | =Cube.Shape.ShapeType | String: Solid |
Label of the Cube | =Cube.Label | String: Cube |
x-coordinate of center of mass of the Cube | =Cube.Shape.CenterOfMass.x | x-coordinate in mm without units |
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-Expressionsintroduced in version 0.16-in Development
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².
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