Spreadsheet SetAlias
Appearance
This is the approved revision of this page, as well as being the most recent.
|
|
| 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 (
- Creation: New Spreadsheet, Import Spreadsheet, Export Spreadsheet, Merge Cells, Split Cell, Set Alias
- Aligment: Align Left, Align Horizontal Center, Align Right, Align Top, Align Vertical Center, Align Bottom
- Style: Style Bold, Style Italic, Style Underline
- Additional: Preferences
- Getting started
- Installation: Download, Windows, Linux, Mac, Additional components, Docker, AppImage, Ubuntu Snap
- Basics: About FreeCAD, Interface, Mouse navigation, Selection methods, Object name, Preferences, Workbenches, Document structure, Properties, Help FreeCAD, Donate
- Help: Tutorials, Video tutorials
- Workbenches: Std Base, Assembly, BIM, CAM, Draft, FEM, Inspection, Material, Mesh, OpenSCAD, Part, PartDesign, Points, Reverse Engineering, Robot, Sketcher, Spreadsheet, Surface, TechDraw, Test Framework
- Hubs: User hub, Power users hub, Developer hub