NegativeFormat Enumeration

Specifies the display of the negative sign in the cell contents.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum NegativeFormat 
   Inherits System.Enum

'Usage
 
Dim instance As NegativeFormat

public enum NegativeFormat : System.Enum

Members

Member	Description
NegativeSignAfter	Displays the negative sign (to the right) after the value, as in 1-
NegativeSignAfterWithSpace	Displays the negative sign with a space (to the right) after the value, as in 1 -
NegativeSignBefore	Displays the negative sign (to the left) before the value, as in -1
NegativeSignBeforeWithSpace	Displays 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;

Visual Basic

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

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

FarPoint.Win.Spread.CellType Namespace

User-Task Documentation

Setting a Number Cell