PercentPositiveFormat Enumeration

Specifies the display of positive values in a percent cell.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum PercentPositiveFormat 
   Inherits System.Enum

'Usage
 
Dim instance As PercentPositiveFormat

public enum PercentPositiveFormat : System.Enum

Members

Member	Description
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;

Visual Basic

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

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 Percent Cell