Spreadsheet SetAlias: Difference between revisions

From FreeCAD Documentation
(non-latin characters are also invalid)
(Shortcut)
 
(14 intermediate revisions by 4 users not shown)
Line 1: Line 1:
<languages/>
<languages/>
<translate>
<translate>

<!--T:6-->
{{Docnav
|[[Spreadsheet_StyleUnderline|Style Underline]]
|[[Spreadsheet_Preferences|Preferences]]
|[[Spreadsheet_Workbench|Spreadsheet]]
|IconL=Spreadsheet_StyleUnderline.svg
|IconR=Preferences-spreadsheet.svg
|IconC=Workbench_Spreadsheet.svg
}}


<!--T:1-->
<!--T:1-->
{{GuiCommand
{{GuiCommand
|Name=Spreadsheet SetAlias
|Name=Spreadsheet SetAlias
⚫
|Workbenches=[[Spreadsheet_Module|Spreadsheet]]
|MenuLocation=-
|MenuLocation=-
⚫
|Workbenches=[[Spreadsheet_Workbench|Spreadsheet]]
|Shortcut={{KEY|Ctrl}}+{{KEY|Shift}}+{{KEY|A}}
|Version=0.17
|Version=0.17
}}
}}
Line 21: Line 32:
# Select a cell.
# Select a cell.
# Press the {{Button|[[File:Spreadsheet_SetAlias.svg|16px]] [[Spreadsheet_SetAlias|Spreadsheet SetAlias]]}} button.
# Press the {{Button|[[File:Spreadsheet_SetAlias.svg|16px]] [[Spreadsheet_SetAlias|Spreadsheet SetAlias]]}} button.
# Enter an alias:
# Enter an alias, which should be composed of simple, latin-only alphanumeric characters {{incode|[A-Za-z_]}}, without spaces or special symbols.
#* Only alphanumeric characters and underscores ({{incode|A}} to {{incode|Z}}, {{incode|a}} to {{incode|z}}, {{incode|0}} to {{incode|9}} and {{incode|_}}) are allowed.
#* The first character must be a letter.
#* Using 1 or 2 capital letters followed by 1 to 5 numbers, for example {{incode|AB123}}, is not allowed as this is considered a cell address.
#* Character sequences that are units are not allowed. For example {{incode|W}} is an invalid alias as it is the unit for [https://en.wikipedia.org/wiki/Watt Watt]. Since FreeCAD supports many units it is best to avoid short aliases. See [[Expressions#Units|Expressions]].
#* Using the mathematical constants {{incode|pi}} and {{incode|e}} as aliases will lead to errors and should be avoided.
#* Do not use spaces in aliases as they will also lead to errors.


<!--T:7-->
{{Docnav
|[[Spreadsheet_StyleUnderline|Style Underline]]
|[[Spreadsheet_Preferences|Preferences]]
|[[Spreadsheet_Workbench|Spreadsheet]]
|IconL=Spreadsheet_StyleUnderline.svg
|IconR=Preferences-spreadsheet.svg
|IconC=Workbench_Spreadsheet.svg
}}


</translate>
</translate>

Latest revision as of 12:21, 19 November 2023

Other languages:

Spreadsheet SetAlias

Menu location
-
Workbenches
Spreadsheet
Default shortcut
Ctrl+Shift+A
Introduced in version
0.17
See also
None

Description

The Spreadsheet SetAlias tool opens a dialog to set up an alias for a cell. Instead of using the exact cell name like A2, B3, or C4, a custom name can be used.

Usage

  1. Make sure there is an active Spreadsheet open so that the button is enabled.
  2. Select a cell.
  3. Press the Spreadsheet SetAlias button.
  4. Enter an alias:
    • Only alphanumeric characters and underscores (A to Z, a to z, 0 to 9 and _) are allowed.
    • The first character must be a letter.
    • Using 1 or 2 capital letters followed by 1 to 5 numbers, for example AB123, is not allowed as this is considered a cell address.
    • Character sequences that are units are not allowed. For example W is an invalid alias as it is the unit for Watt. Since FreeCAD supports many units it is best to avoid short aliases. See Expressions.
    • Using the mathematical constants pi and e as aliases will lead to errors and should be avoided.
    • Do not use spaces in aliases as they will also lead to errors.


Spreadsheet
User documentation
Retrieved from "http://wiki.freecad.org/index.php?title=Spreadsheet_SetAlias&oldid=1326891"