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


Specifies the display of negative values in a percent cell.

Syntax

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

Members

MemberDescription
UseRegional [-1] Displays the negative percent value in the format set by the Windows regional settings
PercentAfterWithSpace [0] Displays the negative percent value with a space and the percent symbol following the number
PercentAfter [1] Displays the negative percent value with the percent symbol following the number
PercentBefore [2] Displays the negative percent value with the percent symbol before the number

Example

This example specifies the format for negative percent values and places the percent sign with a space after the value.
C#Copy Code
FarPoint.Win.Spread.CellType.PercentCellType prct = new FarPoint.Win.Spread.CellType.PercentCellType();
prct.NegativeFormat = FarPoint.Win.Spread.CellType.PercentNegativeFormat.PercentAfterWithSpace;
fpSpread1.ActiveSheet.Cells[0, 0].CellType = prct;
fpSpread1.ActiveSheet.Cells[0, 0].Value = -0.34;
Visual BasicCopy Code
Dim prct As New FarPoint.Win.Spread.CellType.PercentCellType()
prct.NegativeFormat = FarPoint.Win.Spread.CellType.PercentNegativeFormat.PercentAfterWithSpace
FpSpread1.ActiveSheet.Cells(0, 0).CellType = prct
FpSpread1.ActiveSheet.Cells(0, 0).Value =- 0.34

Inheritance Hierarchy

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

See Also