Spreadsheet Preferences: Difference between revisions

From FreeCAD Documentation
(initial)
 
mNo edit summary
 
(15 intermediate revisions by 3 users not shown)
Line 1: Line 1:
<languages/>
<languages/>
<translate>
<translate>

<!--T:1-->
{{Docnav
{{Docnav
|[[Spreadsheet_SetAlias|Set Alias]]
|[[Spreadsheet_SetAlias|Set Alias]]
Line 14: Line 16:
<translate>
<translate>


<!--T:2-->
The preferences screen of the [[Image:Workbench_Spreadsheet.svg|24px|link=Spreadsheet_Workbench]] [[Spreadsheet_Workbench|Spreadsheetr Workbench]] are found in the [[Preferences_Editor|Preferences Editor]], {{MenuCommand|Edit → Preferences → Spreadsheet}}.
The preferences for the [[Image:Workbench_Spreadsheet.svg|24px|link=Spreadsheet_Workbench]] [[Spreadsheet_Workbench|Spreadsheet Workbench]] ({{Version|0.20}}) can be found in the [[Preferences Editor|Preferences Editor]]. In the menu select {{MenuCommand|Edit → Preferences...}} and then {{MenuCommand|Spreadsheet}}. This section is only available after opening a document containing a spreadsheet object, after visiting the workbench or after loading the workbench via the ''Available Workbenches'' tab in the {{MenuCommand|Workbenches}} section.


<!--T:3-->
In the preferences you can specify the following:
There is only one tab: ''Spreadsheet'' in the {{MenuCommand|Spreadsheet}} section. On this tab you can specify the following:
{| class="wikitable float-right mw-collapsible mw-collapsed"

<!--T:4-->
{| class="wikitable"
!style="width: 33%;"|Name
!style="width: 33%;"|Name
!style="width: 66%;"|Description
!style="width: 66%;"|Description
|-
|-
| {{MenuCommand|Delimiter Character}}
| {{MenuCommand|Delimiter Character}}
| The character used as field delimiter.
| If checked, a grid will be shown in the sketches.

This option and the following 5 preferences settings can also be specified only for single sketches in the [[Sketcher_Dialog#Edit_controls|sketcher dialog]] section ''Edit controls''.
|-
|-
| {{MenuCommand|Quote Character}}
| {{MenuCommand|Quote Character}}
| The character used to delimit strings.
| The distance between two subsequent grid lines. Note that the default value of 0 mm will result in a 10 mm grid.
|-
|-
| {{MenuCommand|Escape Character}}
| {{MenuCommand|Escape Character}}
| The character used to prevent the following character from being parsed.
| If checked, new points will snap to the nearest grid line. Note that the points have already to be close to a grid line that the snap takes effect. The distance is a fifth of the value set for {{MenuCommand|Grid size}}, so for a 10 mm grid, the snapping only occurs if the point is not more than 2 mm away from a grid line.
|-
|-
|}
|}


<!--T:28-->
<!--T:5-->
[[Image:Spreadsheet-Preferences-Spreadsheet.png]]
[[Image:Spreadsheet-Preferences-Spreadsheet.png]]
{{Caption|The Spreadsheet tab}}




<!--T:6-->
{{Docnav
{{Docnav
|[[Spreadsheet_SetAlias|Set Alias]]
|[[Spreadsheet_SetAlias|Set Alias]]
Line 46: Line 52:
|IconC=Workbench_Spreadsheet.svg
|IconC=Workbench_Spreadsheet.svg
}}
}}



</translate>
</translate>

Latest revision as of 10:36, 31 May 2022

Other languages:

The preferences for the Spreadsheet Workbench (introduced in version 0.20) can be found in the Preferences Editor. In the menu select Edit → Preferences... and then Spreadsheet. This section is only available after opening a document containing a spreadsheet object, after visiting the workbench or after loading the workbench via the Available Workbenches tab in the Workbenches section.

There is only one tab: Spreadsheet in the Spreadsheet section. On this tab you can specify the following:

Name Description
Delimiter Character The character used as field delimiter.
Quote Character The character used to delimit strings.
Escape Character The character used to prevent the following character from being parsed.

The Spreadsheet tab