Spreadsheet SetAlias
Revision as of 13:09, 28 October 2024 by LabRPS (talk | contribs) (Created page with "{{Docnav |Style Underline |Preferences |Spreadsheet |IconL=Spreadsheet_StyleUnderline.svg |IconR=Preferences-spreadsheet.svg |IconC=Workbench_Spreadsheet.svg }} {{GuiCommand |Name=Spreadsheet SetAlias |MenuLocation=- |Phenomena=Spreadsheet |Shortcut={{KEY|Ctrl}}+{{KEY|Shift}}+{{KEY|A}} }} ==Description== The {{Button|16px ...")
|
|
| Menu location |
|---|
| - |
| Phenomena |
| Spreadsheet |
| Default shortcut |
| Ctrl+Shift+A |
| Introduced in version |
| - |
| 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
- 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 (
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 LabRPS 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
- 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
- Additional: Preferences
User documentation
- Getting started
- Installation: Download, Windows, Linux, Mac, Additional components, AppImage
- Basics: About LabRPS, Interface, RPS Objects, Object name, Preferences, Workbenches, Document structure, Properties, Help LabRPS, Donate
- Help: Tutorials, Video tutorials
- Workbenches: Std Base, WindLab, SeismicLab, SeaLab, UserLab, Spreadsheet, Plot, Web
- Hubs: User hub, Power users hub, Developer hub