Spread Windows Forms 10.0 Product Documentation
PercentNegativeFormat Enumeration
Example Example 


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

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

See Also

Reference

FarPoint.Win.Spread.CellType Namespace

User-Task Documentation

Setting a Percent Cell

 

 


Copyright © GrapeCity, inc. All rights reserved.