Spread ASP.NET 6.0 Product Documentation
FixedPoint Property
See Also  Example Send Feedback
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > PercentCellType Class : FixedPoint Property


Glossary Item Box

Gets or sets whether to display placeholder zeros in the decimal portion of the number for a fixed-point numeric display.

Syntax

Visual Basic (Declaration) 
Public Property FixedPoint As Boolean
Visual Basic (Usage)Copy Code
Dim instance As PercentCellType
Dim value As Boolean
 
instance.FixedPoint = value
 
value = instance.FixedPoint
C# 
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.
C#Copy Code
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;
Visual BasicCopy Code
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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.