본문 바로가기

Web_Application/C#

[fpspread][c#] vb6 -> c# celltype 변경



//vb6
fpSpread1.TypeCurrencyDecPlaces = 2
fpSpread1.Value = Val(fpSpread1.Value) / Tmp@ * 100

//c#
var currencyCell = new FarPoint.Win.Spread.CellType.CurrencyCellType();
currencyCell.Separator = ".";
currencyCell.DecimalPlaces = 2;
sprList.Sheets[_sheetIndex].Cells[row, col].CellType = currencyCell;
var tempCellValue = sprList.Sheets[_sheetIndex].Cells[row, col].Value / tempValue * 100;
sprList.Sheets[_sheetIndex].Cells[row, col].Value = tempCellValue;