property Items.CellStrikeOut([Item as Variant], [ColIndex as Variant]) as Boolean
Retrieves or sets a value that specifies whether the cell should appear in strikeout.

 TypeDescription 
   Item as Variant A long expression that indicates the item's handle.  
   ColIndex as Variant A long expression that indicates the cell's handle or the column's index, a string expression that indicates the column's caption.  
   Boolean A boolean expression that indicates whether the cell should appear in strikeout.  

If the CellStrikeOut property is True, the cell's font is displayed with a horizontal line through it. Use ItemBold, ItemItalic, ItemUnderline or ItemStrikeOut property to apply different font attributes to the item. Use the CellItalic, CellUnderline, CellBold or CellStrikeOut property to apply different font attributes to the cell. Use the CellValueFormat property to specify an HTML caption. Use the ConditionalFormats method to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of a formula.

The following VB sample draws a horizontal line through the caption of the cell that has the focus:

With Grid1.Items
    .CellStrikeOut(.FocusItem, Grid.FocusColumnIndex) = True
End With

The following C++ sample draws a horizontal line through the caption of the cell that has the focus:

#include "Items.h"
CItems items = m_grid.GetItems();
items.SetCellStrikeOut( COleVariant( items.GetFocusItem() ), COleVariant( (long)m_grid.GetFocusColumnIndex() ), TRUE );

The following C# sample draws a horizontal line through the caption of the cell that has the focus:

axGrid1.Items.set_CellStrikeOut(axGrid1.Items.FocusItem, axGrid1.FocusColumnIndex, true);

The following VB.NET sample draws a horizontal line through the caption of the cell that has the focus:

With AxGrid1.Items
    .CellStrikeOut(.FocusItem, AxGrid1.FocusColumnIndex) = True
End With

The following VFP sample draws a horizontal line through the caption of the cell that has the focus:

with thisform.Grid1.Items
	.DefaultItem = .FocusItem
	.CellStrikeOut(0, thisform.Grid1.FocusColumnIndex ) = .t.
endwith

Note: The intersection of an item with a column defines a cell. Each cell is uniquely represented by its handle. The cell's handle is of HCELL type, that's equivalent with a long type. All properties of Items object that have two parameters Item and ColIndex, refer a cell.

The following lines are equivalents and each of them changes the bold font attribute of the first cell on the first item.

With Grid1
    .Items.CellBold(, .Items.ItemCell(.Items(0), 0)) = True
    .Items.CellBold(.Items(0), 0) = True
    .Items.CellBold(.Items(0)) = True
    .Items.CellBold(.Items.ItemByIndex(0)) = True
    .Items.CellBold(.Items.ItemByIndex(0), 0) = True
    .Items.CellBold(.Items(0), Grid1.Columns(0).Caption) = True
End With


Send comments on this topic.
1999-2017 Exontrol.COM, Software. All rights reserved.