Abstract: In one embodiment, the present invention includes irrigation control software for a computer that interacts with the features of a plurality of advanced sprinklers, environmental sensors, and other available data. The irrigation control software provides a graphical user interface to create a more efficient irrigation scheduling control interface.

Abstract: In some embodiments, an option to lock one or more associated cells is provided with respect to each different group of cells in a single sheet of a spreadsheet application. One or more locked cells of a group of cells do not scroll out of view at least while a portion of the group of cells is viewable in a given display view.

Abstract: A token representation of references and function arguments is disclosed. In some embodiments, an indication that a formula is being entered into a cell is received, and references and/or function arguments in the formula, if any, are represented as tokens. Each token comprises an atomic user interface object. In various embodiments, references are rendered as reference tokens and function arguments are rendered as argument tokens and/or mode tokens.

Abstract: Defining custom cell formats is disclosed. In some embodiments, in response to receiving an indication of a selection of an option to define a custom cell format, a user interface to define the custom cell format is provided, wherein a format element in a definition of the custom cell format in the user interface is represented as a format element token.

Abstract: Natural language based filtering is disclosed. In some embodiments, a user interface for defining one or more filters for a group of data allows one or more parameters associated with a filter definition, including a filter condition, to at least in part be specified in natural language. In some embodiments, a filter definition is specified at least in part by selecting one or more of a plurality of pre-configured natural language expressions made available for selection via the user interface.

Abstract: In some embodiments, a spreadsheet application provides an option for collectively displaying the formulas associated with a set of cells in a separate view. In some embodiments, the view provides an option to search within the formulas (and/or other content) provided by the view. In some embodiments, a find and replace user interface of a spreadsheet application includes an option to search only in formulas.

Abstract: In one embodiment, the present invention includes irrigation control software for a computer that interacts with the features of a plurality of advanced sprinklers, environmental sensors, and other available data. The irrigation control software provides a graphical user interface to create a more efficient irrigation scheduling control interface.

Abstract: Grouping a set of data is disclosed. In some embodiments, a set of data is grouped with respect to a column and/or a row associated with the set of data in response to receiving a selection of an option to group the set of data with respect to the column and/or the row. In some embodiments, the grouping of the set of data is based on real time values of the set of data and is automatically and dynamically updated in response to changes in the set of data.

Abstract: Referring to cells using header cell values is disclosed. In some embodiments, a header cell value of a header cell is allowed to be used to refer to one or more other cells that are associated with the header cell. The header cell may be included in a header row or column included in a table. A header row cell value may be employed to refer to one or more other cells in a corresponding column, and a header column cell value may be employed to refer to one or more other cells in a corresponding row.

Abstract: Reference adding behavior in a formula editing mode is disclosed. In some embodiments, in response to receiving an indication of a selection of a cell, a reference to the selected cell is inserted into a formula being entered into a host cell if the host cell is not a header cell, and a reference to a row or column with which the selected cell is associated is inserted into a formula being entered into a host cell if the host cell is a header cell.

Abstract: Automatically populating and/or generating tables using data extracted from files is disclosed. In some embodiments, in response to receiving an indication that at least a portion of a data object is desired to be included in a table, a set of one or more data values associated with the data object is selected for inclusion in the table and automatically included as an entry corresponding to the data object in the table. In various embodiments, the table may comprise an existing table and/or a newly generated table.

Abstract: Cutting and copying discontiguous selections of cells is disclosed. In some embodiments, in response to receiving an indication of a selection of a set of cells that does not include only a continuous grid of selected cells and receiving an indication of a selection of a paste destination in which the set of cells is desired to be pasted, the set of cells is pasted in the paste destination in a manner that preserves a respective relative position of each cell in the set. In some embodiments, if a paste destination is not large enough to accommodate a paste operation, the paste destination is automatically expanding so that it is large enough to accommodate the paste operation.

Abstract: Associating an object with a relevant data source is disclosed. In some embodiments, an object pasted into a destination document is associated with a data source included in the destination document. In various embodiments, the data source associated with the object may comprise a data source concurrently pasted with the object into the destination document, a data source already existing in the destination document prior to the object being pasted into the destination document, or a data source generated in the destination document using data extracted from the pasted object.

Abstract: Automatically inserting a default function into a host cell is disclosed. In some embodiments, in response to receiving an indication of a selection and/or a specification of a set of one or more cells while in a formula editing mode, a default function is automatically inserted into a host cell into which a formula is being entered with the set of one or more cells as its arguments.