Spread Windows Forms 11.0 Product Documentation
PercentNegativeFormat Enumeration
Example Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace : PercentNegativeFormat Enumeration
Specifies the display of negative values in a percent cell.
Syntax
'Declaration
 
Public Enum PercentNegativeFormat 
   Inherits System.Enum
'Usage
 
Dim instance As PercentNegativeFormat
public enum PercentNegativeFormat : System.Enum 
Members
MemberDescription
PercentAfter[1] Displays the negative percent value with the percent symbol following the number
PercentAfterWithSpace[0] Displays the negative percent value with a space and the percent symbol following the number
PercentBefore[2] Displays the negative percent value with the percent symbol before the number
UseRegional[-1] Displays the negative percent value in the format set by the Windows regional settings
Example
This example specifies the format for negative percent values and places the percent sign with a space after the value.
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;
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

Reference

FarPoint.Win.Spread.CellType Namespace

User-Task Documentation

Setting a Percent Cell