System and method in an electronic spreadsheet for copying and pasting displayed elements of a range of cells

Abstract

The present invention is directed to a method, system and computer program for copying and pasting, in an electronic multidimensional spreadsheet, displayed elements of a source range of cells onto a destination range of cells, the source range of cells including one or more elements displayed on a user interface and one or more hidden elements, the elements being contiguous and aligned along a given spreadsheet dimension. The method includes (A) detecting a command for copying at least one displayed element from a selected source range of cells onto a selected destination range of cells; (B) identifying the selected source range of cells; (C) identifying the at least one displayed element in the selected source range of cells; (D) identifying at least one hidden element in the selected source range of cells; (E) copying the displayed element and hidden element onto a temporary range of cells; and (F) copying the temporary range of cells onto the destination range of cells.

1 . In an electronic multidimensional spreadsheet comprising a plurality of cells identified by a cell address along each dimension of the spreadsheet, a method 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 method comprising:
 (A) 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;   (B) identifying the selected source range of cells;   (C) identifying the at least one displayed element in the selected source range of cells;   (D) identifying at least one hidden element in the selected source range of cells;   (E) copying the displayed element and hidden element onto a temporary range of cells; and   (F) copying the temporary range of cells onto the destination range of cells.   
   
   
       2 . The method according to  claim 1  wherein (E) 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:
 (E1) 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; and   (E2) 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   (E3) deleting each element in the temporary range of cells copied from the hidden element in the selected source range of cells.   
   
   
       3 . The method according to  claim 1  wherein (E1) further comprises:
 (E1a) replacing, in the cell, each function comprising at least a reference to a range of cells, by the value of the function in the selected source range of cells, when the range of cells comprises at least a cell 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.   
   
   
       4 . The method according to  claim 1  wherein the command comprises:
 (i) means for identifying the selected source range of cells;   (ii) means for identifying the at least one displayed element; and   (iii) means for identifying the at least one hidden element.   
   
   
       5 . The method according  claim 1  further comprising:
 (G) defining at least one ranges of cells;   (H) for each range of cells:
 (i) defining a plurality of display focus levels and ordering the display focus levels; 
 (ii) defining elements; and 
 (iii) associating each element with a display focus level. 
   
   
   
       6 . The method according  claim 1  further comprising:
 (G) detecting a command for hiding the at least one element in a selected range of cells, the command comprising means for identifying the selected range of cells and means for identifying a display focus level selected among a plurality of ordered display focus levels;   (H) identifying a table associated with the selected range of cells, the table associating each element in the selected range with a display focus level;   (I) selectively displaying the element on the user interface based on the relationship of the selected display focus level with the display focus level associated with the element.   
   
   
       7 . The method according to  claim 6  wherein (I) further comprises:
 (I1) hiding the at least one element on the user interface where the associated display focus level is lower than the selected display focus level.   
   
   
       8 . The method according to  claim 6  wherein (I) further comprises:
 (I2) displaying the at least one element on the user interface where the associated display focus level is at least equal or higher than the selected display focus level.   
   
   
       9 . The method according to  claim 1  wherein an element of a range of cells comprises one of a row, column and sheet. 
   
   
       10 . 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; and   program code for copying the temporary range of cells onto the destination range of cells.   
   
   
       11 . The system according to  claim 10  wherein the program code for copying the displayed element and hidden element onto a temporary range of cells further comprises program code for, 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; and   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.   
   
   
       12 . The system according to  claim 10  wherein the program code for 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 further comprises:
 program code for replacing, in the cell, each function comprising at least a reference to a range of cells, by the value of the function in the selected source range of cells, when the range of cells comprises at least a cell 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.   
   
   
       13 . The system according to  claim 10  wherein the command comprises:
 means for identifying the selected source range of cells;   means for identifying the at least one displayed element; and   means for identifying the at least one hidden element.   
   
   
       14 . The system according  claim 10 , the program code for copying and pasting further comprising:
 program code for defining at least one range of cells;   program code for, for each range of cells:
 defining a plurality of display focus levels and ordering the display focus levels; 
 defining elements; and 
 associating each element with a display focus level. 
   
   
   
       15 . The system according  claim 10 , the program code for copying and pasting further comprising:
 program code for detecting a command for hiding the at least one element in a selected range of cells, the command comprising means for identifying the selected range of cells and means for identifying a display focus level selected among a plurality of ordered display focus levels;   program code for identifying a table associated with the selected range of cells, the table associating each element in the selected range with a display focus level;   program code for selectively displaying the element on the user interface based on the relationship of the selected display focus level with the display focus level associated with the element.   
   
   
       16 . The system according to  claim 10  wherein the program code for selectively displaying the element on the user interface based on the relationship of the selected display focus level with the display focus level associated with the element further comprises:
 program code for hiding the at least one element on the user interface where the associated display focus level is lower than the selected display focus level.   
   
   
       17 . The system according to  claim 15  wherein the program code for selectively displaying the element on the user interface based on the relationship of the selected display focus level with the display focus level associated with the element further comprises:
 program code for displaying the at least one element on the user interface where the associated display focus level is at least equal or higher than the selected display focus level.   
   
   
       18 . The method according to  claim 10  wherein an element of a range of cells comprises one of a row, column and sheet. 
   
   
       19 . A computer program product including 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; and   program code for copying the temporary range of cells onto the destination range of cells.   
   
   
       20 . A system for providing an electronic multidimensional spreadsheet comprising a plurality of cells identified by a cell address along each dimension of the spreadsheet, and 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, comprising:
 means 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;   means for identifying the selected source range of cells;   means for identifying the at least one displayed element in the selected source range of cells;   means for identifying at least one hidden element in the selected source range of cells;   means for copying the displayed element and hidden element onto a temporary range of cells; and   means for copying the temporary range of cells onto the destination range of cells.