Spreadsheet SetAlias

From FreeCAD Documentation
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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.