IsEvaluatedCell(Row: Integer; Column: Integer): Boolean;
Row. Row index.
Column. Column index.
The IsEvaluatedCell property returns whether the cell is calculable.
Available values:
True. Calculable cell.
False. Regular cell.
Executing the example requires a form with the following components: the Button component named Button1, the TabSheetBox component named TabSheetBox1, and the UiErAnalyzer component named UiErAnalyzer1. UiErAnalyzer1 is a data source for TabSheetBox1. A workbook of the time series database should be loaded to UiErAnalyzer1.
The example is a handler of the OnClick event for the Button1 component.
Add links to the Express, ExtCtrls, Forms, Laner, and Tab system assemblies.
Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
ErAn: IEaxAnalyzer;
Laner: ILaner;
Table: ILanerTable;
i, j: Integer;
Begin
ErAn := UiErAnalyzer1.ErAnalyzer;
Laner := ErAn.Laner;
Table := Laner.Execute;
For i := 0 To Table.RowCount - 1 Do
For j := 0 To Table.ColumnCount - 1 Do
If Table.IsEvaluatedCell(i, j) Then
Debug.WriteLine("Cell ("+i.ToString+", "+j.ToString+") is calculable");
End If;
End For;
End For;
End Sub Button1OnClick;
After executing the example the console window displays the calculated cells.
See also: