Function added under Lookup & Reference to access report table cell. Using this new function will be much easier to access result cell values in Set Column Values and Labtalk Script.

Syntax

ReportCell(string sBook$, string sSheet$, string sTable$, string sRowRef$, string sColRef$)

• Active book will be used if sBook$ not specified.

Example

In report sheet, active Parameters table, select the Value cell of y0, then the status bar will show the link address like “cell://Parameters.y0.Value”. Now you can call the ReportCell function like following to access the cell.

ReportCell(, "FitNL1", "Parameters", "y0", "value")

Also, you can use it in Set Values formula.