Formula and Function Generation and Use in Electronic Spreadsheets

摘要

Spreadsheet formula and function creation and use with electronic computing devices are provided. When a user moves content (e.g., a spreadsheet cell) into a spreadsheet formula/function bar, a cell reference for the content may automatically be created and disposed in the formula/function bar, and if a user enters a math operation in a spreadsheet cell, corresponding operation sentence structure (syntax) may be automatically inserted into the formula/function bar. One or more formulas or functions may be automatically suggested as a user begins entering a formula/function. An always visible formula/function guide may be presented or displayed to provide helpful information on arguments/components of a formula/function, and help resources may be provided in a help resources interface with respect to application functionality and spreadsheet formulas/functions.

主权项

1. A method of generating a spreadsheet function, comprising:
receiving an electronic spreadsheet document; displaying a first content item in the electronic spreadsheet document; receiving a selection on the first content item, followed by a movement of a representation of the first content item to a formula bar associated with the electronic spreadsheet document; displaying a cell reference in the formula bar, the cell reference being a cell reference corresponding to a location of the first content item in the electronic spreadsheet document; and automatically displaying one or more spreadsheet function syntax components in the formula bar in association with the cell reference for building a spreadsheet function for operation on the first content item.