Spreadsheet SetAlias

Creation: Create sheet , Import , Export , Merge cells , Split cell , Set alias
Aligment: Align left , Align center , Align right , Align top , Align vertical center , Align bottom
Style: Style bold , Style italic , Style underline

Menu location
Spreadsheet SetAlias
-
Phenomena
Spreadsheet
Default shortcut
Ctrl+Shift+A
Introduced in version
-
See also
None
Contents 1 Description 2 Usage

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 open so that the button is enabled.
Select a cell.
Press the Spreadsheet SetAlias button.
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 LabRPS 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.