Locking spreadsheet cells

摘要

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.

主权项

1. A computer program product embodied in a non-transitory computer readable storage medium and comprising computer instructions for:
providing with respect to each of a plurality of groups of cells in a single sheet of a spreadsheet application an option to lock one or more cells associated with each group, wherein the option provided with respect to each group permits cells of each group to be locked independently of cells of other groups of the plurality of groups; receiving an input configured to lock one or more cells of a first group of cells of the plurality of groups of cells; and locking the cells of the first group of cells when the locked cells of the first group of cells are scrolled out of view of a display and when at least a portion of the first group of cells is in view of the display, wherein locking the cells of the first group of cells comprises applying a visual effect to the locked cells when actual relative positions of the locked cells of the first group of cells have scrolled out of view of the display; rendering locked cells of the first group of cells as floating cells when actual relative positions of the locked cells of the first group of cells have scrolled out of view of the display; and temporarily hiding the floating cells when the first group of cells is being transferred from a first position relative to the single sheet to a second position relative to the single sheet, wherein the first position is spatially different from the second position with respect to cells in the single sheet, and wherein the floating cells reappear after the first group of cells are transferred.