Replied 8 September 2017, 3:07 pm EST
I apologize for the delayed response.
When you call AcceptChanges on the data set, the model for the
spreadsheet is re-initialized so that any added data will stay in synch. It overrides any of the celltype settings done after assigning the datasource to Spread. To prevent the overriding of these settings, I would suggest you to set the DataAutoCellTypes property to false before calling the AcceptChanges method. This property makes sure that Spread does not automaticaly assigns the celltype to the bound columns. Here is the code snippet for the same:
private void button1_Click(object sender, EventArgs e)
fpSpread1.ActiveSheet.DataAutoCellTypes = false;
DataSet ds1 = (DataSet)fpSpread1.DataSource;
FarPoint.Win.Spread.CellType.TextCellType tct1 = (FarPoint.Win.Spread.CellType.TextCellType)fpSpread1.ActiveSheet.Columns.CellType;
So, when you initially bound Spread with datasource, it has all its columns celltype set with all the overriden settings such as Multiline property that you have done to the celltypes. Later, when you set the DataAutoCellTypes property to false and then call the AcceptChanges method, then it does not resets the celltype, so none of your celltype settings are overriden.
Hope it helps.