FarPoint.Win.Spread.CellType.CurrencyCellType currcell = new FarPoint.Win.Spread.CellType.CurrencyCellType();
currcell.CurrencySymbol = "CN$";
currcell.DecimalPlaces = 2;
currcell.DecimalSeparator = "#";
currcell.FixedPoint = true;
currcell.ShowCurrencySymbol = true;
currcell.ShowSeparator = true;
fpSpread1.Sheets[0].Cells[1, 1].CellType = currcell;
fpSpread1.Sheets[0].Cells[1, 1].Value = 321.98;
fpSpread1.Sheets[0].Cells[1,0].CellType = new FarPoint.Win.Spread.CellType.CurrencyCellType(currcell);
fpSpread1.Sheets[0].Cells[1, 0].Value = 35.32;
Dim currcell As New FarPoint.Win.Spread.CellType.CurrencyCellType()
currcell.CurrencySymbol = "CN$"
currcell.DecimalPlaces = 2
currcell.DecimalSeparator = "#"
currcell.FixedPoint = True
currcell.ShowCurrencySymbol = True
currcell.ShowSeparator = True
fpSpread1.Sheets(0).Cells(1, 1).CellType = currcell
fpSpread1.Sheets(0).Cells(1, 1).Value = 321.98
fpSpread1.Sheets(0).Cells(1, 0).CellType = New FarPoint.Win.Spread.CellType.CurrencyCellType(currcell)
fpSpread1.Sheets(0).Cells(1, 0).Value = 35.32