Patent ID: 7451397

Claim:
A computer-implemented method for automatically completing formulaic cell data, comprising: substantiating an autocomplete process in response to receiving a character associated with formulaic cell data; determining whether the character is a trigger; displaying a list of autocomplete options associated with a component implicated by the trigger when the character is a trigger, wherein the displayed list of autocomplete options associated with the component includes: displaying, in the first scrollable window a plurality of possible options for automatically completing the formulaic cell data in association with the component, determining at least one component category for each of the plurality of possible options, displaying, adjacent to each of the plurality of possible options, an icon, wherein the icon displayed adjacent to each of the plurality of possible options indicates the at least one component category for each of the plurality of possible options, the at least one component category comprising at least one of: spreadsheet function dependencies, defined name dependencies, a list, pivot dependencies, user-defined function dependencies, enumerated argument dependencies, sheet data object dependencies, and date object dependencies, and filtering the plurality of possible options dynamically as additional characters are received; and displaying a list of autocomplete options associated with the character when the character is not a trigger, wherein the displayed list of autocomplete options associated with the character includes displaying a plurality of possible options for automatically completing the formulaic cell data in association with the character, wherein the displayed plurality of options are dynamically filtered as additional characters are received.