Patent ID: 8095867

Claim:
A system including at least one processor and a computer readable storage medium, the computer readable storage medium having program code stored thereon for providing an electronic multidimensional spreadsheet comprising a plurality of cells identified by a cell address along each dimension of the spreadsheet, said program code including program code for copying and pasting displayed elements from a source range of cells onto a destination range of cells, an element comprising at least one cell along a spreadsheet dimension, the program code for copying and pasting comprising: program code for detecting a command for copying at least one displayed element from a selected source range of cells onto a selected destination range of cells, wherein each element of the selected range of cells is associated with a corresponding display focus level that is one of a set of display focus levels arranged as a list of ordered levels, wherein the set of focus levels reflects a user defined display hierarchy, wherein the association between the element of the selected range of cells and the corresponding display focus level depends on cell content within the element and a cell content criteria associated with the display focus level; program code for identifying the selected source range of cells; program code for identifying the at least one displayed element in the selected source range of cells; program code for identifying at least one hidden element in the selected source range of cells; program code for copying the displayed element and hidden element onto a temporary range of cells, wherein the copying further comprises for each element of the temporary range of cells copied from a displayed element of the source range of cells and for each cell of the copied element: maintaining unchanged, in the cell, each reference to a range of cells not comprising any cell in the element of the temporary range of cells copied from the hidden element of the selected source range of cells or in the hidden element of the selected source range of cells, replacing, in the cell, each reference to a cell by the value of the cell in the selected source range of cells, when the cell is in an element of the temporary range of cells copied from a hidden element of the selected source range of cells or in a hidden element of the selected source range of cells, and deleting each element in the temporary range of cells copied from the hidden element in the selected source range of cells; and program code for copying the temporary range of cells onto the destination range of cells.