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 Basic | Copy 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 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
See Also
