How to display placeholder characters when cell content exceeds cell width?
If the content of a grid cell exceeds the cell width, then characters can be displayed as placeholders instead of actual letters or numbers, indicating that the cell contains more content than can be shown within the cell. By default, the number sign (#) is used as the placeholder character, but you can specify custom characters. This article explains the usage of the placeholders.
Converting Alphabetic Content
In order to specify only alphabetic contents as placeholders, the AutoFit property can be set as Alphabet.
Code Snippet
C#
gridControl1[2, 1].AutoFit = AutoFitOptions.Alphabet;
VB
gridControl1(2, 1).AutoFit = AutoFitOptions.Alphabet
Converting Numeric Content
In order to specify the only numeric contents as placeholders, the AutoFit property can be set as Numeric value.
Code Snippet
C#
gridControl1[4, 3].AutoFit = AutoFitOptions.Numeric;
VB
gridControl1(4, 3).AutoFit = AutoFitOptions.Numeric
Converting Alphabetic and Numeric Content
In order to use both the contents of alpha-numeric contents as placeholders, the AutoFit property can be set to the value Both.
Code Snippet
C#
gridControl1[6, 3].AutoFit = AutoFitOptions.Both;
VB
gridControl1(6, 3).AutoFit = AutoFitOptions.Both
Not Converting Content
In order to restrict display of placeholders with any of the contents, the AutoFit property can be set to the value None. By Default, the value of AutoFit property is None.
Code Snippet
C#
gridControl1[8, 6].AutoFit = AutoFitOptions.None;
VB
gridControl1(8, 6).AutoFit = AutoFitOptions.None
Setting Custom Characters
Characters other than the number sign (#), the default, can be used to replace alphanumeric content that exceeds the size of a cell. In order to do so, the AutoFitChar property can be used to set as a desired character.
C#
gridControl1[4, 6].AutoFitChar = '$';
VB
gridControl1(4, 6).AutoFitChar = "$"
Screenshot
Sample links: