Methods, systems and computer program products for facilitating visualization of interrelationships in a spreadsheet

摘要

Methods, systems and computer program products are provided for visually indicating relationships among cells in a spreadsheet. Each of a first graphical linking element extending between cells in a first branch of a dependency tree of a root cell and a second graphical linking element extending between cells in a second branch of the dependency tree of the root cell is independently displayed and hidden.

主权项

1. A computer program product for visually indicating relationships among cells in a spreadsheet, comprising:
a computer readable memory having computer readable program code embodied therein, the computer readable program code comprising: computer readable program code configured to, when executed, independently display and hide each of a first graphical linking element extending between cells in a first branch of a dependency tree of a root cell and a second graphical linking element extending between cells in a second branch of the dependency tree of the root cell; computer readable program code configured to display level indicia on a branch cell in the first branch of the dependency tree of the root cell, wherein the level indicia indicates a level of the branch cell in the dependency tree; and computer readable program code configured to display the first graphical linking element extending between the root cell and the branch cell.