Get Precedents

SpreadJS provides extensive support for formula auditing by providing users the ability to display relationships between formulas and cells. This can be done by tracing the precedent and dependent cells in the worksheet. The following sample uses the getPrecedents method to get the precedent cellRange information object for an array of cells. In this example, click on either cell D7 or F7 to see it's precedent cells in the Formula Tree below the SpreadJS instance.