Spreadsheet Preferences: Difference between revisions

From FreeCAD Documentation
(add note on how the preference page is enabled by either visiting the workbench or opening a file containing a spreadsheet)
(Wording more in keeping with the tooltips.)
Line 15: Line 15:
<translate>
<translate>


The preferences for the [[Image:Workbench_Spreadsheet.svg|24px|link=Spreadsheet_Workbench]] [[Spreadsheet_Workbench|Spreadsheet Workbench]] can be found in the [[Preferences Editor|Preferences Editor]]. This feature is enabled after visiting the workbench or after opening a document containing a spreadsheet object. In the menu select {{MenuCommand|Edit Preferences...}} and then {{MenuCommand|Spreadsheet}}.
The preferences for the [[Image:Workbench_Spreadsheet.svg|24px|link=Spreadsheet_Workbench]] [[Spreadsheet_Workbench|Spreadsheet Workbench]] 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 loading the workbench via the ''Available Workbenches'' tab in the {{MenuCommand|Workbenches}} section.


You can specify the following:
You can specify the following:
Line 24: Line 24:
|-
|-
| {{MenuCommand|Delimiter Character}}
| {{MenuCommand|Delimiter Character}}
| The character that is used as delimiter of the cells when the table is imported or exported.
| The character used as field delimiter.
|-
|-
| {{MenuCommand|Quote Character}}
| {{MenuCommand|Quote Character}}
| The character used for quotations.
| The character used to delimit strings.
|-
|-
| {{MenuCommand|Escape Character}}
| {{MenuCommand|Escape Character}}
| The character to tell the parser that the following sequence should not be parsed.
| The character used to prevent the following character from being parsed.
|-
|-
|}
|}

Revision as of 19:44, 3 October 2021

Other languages:

The preferences for the Spreadsheet Workbench 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 loading the workbench via the Available Workbenches tab in the Workbenches section.

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 preferences settings