HighlightFormulas: Boolean;
HighlightFormulas: System.Boolean;
The HighlightFormulas property determines whether the table cells with formulas are highlighted.
Cells with formulas are highlighted if the True value is set for the property. The highlights is the blue triangle in the bottom left corner of a cell. The False value is set by default that means that the cells with formulas are not highlighted.
Create a form and locate the following components on the form to execute the example:
TabSheetBox with the TabSheetBox1 name.
CheckBox with the CheckBox1 name.
UiTabSheet with the UiTabSheet1 name. The UiTabSheet component is the data source for the TabSheetBox component.
Enable the link to the Tab system assembly.
Add event handler to check or uncheck:
Sub CheckBox1OnChange(Sender: Object; Args: IEventArgs);
Begin
UiTabSheet1.TabSheet.View.HighlightFormulas := CheckBox1.Checked;
End Sub CheckBox1OnChange;
After executing the example checked cells, containing formulas, are highlighted..
On the picture below the A0 and B0 cells contains simple values and the A1 and B1 cells contains A0+B0 and A0*B0 formulas. The A1 and B1 cells are highlighted:
Create a form and locate the following components on the form to execute an example:
The TabSheetBoxNet with the TabSheetBoxNet1 name.
The CheckBox with the CheckBox1 name.
UiTabSheetNet with the UiTabSheetNet1 name. The UiTabSheetNet component is the data source for the TabSheetBoxNet component.
Enable the link to the Tab system assembly:
Imports Prognoz.Platform.Interop.Tab;
Add event handler to check or uncheck:
Private Sub checkBox1_CheckedChanged(sender: System.Object; e: System.EventArgs);
Begin
UiTabSheetNet1.TabSheetUi.TabSheet.View.HighlightFormulas := CheckBox1.Checked;
End Sub;
After executing the example checked cells, containing formulas, are highlighted.
See also: