Auto-completion of names

摘要

Automatically completing a remainder portion of a name as it is being entered is disclosed. In some embodiments, in response to receiving at least a prescribed number of starting characters of a name being entered into a first cell as a reference name to refer to one or more other cells, a set of one or more valid reference names that begin with the received starting characters is determined and provided as auto-completion options. In such cases, a valid reference name is one that identifies using a supported syntax a spreadsheet document or a portion of a spreadsheet document.

主权项

1. A method for automatically completing a remainder portion of a name as it is being entered, comprising:
receiving, at processing circuitry configured to execute instructions stored on a memory, at least a prescribed number of starting characters of a name being entered into a first cell, wherein:
the first cell is disposed in a document;the document includes a first table having a first table name and a second table having a second table name;the first table includes a first row or column having a first row or column name and the second table includes a second row or column having a second row or column name;the first row or column name and the second row or column name are the same; andthe starting characters of the name being entered into the first cell include a string of characters found in the first row or column name and the second row or column name; using the processing circuitry to determine a set of valid reference names that include the starting characters of the name being entered into the first cell, wherein:
a first valid reference name of the set of valid reference names comprises the first row or column name;a second valid reference name of the set of valid reference names comprises the second row or column name; andthe first valid reference name comprises the first table name or the second valid reference name comprises the second table name; and providing with the processing circuitry the set of valid reference names as selectable auto-completion options to enable selection between the first valid reference name and the second valid reference name.