Spread Windows Forms 11.0 Product Documentation
NegativeFormat Enumeration
Example Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace : NegativeFormat Enumeration
Specifies the display of the negative sign in the cell contents.
Syntax
'Declaration
 
Public Enum NegativeFormat 
   Inherits System.Enum
'Usage
 
Dim instance As NegativeFormat
public enum NegativeFormat : System.Enum 
Members
MemberDescription
NegativeSignAfterDisplays the negative sign (to the right) after the value, as in 1-
NegativeSignAfterWithSpaceDisplays the negative sign with a space (to the right) after the value, as in 1 -
NegativeSignBeforeDisplays the negative sign (to the left) before the value, as in -1
NegativeSignBeforeWithSpaceDisplays the negative sign with a space (to the left) before the value, as in - 1
Parentheses[0] Displays the value within parentheses, as in (1)
UseRegional[-1] Displays the value according to the Windows regional settings
Example
This example specifies that the negative sign with a space before the value is displayed in a numeric cell with a negative value.
FarPoint.Win.Spread.CellType.NumberCellType numct = new FarPoint.Win.Spread.CellType.NumberCellType();
numct.NegativeFormat = FarPoint.Win.Spread.CellType.NegativeFormat.NegativeSignBeforeWithSpace;
fpSpread1.ActiveSheet.Cells[0, 0].CellType = numct;
fpSpread1.ActiveSheet.Cells[0, 0].Value = -50;
Dim numct As New FarPoint.Win.Spread.CellType.NumberCellType()
numct.NegativeFormat = FarPoint.Win.Spread.CellType.NegativeFormat.NegativeSignBeforeWithSpace
fpSpread1.ActiveSheet.Cells(0, 0).CellType = numct
fpSpread1.ActiveSheet.Cells(0, 0).Value = -50
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Win.Spread.CellType.NegativeFormat

See Also

Reference

FarPoint.Win.Spread.CellType Namespace

User-Task Documentation

Setting a Number Cell