Accesses to report table cell and returns the content of the cell.
ReportCell(string sBook$, string sSheet$, string sTable$, string sRowRef$, string sColRef$)
sBook
sSheet
sTable
sRowRef
sColRef
Returns the content of the report table cell
Example 1
Suppose you performed a Gauss Nonlinear Curve Fit on columns in Book1 and generated a report sheet "NLFit".
ReportCell("Book1", "FitNL1", "Summary", "R1", "a_Value") =; //returns the fitted value of parameter "A" ReportCell("Book1","FitNL1", "RegStats", "C1","FitStatus")$ = ; //returns fitting status
Example 2
If you performed One Way ANOVA on data in Book1 and generted report table "ANOVA1Way1", following formula returns the sum of squares.
ReportCell("Book1","ANOVA1Way1","ANOVAs.OvarallANOVA","Model1","SSq")