|
|
| 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 define an alias for a cell. A cell can be referenced by its address (capital column letter + row number, e.g. B4) or by its alias.
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 (
This page is retrieved from https://wiki.freecad.org/Spreadsheet_SetAlias