//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;
'Web_Application > C#' 카테고리의 다른 글
[fpspread][c#] HeaderColumns, Columns Border 라인 넣기 (0) | 2018.11.05 |
---|---|
[fpspread][c#] cell border style (0) | 2018.09.11 |
[fpspread][c#][excel formula 변환] vb6의 average -> c#.net 의 average (0) | 2018.09.05 |
[fpspread][c#] list binding slow (0) | 2018.09.05 |
[c#][string.Join] 배열 요소 붙이기 (0) | 2018.03.30 |