Posted 8 September 2017, 2:18 pm EST
How do i bind data to a check box cell type? I create the column (and checkbox celltype) at runtime
Dim chk As New CellType.CheckBoxCellType
.Columns(i).CellType = chk
.Columns(i).HorizontalAlignment = CellHorizontalAlignment.Center
then bind data into it afterwards (the column is numeric, but returns 1 or 0). What happens is that the sheet column becomes an ordinary column, with data being shown as 1.00 or 0.00.