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

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