FixedPoint Property (PercentCellType)

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

Syntax

Visual Basic
C#

'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;

Visual Basic

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 Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

PercentCellType Class
PercentCellType Members