Gets or sets how to trim characters that do not fit in the cell.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property StringTrim As StringTrimming |
Property Value
StringTrimming setting that determines now strings are trimmed
Example
This example creates a cell of this type, sets properties of this cell type, and assigns this cell type to a cell.
| C# |  Copy Code |
|---|
FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType mcb = new FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType();
mcb.BackgroundImage = null;
mcb.DataSourceList = ds;
mcb.DataColumn = 2;
mcb.ColumnEdit = 2;
mcb.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.AllArrows;
mcb.ButtonAlign = FarPoint.Win.ButtonAlign.Left;
mcb.ListAlignment = FarPoint.Win.ListAlignment.Right;
mcb.ListWidth = 500;
mcb.ListOffset = 5;
mcb.MaxDrop = 5;
mcb.StringTrim = StringTrimming.EllipsisCharacter;
mcb.SubEditor = null;
fpSpread1.ActiveSheet.Cells[0, 0].CellType = mcb;
|
| Visual Basic | Copy Code |
|---|
Dim mcb As New FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType()
mcb.BackgroundImage = Nothing
mcb.DataSourceList = ds
mcb.DataColumn = 2
mcb.ColumnEdit = 2
mcb.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.AllArrows
mcb.ButtonAlign = FarPoint.Win.ButtonAlign.Left
mcb.ListAlignment = FarPoint.Win.ListAlignment.Right
mcb.ListWidth = 500
mcb.ListOffset = 5
mcb.MaxDrop = 5
mcb.StringTrim = StringTrimming.EllipsisCharacter
mcb.SubEditor = Nothing
FpSpread1.ActiveSheet.Cells(0, 0).CellType = mcb |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also
