Spread Windows Forms 11.0 Product Documentation
PercentPositiveFormat Enumeration
Example Example 


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

See Also

Reference

FarPoint.Win.Spread.CellType Namespace

User-Task Documentation

Setting a Percent Cell