https://wiki.labrps.com/index.php?action=history&feed=atom&title=Spreadsheet_SetAlias 2026-05-07T15:07:38Z Revision history for this page on the wiki MediaWiki 1.38.2 https://wiki.labrps.com/index.php?title=Spreadsheet_SetAlias&diff=2103&oldid=prev 2024-10-28T21:09:01Z

<p>Created page with &quot;{{Docnav |<a href="/Spreadsheet_StyleUnderline" title="Spreadsheet StyleUnderline">Style Underline</a> |<a href="/Spreadsheet_Preferences" title="Spreadsheet Preferences">Preferences</a> |<a href="/Spreadsheet_Workbench" title="Spreadsheet Workbench">Spreadsheet</a> |IconL=Spreadsheet_StyleUnderline.svg |IconR=Preferences-spreadsheet.svg |IconC=Workbench_Spreadsheet.svg }} {{GuiCommand |Name=Spreadsheet SetAlias |MenuLocation=- |Phenomena=<a href="/Spreadsheet_Workbench" title="Spreadsheet Workbench">Spreadsheet</a> |Shortcut={{KEY|Ctrl}}+{{KEY|Shift}}+{{KEY|A}} }} ==Description== The {{Button|<a href="/File:Spreadsheet_SetAlias.svg" title="File:Spreadsheet SetAlias.svg">16px</a> ...&quot;</p> <p><b>New page</b></p><div>{{Docnav<br /> |[[Spreadsheet_StyleUnderline|Style Underline]]<br /> |[[Spreadsheet_Preferences|Preferences]]<br /> |[[Spreadsheet_Workbench|Spreadsheet]]<br /> |IconL=Spreadsheet_StyleUnderline.svg<br /> |IconR=Preferences-spreadsheet.svg<br /> |IconC=Workbench_Spreadsheet.svg<br /> }}<br /> <br /> {{GuiCommand<br /> |Name=Spreadsheet SetAlias<br /> |MenuLocation=-<br /> |Phenomena=[[Spreadsheet_Workbench|Spreadsheet]]<br /> |Shortcut={{KEY|Ctrl}}+{{KEY|Shift}}+{{KEY|A}}<br /> }}<br /> <br /> ==Description== <br /> <br /> The {{Button|[[File:Spreadsheet_SetAlias.svg|16px]] [[Spreadsheet_SetAlias|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.<br /> <br /> ==Usage== <br /> <br /> # Make sure there is an active {{Button|[[File:Spreadsheet_CreateSheet.svg|16px]] [[Spreadsheet_CreateSheet|Spreadsheet]]}} open so that the button is enabled.<br /> # Select a cell.<br /> # Press the {{Button|[[File:Spreadsheet_SetAlias.svg|16px]] [[Spreadsheet_SetAlias|Spreadsheet SetAlias]]}} button.<br /> # Enter an alias:<br /> #* Only alphanumeric characters and underscores ({{incode|A}} to {{incode|Z}}, {{incode|a}} to {{incode|z}}, {{incode|0}} to {{incode|9}} and {{incode|_}}) are allowed.<br /> #* The first character must be a letter.<br /> #* Using 1 or 2 capital letters followed by 1 to 5 numbers, for example {{incode|AB123}}, is not allowed as this is considered a cell address.<br /> #* Character sequences that are units are not allowed. For example {{incode|W}} is an invalid alias as it is the unit for [https://en.wikipedia.org/wiki/Watt Watt]. Since LabRPS supports many units it is best to avoid short aliases. See [[Expressions#Units|Expressions]].<br /> #* Using the mathematical constants {{incode|pi}} and {{incode|e}} as aliases will lead to errors and should be avoided.<br /> #* Do not use spaces in aliases as they will also lead to errors.<br /> <br /> <br /> {{Docnav<br /> |[[Spreadsheet_StyleUnderline|Style Underline]]<br /> |[[Spreadsheet_Preferences|Preferences]]<br /> |[[Spreadsheet_Workbench|Spreadsheet]]<br /> |IconL=Spreadsheet_StyleUnderline.svg<br /> |IconR=Preferences-spreadsheet.svg<br /> |IconC=Workbench_Spreadsheet.svg<br /> }}<br /> <br /> {{Spreadsheet_Tools_navi}}<br /> {{Userdocnavi}}</div>

LabRPS