OverflowCharacter Property (NumberCellType)

Gets or sets the character to use to replace the value if it does not fit the width of the display.

Syntax

Visual Basic
C#

'Declaration
 
Public Property OverflowCharacter As Char

'Usage
 
Dim instance As NumberCellType
Dim value As Char
 
instance.OverflowCharacter = value
 
value = instance.OverflowCharacter

public char OverflowCharacter {get; set;}

Property Value

Character containing the character for overflow

Example

This example sets the character to use to replace the value if it does not fit the width of the display of a numeric format cell.

FarPoint.Win.Spread.CellType.NumberCellType num = new FarPoint.Win.Spread.CellType.NumberCellType();
num.OverflowCharacter = Char.ToLower("x")'
fpSpread1.ActiveSheet.Cells[0, 0].CellType = num'
fpSpread1.ActiveSheet.Cells[0, 0].Value = 5123465.45;

Visual Basic

Dim num As New FarPoint.Win.Spread.CellType.NumberCellType
num.OverflowCharacter = Char.ToLower("x")
FpSpread1.ActiveSheet.Cells(0, 0).CellType = num
FpSpread1.ActiveSheet.Cells(0, 0).Value = 5123465.45

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

NumberCellType Class
NumberCellType Members