Spreadsheet SetAlias/es: Difference between revisions

From FreeCAD Documentation
(Created page with "{{Docnav |Estilo Subrayado |Preferencias |Hoja de cálculo |IconL=Spreadsheet_StyleUnderline.svg |IconR=Preferences-spreadsheet.svg |IconC=Workbench_Spreadsheet.svg }}")
(Created page with "{{GuiCommand |Name=Spreadsheet SetAlias |Name/es=Hoja de cálculo Establecer Alias |MenuLocation=- |Workbenches=Hoja de cálculo |Shortcut={{KEY|Ctrl}}+{{KEY|Shift}}+{{KEY|A}} |Version=0.17 }}")
Line 12: Line 12:
{{GuiCommand
{{GuiCommand
|Name=Spreadsheet SetAlias
|Name=Spreadsheet SetAlias
|Name/es=Hoja de cálculo Establecer Alias
|MenuLocation=-
|MenuLocation=-
|Workbenches=[[Spreadsheet_Workbench|Spreadsheet]]
|Workbenches=[[Spreadsheet_Workbench/es|Hoja de cálculo]]
|Shortcut={{KEY|Ctrl}}+{{KEY|Shift}}+{{KEY|A}}
|Shortcut={{KEY|Ctrl}}+{{KEY|Shift}}+{{KEY|A}}
|Version=0.17
|Version=0.17

Revision as of 23:53, 1 March 2024

Spreadsheet SetAlias

Menu location
-
Workbenches
Hoja de cálculo
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.