Spread Windows Forms 8.0 Product Documentation > Developer's Guide > Customizing Interaction with Cell Types > Working with Editable Cell Types > Setting a Currency Cell |
You can set a cell to display currency values using the currency cell. A currency cell displays the numeric currency values with formatting that you can customize including a currency symbol, a separator character, and other formatting.
You use the CurrencyCellType class to set the currency cell and its properties.
By default, Spread uses the regional Windows settings (or options) of the machine on which it runs for the formatting of currency. You can customize any of these currency formatting properties:
By default, in a currency cell, if you double-click on the cell in edit mode at run-time, a pop-up calculator appears. You can determine whether to allow this, and you can specify the text that displays on the OK and Cancel buttons. For more information, refer to Customizing the Pop-Up Calculator Control.
You can also set the minimum and maximum values that can be entered to provide validation of the user entry. To define the limits for values, refer to Limiting Values for a Numeric Cell.
By default, no spin buttons are shown, but you can display spin buttons on the side of the cell when the cell is in edit mode. You can set various spin functions using the properties of the CurrencyCellType that begin with the word Spin. For more information, refer to Displaying Spin Buttons.
For more information on the properties and methods of this cell type, refer to the CurrencyCellType class.
This example creates a currency cell.
C# |
Copy Code
|
---|---|
FarPoint.Win.Spread.CellType.CurrencyCellType currcell = new FarPoint.Win.Spread.CellType.CurrencyCellType(); currcell.CurrencySymbol = "US$"; currcell.DecimalSeparator = ":"; currcell.DecimalPlaces = 8; fpSpread1.ActiveSheet.Cells[1,1].CellType = currcell; |
VB |
Copy Code
|
---|---|
Dim currcell As New FarPoint.Win.Spread.CellType.CurrencyCellType() currcell.CurrencySymbol = "US$" currcell.DecimalSeparator = ":" currcell.DecimalPlaces = 8 FpSpread1.ActiveSheet.Cells(1,1).CellType = currcell |
Or right-click on the cell or cells and select Cell Type. From the list, select Currency. In the CellType editor, set the properties you need. Click Apply.