FixedPoint Property (DoubleCellType)

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 DoubleCellType
Dim value As Boolean
 
instance.FixedPoint = value
 
value = instance.FixedPoint

public bool FixedPoint {get; set;}

Property Value

Boolean: true to set the fixed-point display and show placeholder zeros; false otherwise

Example

This example sets the display for a double-precision numeric cell.

FarPoint.Web.Spread.DoubleCellType dblc = new FarPoint.Web.Spread.DoubleCellType();
dblc.DecimalDigits = 3;
dblc.FixedPoint = True;
FpSpread1.ActiveSheetView.Cells[0, 0].CellType = dblc;
FpSpread1.ActiveSheetView.Cells[0, 0].Value = 435.98745;

Visual Basic

Dim dblc As New FarPoint.Web.Spread.DoubleCellType
dblc.DecimalDigits = 3
dblc.FixedPoint = true
FpSpread1.ActiveSheetView.Cells(0, 0).CellType = dblc
FpSpread1.ActiveSheetView.Cells(0, 0).Value = 435.98745

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

DoubleCellType Class
DoubleCellType Members