Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Property NegativeFormat As CurrencyNegativeFormat | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As CurrencyCellType Dim value As CurrencyNegativeFormat instance.NegativeFormat = value value = instance.NegativeFormat | |
| C# | |
|---|---|
public CurrencyNegativeFormat NegativeFormat {get; set;} | |
Property Value
CurrencyNegativeFormat setting that determines how negative currency values are displayedExample
This example specifies a currency cell and sets the formatting using the various properties.
| C# | Copy Code |
|---|---|
FarPoint.Win.Spread.CellType.CurrencyCellType currcell = new FarPoint.Win.Spread.CellType.CurrencyCellType(); currcell.CurrencySymbol = "CN$"; currcell.DecimalPlaces = 4; currcell.DecimalSeparator = "#"; currcell.FixedPoint = true; currcell.LeadingZero = FarPoint.Win.Spread.CellType.LeadingZero.Yes; currcell.MaximumValue = 999999999999; currcell.MinimumValue = 1; currcell.NegativeFormat = FarPoint.Win.Spread.CellType.CurrencyNegativeFormat.SignSymbolSpaceBefore; currcell.NegativeRed = true; currcell.PositiveFormat = FarPoint.Win.Spread.CellType.CurrencyPositiveFormat.CurrencySymbolBefore; currcell.Separator = ","; currcell.ShowCurrencySymbol = true; currcell.ShowSeparator = true; fpSpread1.Sheets[0].Cells[5,2].CellType = currcell; fpSpread1.Sheets[0].Cells[5,2].Value = 321.98; | |
| Visual Basic | Copy Code |
|---|---|
Dim currcell As New FarPoint.Win.Spread.CellType.CurrencyCellType() currcell.CurrencySymbol = "CN$" currcell.DecimalPlaces = 4 currcell.DecimalSeparator = "#" currcell.FixedPoint = True currcell.LeadingZero = FarPoint.Win.Spread.CellType.LeadingZero.Yes currcell.MaximumValue = 999999999999 currcell.MinimumValue = 1 currcell.NegativeFormat = FarPoint.Win.Spread.CellType.CurrencyNegativeFormat.SignSymbolSpaceBefore currcell.NegativeRed = true currcell.PositiveFormat = FarPoint.Win.Spread.CellType.CurrencyPositiveFormat.CurrencySymbolBefore currcell.Separator = "," currcell.ShowCurrencySymbol = True currcell.ShowSeparator = True FpSpread1.Sheets(0).Cells(5, 2).CellType = currcell FpSpread1.Sheets(0).Cells(5, 2).Value = 443.3482 | |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8