PercentNegativeFormat Enumeration

Specifies the display of negative values in a percent cell.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum PercentNegativeFormat 
   Inherits System.Enum

'Usage
 
Dim instance As PercentNegativeFormat

public enum PercentNegativeFormat : System.Enum

Members

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

Visual Basic

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

Reference

FarPoint.Win.Spread.CellType Namespace

User-Task Documentation

Setting a Percent Cell