Spreadsheet SetAlias: Difference between revisions

From FreeCAD Documentation
(Usage: clarified the restrictions regarding Aliases.)
No edit summary
Line 34: Line 34:
#* Only alphanumeric characters and underscores ({{incode|A}} to {{incode|Z}}, {{incode|a}} to {{incode|z}}, {{incode|0}} to {{incode|9}} and {{incode|_}}) are allowed.
#* 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.
#* The first character must be a letter.
#* 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 single character aliases. See [[Expressions#Units|Expressions]].
#* 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]].





Revision as of 11:04, 23 April 2022

Spreadsheet SetAlias

Menu location
-
Workbenches
Spreadsheet
Default shortcut
None
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.
    • 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.