Skip to content

Spreadsheet_SetAlias.md

Latest commit

 

History

History
35 lines (23 loc) · 1.61 KB

Spreadsheet_SetAlias.md

File metadata and controls

35 lines (23 loc) · 1.61 KB
Raw
  • GuiCommand: Name:Spreadsheet SetAlias MenuLocation:- Workbenches:Spreadsheet 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

  1. Make sure there is an active [ Spreadsheet open so that the button is enabled.
  2. Select a cell.
  3. Press the [ Spreadsheet SetAlias button.
  4. 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 FreeCAD 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.

{{Spreadsheet_Tools_navi}}

documentation index > Spreadsheet > Spreadsheet SetAlias