US6460059B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Visual aid to simplify achieving correct cell interrelations in spreadsheets
Assignee: LinkedIn Corp
•
Filing: 1998-08-04
•
Granted: 2002-10-01
•
Expires: 2018-08-04
Abstract
Abstract A method and apparatus for displaying a spreadsheet on a display device in a computer system to facilitate easy recognition of errors. More specifically, with this invention one cell is selected, and there is a visual indication of such selection. Further, there is also a visual indication of those cells having data that either affects or depends upon the data in the selected cell. There is also a different visual indication for each level of dependency relative to the selected cell. For example, selected cell A may be immediately dependent upon cells B and C, where cell B may in turn be dependent upon cells D, E and F. Cells B and C are at the first level of dependency while cells D, E and F are at the second level of dependency. Thus, cells B and C may have a different marking or shading than cells D, E and F. The number of dependency levels to be displayed can be chosen by the user. The number of paths of cells to be displayed from a selected cell to a leaf cell can also be chosen by the user. This invention also provides for the simultaneous display of formulas in all cells.
Inventors
- 👤 Robert William Wisniewski
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-08 13:56
CPC Classifications
G; G06; G06F; G06F40/00; G06F40/10; G06F40/166; G06F40/177; G06F40/18
Claims Analysis
Total Claims: 14
Claim 1
Independent Claim
203 words
In a computer system having a display device, a method of detecting and displaying on said display device dependencies of cells in a spreadsheet having a plurality of cells, said method comprising: receiving user input of a selected cell, and the dependencies, dependency levels, and branching factors for display; automatically detecting dependencies among cells; and automatically generating a display of the dynamically detected dependencies among cells by the steps of: visually marking a first group of said cells with at least one first marking, wherein each cell of said first group has data therein which is used to determine data that is in a selected cell; and simultaneously visually marking at least one second group of said cells with at least one second marking, wherein each of said at least one second marking is visually distinguishable from each of said at least one first marking, and wherein each cell of said second group has data therein which is determined by said data in said selected cell and wherein said at least one second marking comprises a plurality of second markings which are visually distinguishable from each other and which represent at least one of different dependency levels and branchings from said selected cells.
Claim 2
Dependent Claim
203 words
In a computer system having a display device, a method of detecting and displaying on said display device dependencies of cells in a spreadsheet having a plurality of cells, said method comprising: receiving user input of a selected cell, and the dependencies, dependency levels, and branching factors for display; automatically detecting dependencies among cells; and automatically generating a display of the dynamically detected dependencies among cells by the steps of: visually marking a first group of said cells with at least one first marking, wherein each cell of said first group has data therein which is used to determine data that is in a selected cell; and simultaneously visually marking at least one second group of said cells with at least one second marking, wherein each of said at least one second marking is visually distinguishable from each of said at least one first marking, and wherein each cell of said second group has data therein which is determined by said data in said selected cell and wherein said at least one second marking comprises a plurality of second markings which are visually distinguishable from each other and which represent at least one of different dependency levels and branchings from said selected cells.
Claim 3
Dependent Claim
71 words
A method as recited in claim 1 , wherein each group of cells is divided into a hierarchy of levels, wherein data in each cell in each level of said hierarchy is used to directly determine, or is directly determined by, data in a cell of a next higher level of said hierarchy, and wherein each cell in each level is visually marked to indicate that it belongs to said level.
Claim 4
Dependent Claim
47 words
A method as recited in claim 1 , wherein each group comprises at least one path from said selected cell to a leaf cell in said each group, wherein each leaf cell is a cell in each said path which is furthest away from said selected cell.
Claim 5
Dependent Claim
22 words
A method as recited in claim 3 , wherein a number of paths displayed is selectable by a user of said system.
Claim 6
Dependent Claim
216 words
A program storage device readable by a machine, tangibly embodying a program of instructions executable by said machine to perform method steps for detecting and displaying on a display device dependencies of cells in a spreadsheet having a plurality of cells, said method steps comprising: receiving user input of a selected cell, and the dependencies, dependency levels, and branching factors for display; automatically detecting dependencies among cells; and automatically generating a display of the dynamically detected dependencies among cells by the steps of: visually marking a first group of said cells with at least one first marking, wherein each cell of said first group has data therein which is used to determine data that is in a selected cell; and simultaneously visually marking at least one second group of said cells with at least one second marking, wherein each of said at least one second marking is visually distinguishable from each of said at least one first marking, and wherein each cell of said second group has data therein which is determined by said data in said selected cell and wherein said at least one second marking comprises a plurality of second markings which are visually distinguishable from each other and which represent at least one of different dependency levels and branchings from said selected cells.
Claim 7
Dependent Claim
216 words
A program storage device readable by a machine, tangibly embodying a program of instructions executable by said machine to perform method steps for detecting and displaying on a display device dependencies of cells in a spreadsheet having a plurality of cells, said method steps comprising: receiving user input of a selected cell, and the dependencies, dependency levels, and branching factors for display; automatically detecting dependencies among cells; and automatically generating a display of the dynamically detected dependencies among cells by the steps of: visually marking a first group of said cells with at least one first marking, wherein each cell of said first group has data therein which is used to determine data that is in a selected cell; and simultaneously visually marking at least one second group of said cells with at least one second marking, wherein each of said at least one second marking is visually distinguishable from each of said at least one first marking, and wherein each cell of said second group has data therein which is determined by said data in said selected cell and wherein said at least one second marking comprises a plurality of second markings which are visually distinguishable from each other and which represent at least one of different dependency levels and branchings from said selected cells.
Claim 8
Dependent Claim
203 words
In a computer system having a display device, a method of detecting and displaying on said display device dependencies of cells in a spreadsheet having a plurality of cells, said method comprising: receiving user input of a selected cell, and the dependencies, dependency levels, and branching factors for display; automatically detecting dependencies among cells; and automatically generating a display of the dynamically detected dependencies among cells by the steps of: visually marking a first group of said cells with at least one first marking, wherein each cell of said first group has data therein which is used to determine data that is in a selected cell; and simultaneously visually marking at least one second group of said cells with at least one second marking, wherein each of said at least one second marking is visually distinguishable from each of said at least one first marking, and wherein each cell of said second group has data therein which is determined by said data in said selected cell and wherein said at least one second marking comprises a plurality of second markings which are visually distinguishable from each other and which represent at least one of different dependency levels and branchings from said selected cells.
Claim 9
Dependent Claim
203 words
In a computer system having a display device, a method of detecting and displaying on said display device dependencies of cells in a spreadsheet having a plurality of cells, said method comprising: receiving user input of a selected cell, and the dependencies, dependency levels, and branching factors for display; automatically detecting dependencies among cells; and automatically generating a display of the dynamically detected dependencies among cells by the steps of: visually marking a first group of said cells with at least one first marking, wherein each cell of said first group has data therein which is used to determine data that is in a selected cell; and simultaneously visually marking at least one second group of said cells with at least one second marking, wherein each of said at least one second marking is visually distinguishable from each of said at least one first marking, and wherein each cell of said second group has data therein which is determined by said data in said selected cell and wherein said at least one second marking comprises a plurality of second markings which are visually distinguishable from each other and which represent at least one of different dependency levels and branchings from said selected cells.
Claim 10
Dependent Claim
71 words
A method as recited in claim 6 , wherein each group of cells is divided into a hierarchy of levels, wherein data in each cell in each level of said hierarchy is used to directly determine, or is directly determined by, data in a cell of a next higher level of said hierarchy, and wherein each cell in each level is visually marked to indicate that it belongs to said level.
Claim 11
Dependent Claim
47 words
A method as recited in claim 6 , wherein each group comprises at least one path from said selected cell to a leaf cell in said each group, wherein each leaf cell is a cell in each said path which is furthest away from said selected cell.
Claim 12
Dependent Claim
22 words
A method as recited in claim 6 , wherein a number of paths displayed is selectable by a user of said system.
Claim 13
Dependent Claim
216 words
A program storage device readable by a machine, tangibly embodying a program of instructions executable by said machine to perform method steps for detecting and displaying on a display device dependencies of cells in a spreadsheet having a plurality of cells, said method steps comprising: receiving user input of a selected cell, and the dependencies, dependency levels, and branching factors for display; automatically detecting dependencies among cells; and automatically generating a display of the dynamically detected dependencies among cells by the steps of: visually marking a first group of said cells with at least one first marking, wherein each cell of said first group has data therein which is used to determine data that is in a selected cell; and simultaneously visually marking at least one second group of said cells with at least one second marking, wherein each of said at least one second marking is visually distinguishable from each of said at least one first marking, and wherein each cell of said second group has data therein which is determined by said data in said selected cell and wherein said at least one second marking comprises a plurality of second markings which are visually distinguishable from each other and which represent at least one of different dependency levels and branchings from said selected cells.
Claim 14
Dependent Claim
216 words
A program storage device readable by a machine, tangibly embodying a program of instructions executable by said machine to perform method steps for detecting and displaying on a display device dependencies of cells in a spreadsheet having a plurality of cells, said method steps comprising: receiving user input of a selected cell, and the dependencies, dependency levels, and branching factors for display; automatically detecting dependencies among cells; and automatically generating a display of the dynamically detected dependencies among cells by the steps of: visually marking a first group of said cells with at least one first marking, wherein each cell of said first group has data therein which is used to determine data that is in a selected cell; and simultaneously visually marking at least one second group of said cells with at least one second marking, wherein each of said at least one second marking is visually distinguishable from each of said at least one first marking, and wherein each cell of said second group has data therein which is determined by said data in said selected cell and wherein said at least one second marking comprises a plurality of second markings which are visually distinguishable from each other and which represent at least one of different dependency levels and branchings from said selected cells.
References Cited (Backward Citations)
US5317686A
Cited
US5623591A
Cited
US5603021A
Cited
US5694608A
Cited
US5893123A
Cited
US6157934A
Cited
US6185582B1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2005-09-30 | 2006-04-01 | 2006-10-01 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2009-09-30 | 2010-04-01 | 2010-10-01 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2013-09-30 | 2014-04-01 | 2014-10-01 | $7700.00 | Window Closed / Lapsed |