Spread for ASP.NET 9.0 Product Documentation
FixedPoint Property (PercentCellType)
Example 


Gets or sets whether to display placeholder zeros in the decimal portion of the number for a fixed-point numeric display.
Syntax
'Declaration
 
Public Property FixedPoint As Boolean
'Usage
 
Dim instance As PercentCellType
Dim value As Boolean
 
instance.FixedPoint = value
 
value = instance.FixedPoint
public bool FixedPoint {get; set;}

Property Value

Boolean: true for fixed-point display with placeholder zeros; false otherwise
Example
This example sets the minimum and maximum values and how to display the percentage.
FarPoint.Web.Spread.PercentCellType pctcell = new FarPoint.Web.Spread.PercentCellType();
pctcell.MinimumValue = 0.151;    // 15.1%
pctcell.MaximumValue = 0.94;   // 94.0%
pctcell.DecimalDigits = 1;            // Show only one digit to right of decimal point.
pctcell.FixedPoint = true;
FpSpread1.ActiveSheetView.Cells[0, 1].CellType = pctcell;
Dim pctcell As New FarPoint.Web.Spread.PercentCellType()
pctcell.MinimumValue = 0.151 '15.1%
pctcell.MaximumValue = 0.94 '94.0%
pctcell.DecimalDigits = 1   'Show only one digit to right of decimal point.
pctcell.FixedPoint = True
FpSpread1.ActiveSheetView.Cells(0, 1).CellType = pctcell
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

PercentCellType Class
PercentCellType Members

 

 


Copyright © GrapeCity, inc. All rights reserved.