GuiCommand: Name: Spreadsheet SetAlias MenuLocation: - Workbenches: Spreadsheet_Workbench Shortcut: Ctrl+Shift+A Version: 0.17
Spreadsheet SetAlias
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
- Make sure there is an active spreadsheet.
- Select a cell.
- There are several ways to invoke the tool:
- Press the [ Set alias button.
- Use the keyboard shortcut: Ctrl+Shift+A.
- Press the [
- Enter an alias:
- Only alphanumeric characters and underscores (
AtoZ,atoz,0to9and_) 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
Wis 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
piandeas aliases will lead to errors and should be avoided. - Do not use spaces in aliases as they will also lead to errors.
- Only alphanumeric characters and underscores (
{{Spreadsheet_Tools_navi}}
⏵ documentation index > Spreadsheet > Spreadsheet SetAlias
This page is retrieved from https://github.com/FreeCAD/FreeCAD-documentation/blob/main/wiki/Spreadsheet_SetAlias.md