Pre-formulated spreadsheet cell groups
A computer-readable medium having computer-executable modules includes a computer spreadsheet application including a series of cells arranged in addressable rows and columns, and at least one set of linked cells having an embedded function and position relative to other cells in the series of cells, the embedded function being linked to at least one other cell in the series of cells.
1. A computer-readable storage medium having computer-executable modules comprising:
(a) a computer spreadsheet application that generates a spreadsheet document, the spreadsheet document including a series of cells arranged in addressable rows and columns; and
(b) at least one set of pre-formulated linked cells having an embedded function and position relative to other cells in the series of cells, the embedded function being linked to at least one other cell in the series of cells, the pre-formulated linked cells having the embedded function before being inserted into a document, each set of pre-formulated linked cells configured to be added to a spreadsheet document.
2. The computer readable storage medium of claim 1 wherein said at least one set of linked cells includes data entry control.
3. The computer readable storage medium of claim 1 further including at least a second set of linked cells having an embedded function and position relative to other cells in the series of cells.
4. The computer readable storage medium of claim 3 wherein said at least second set of linked cells includes an embedded function linked to the at least one set of linked cells.
5. The computer readable storage medium of claim 3 wherein said at least second set of linked cells includes positioning information relative to said at least one set of linked cells.
6. The computer readable storage medium of claim 3 wherein said at least one set and said at least second set of linked cells are protected preventing alteration of the embedded formula.
7. The computer readable storage medium of claim 3 wherein said at least second set of linked cells is protected from deletion based when said embedded formula of said second set is linked to said at least one set of linked cells.
8. The computer readable storage medium of claim 3 wherein said at least second set of linked cells includes context information about said first set of linked cells.
9. The computer readable storage medium of claim 1 wherein said at least one set of linked cells includes formatting information.
10. The computer readable storage medium of claim 1 wherein said at least one set of linked cells includes a defined data set.
11. The computer readable storage medium of claim 10 wherein said defined data set includes a series of selectable data elements.
12. A computer readable storage medium having a data structure stored thereon comprising:
(a) a first group of pre-formatted cells including at least one data or functional component linked to other components in the first group; and
(b) a second group of pre-formatted cells including at least one data or functional component linked to other components in the first group,
the pre-formatted cells including the linked components before being inserted in a spreadsheet by a user,
each group of pre-formatted cells comprising at least one entire column of cells.
13. The computer readable storage medium of claim 12 wherein said second group of linked cells includes an embedded function linked to said first group of linked cells.
14. The computer readable storage medium of claim 12 wherein said second group of linked cells includes positioning information relative to said first group of linked cells.
15. The computer readable storage medium of claim 12 wherein said at least one set first group and said second group of linked cells are protected from alteration of the functional or data component.
16. The computer readable storage medium of claim 12 wherein said at least second group is protected from deletion based on a link between the functional component and the first group.
17. The computer readable storage medium of claim 12 wherein said at least first group of pre-formatted cells includes formatting information.
18. A computer readable storage medium having computer-executable instructions for performing steps comprising:
(a) displaying a worksheet having a plurality of cells arranged in rows and columns;
(b) displaying a selection interface to a user allowing the user to select a functionally linked group of cells; and
(c) responsive to a selection of one of said groups, determining a position for said functionally linked group in the worksheet and inserting the functionally linked group of cells at a predetermined position in the worksheet.
19. The computer readable storage medium of claim 18 wherein said step (c) includes selecting a preferred position relative to at least one additional functionally linked group of cells.
20. The computer readable storage medium of claim 19 wherein said step (c) includes adjusting the column width of said functionally linked group of cells prior to insertion in the worksheet.