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 currency symbol, separator character and others.
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:
- currency symbol (and whether to display it)
- separator character (and whether to display it)
- decimal symbol
- whether to display a leading zero
- positive value indicator (and whether to display it)
- negative value indicator (and whether to display it)
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 allow for validation of the user entry. To define the limits for values, refer to Limiting Values for a Numeric Cell.
Using Spin Buttons
By default, no spin buttons are shown, but you can display spin buttons in 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.
Refer to Displaying Spin Buttons.
For more information on the properties and methods of this cell type, refer to the CurrencyCellType class.
Using the Properties Window
- At design time, in the Properties window, select the Spread component.
- Select the Sheets property.
- Click the button to display the SheetView Collection Editor.
- In the Members list, select the sheet in which the cells appear.
- In the property list, select the Cells property and then click the button to display the Cell, Column, and Row Editor.
- Select the cells for which you want to set the cell type.
- In the property list, select the CellType property and choose the Currency cell type.
- Expand the list of properties under the CellType property. Select and set these specific properties as needed.
- Click OK to close the Cell, Column, and Row Editor.
- Click OK to close the SheetView Collection Editor.
- Define a currency cell by creating an instance of the CurrencyCellType class.
- Specify the formatting of a currency cell by setting the CurrencySymbol and other properties on the CurrencyCellType object.
- Assign the currency cell type to a cell or range of cells by setting the CellType property for a cell, column, row, or style to the CurrencyCellType object.
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;
Dim currcell As New FarPoint.Win.Spread.CellType.CurrencyCellType() currcell.CurrencySymbol = "US$" currcell.DecimalSeparator = ":" currcell.DecimalPlaces = 8 FpSpread1.ActiveSheet.Cells(1,1).CellType = currcell
Using the Spread Designer
- Select the cell or cells in the work area.
- In the property list, in the Misc category, select CellType. From the drop-down list, choose the Currency cell type. Now expand the CellType property and various properties are available that are specific to this cell type. Select and set those properties as needed.
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.
- From the File menu choose Apply and Exit to apply your changes to the component and exit Spread Designer.