System and method in an electronic spreadsheet for displaying and/or hiding range of cells
First Claim
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 displaying and/or hiding on a user interface, elements of a range of cells, the range of cells comprising one or a plurality of contiguous elements aligned along a given spreadsheet dimension, an element comprising one or a plurality of cells, the method comprising:
- (A) detecting a command for hiding at least one element in a selected range of cells, the command identifying the selected range of cells and identifying a display focus level selected among a plurality of ordered display focus levels defined for the selected range of cells;
(B) identifying the selected range of cells comprising the element;
(C) identifying the selected display focus level;
(D) identifying a focus manager table, a horizontal level range table, a vertical level range table, a horizontal range table, and a vertical range table, the identified tables associated with the selected range of cells and associating a defined display focus level with at least one cell attribute; and
(E) selectively displaying the element on the user interface based on a relationship of the selected display focus level with the display focus level associated with the element.
3 Assignments
0 Petitions
Accused Products
Abstract
The present invention is directed to a method, system and program for displaying and/or hiding, in an electronic multi-dimensional spreadsheet on a user interface, elements of a range of cells, a range of cells including one or more contiguous elements aligned along a given spreadsheet dimension, an element of a range of cells including one or more cells along one or more of the spreadsheet dimensions.
-
Citations
24 Claims
-
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 displaying and/or hiding on a user interface, elements of a range of cells, the range of cells comprising one or a plurality of contiguous elements aligned along a given spreadsheet dimension, an element comprising one or a plurality of cells, the method comprising:
-
(A) detecting a command for hiding at least one element in a selected range of cells, the command identifying the selected range of cells and identifying a display focus level selected among a plurality of ordered display focus levels defined for the selected range of cells; (B) identifying the selected range of cells comprising the element; (C) identifying the selected display focus level; (D) identifying a focus manager table, a horizontal level range table, a vertical level range table, a horizontal range table, and a vertical range table, the identified tables associated with the selected range of cells and associating a defined display focus level with at least one cell attribute; and (E) selectively displaying the element on the user interface based on a relationship of the selected display focus level with the display focus level associated with the element. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A computer program product for use with a computer system capable of displaying an electronic multidimensional spreadsheet with a user interface, the computer program product comprising a computer useable medium having embodied therein program code comprising:
-
(A) program code for detecting a command for hiding at least one element in a selected range of cells, the command identifying the selected range of cells and identifying a display focus level selected among a plurality of ordered display focus levels defined for the selected range of cells; (B) program code for identifying the selected range of cells comprising the element; (C) program code for identifying the selected display focus level; (D) program code for identifying a focus manager table, a horizontal level range table, a vertical level range table, a horizontal range table, and a vertical range table, the identified tables associated with the selected range of cells, and associating a defined display focus level with at least one cell attribute; and (E) program code for selectively displaying the element on the user interface based on a relationship of the selected display focus level with the display focus level associated with the element. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16)
-
-
17. An apparatus including a memory for use with a computer system capable of displaying an electronic multidimensional spreadsheet on a user interface, the apparatus comprising:
-
A) program logic for detecting a command for hiding at least one element in a selected range of cells, the command identifying the selected range of cells and identifying a display focus level selected among a plurality of ordered display focus levels defined for the selected range of cells; (B) program logic for identifying the selected range of cells comprising the element; (C) program logic for identifying the selected display focus level; (D) program logic for identifying a focus manager table, a horizontal level range manager table a horizontal level range table, a vertical range table, and a vertical range table, the identified table tables associated with the selected range of cells and associating a defined display focus level with at least one cell attribute; and (E) program logic for selectively displaying the element on the user interface based on a relationship of the selected display focus level with the display focus level associated with the element. - View Dependent Claims (18, 19, 20, 21, 22, 23, 24)
-
Specification