Posted 8 September 2017, 12:39 pm ESTHi
just started to use fpSpread in .NET. Before we used in VB6 as COM and everything was OK.
Now I wanted to bind the spread to a datasource to have less to code to write when working with db table.
so, I have such a code
fpSprInv_Sheet1.AutoGenerateColumns = false;
fpSprInv_Sheet1.DataSource = m_jobsInfoDS.vJobInvoices;
FarPoint.Win.Spread.CellType.CheckBoxCellType chkType = new FarPoint.Win.Spread.CellType.CheckBoxCellType();
fpSprInv_Sheet1.Columns.CellType = chkType;
fpSprInv_Sheet1.Columns.Label = "View/Print";
fpSprInv_Sheet1.Columns.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center;
fpSprInv_Sheet1.Columns.DataField = "SpecifiedInvoiceID";
fpSprInv_Sheet1.Columns.Label = "Invoice No.";
fpSprInv_Sheet1.Columns.DataField = "InvoiceDesc";
fpSprInv_Sheet1.Columns.Label = "Description";
The DB columns are:
everything works fine, I can see data in the spread, can edit data but ONLY in first 2 columns. Somehow the column 3 (InvoiceDesc) gets blocked, so I can't enter to edit mode.
Any idea why this happens?
Using: VS 2005