FarPoint.Win.Spread
NegativeFormat Enumeration
Example  See Also 
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace : NegativeFormat Enumeration


Specifies the display of the negative sign in cell contents.

Syntax

Visual Basic (Declaration) 
Public Enum NegativeFormat 
   Inherits Enum
Visual Basic (Usage)Copy Code
Dim instance As NegativeFormat
C# 
public enum NegativeFormat : Enum

Members

MemberDescription
UseRegional [-1] Displays the value according to the Windows regional settings
Parentheses [0] Displays the value within parentheses, as in (1)
NegativeSignBefore Displays the negative sign before (to the left) of the value, as in -1
NegativeSignBeforeWithSpace Displays the negative sign with space before (to the left) of the value, as in - 1
NegativeSignAfter Displays the negative sign after (to the right) of the value, as in 1-
NegativeSignAfterWithSpace Displays the negative sign with space after (to the right) of the value, as in 1 -

Example

This example specifies that the negative sign with a space before the value is displayed in a numeric cell with a negative value.
C#Copy Code
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;
Visual BasicCopy Code
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