数値を表示しきれない場合に「###」と表示したい
対象製品
SPREAD for Windows Forms 8.0J
詳細
数値型セルや通貨型セルのOverflowCharacterプロパティを使用することで、セルの幅に文字がおさまらなかった場合に置換する文字を設定することができます。
◎サンプルコード(VB)
◎サンプルコード(C#)
◎サンプルコード(VB)
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
' セル型の設定
Dim nmbrcell As New FarPoint.Win.Spread.CellType.NumberCellType()
nmbrcell.OverflowCharacter = "#"c
FpSpread1.ActiveSheet.Columns(0).CellType = nmbrcell
Dim currcell As New FarPoint.Win.Spread.CellType.CurrencyCellType()
currcell.OverflowCharacter = "#"c
FpSpread1.ActiveSheet.Columns(1).CellType = currcell
' テストデータの設定
FpSpread1.ActiveSheet.Cells(0, 0).Value = 123456789
FpSpread1.ActiveSheet.Cells(0, 1).Value = 123456789
' 列幅の設定
FpSpread1.ActiveSheet.Columns(0).Width = 50
FpSpread1.ActiveSheet.Columns(1).Width = 50
End Sub
' セル型の設定
Dim nmbrcell As New FarPoint.Win.Spread.CellType.NumberCellType()
nmbrcell.OverflowCharacter = "#"c
FpSpread1.ActiveSheet.Columns(0).CellType = nmbrcell
Dim currcell As New FarPoint.Win.Spread.CellType.CurrencyCellType()
currcell.OverflowCharacter = "#"c
FpSpread1.ActiveSheet.Columns(1).CellType = currcell
' テストデータの設定
FpSpread1.ActiveSheet.Cells(0, 0).Value = 123456789
FpSpread1.ActiveSheet.Cells(0, 1).Value = 123456789
' 列幅の設定
FpSpread1.ActiveSheet.Columns(0).Width = 50
FpSpread1.ActiveSheet.Columns(1).Width = 50
End Sub
◎サンプルコード(C#)
private void Form1_Load(object sender, EventArgs e)
{
// セル型の設定
FarPoint.Win.Spread.CellType.NumberCellType nmbrcell = new FarPoint.Win.Spread.CellType.NumberCellType();
nmbrcell.OverflowCharacter = '#';
fpSpread1.ActiveSheet.Columns[0].CellType = nmbrcell;
FarPoint.Win.Spread.CellType.CurrencyCellType currcell = new FarPoint.Win.Spread.CellType.CurrencyCellType();
currcell.OverflowCharacter = '#';
fpSprhttps://test.grapecity.com/tools/admin/EditKB.asp?page=1&sort=0&preval=20&productid=-1&keyword=#ead1.ActiveSheet.Columns[1].CellType = currcell;
// テストデータの設定
fpSpread1.ActiveSheet.Cells[0, 0].Value = 123456789;
fpSpread1.ActiveSheet.Cells[0, 1].Value = 123456789;
// 列幅の設定
fpSpread1.ActiveSheet.Columns[0].Width = 50;
fpSpread1.ActiveSheet.Columns[1].Width = 50;
}
{
// セル型の設定
FarPoint.Win.Spread.CellType.NumberCellType nmbrcell = new FarPoint.Win.Spread.CellType.NumberCellType();
nmbrcell.OverflowCharacter = '#';
fpSpread1.ActiveSheet.Columns[0].CellType = nmbrcell;
FarPoint.Win.Spread.CellType.CurrencyCellType currcell = new FarPoint.Win.Spread.CellType.CurrencyCellType();
currcell.OverflowCharacter = '#';
fpSprhttps://test.grapecity.com/tools/admin/EditKB.asp?page=1&sort=0&preval=20&productid=-1&keyword=#ead1.ActiveSheet.Columns[1].CellType = currcell;
// テストデータの設定
fpSpread1.ActiveSheet.Cells[0, 0].Value = 123456789;
fpSpread1.ActiveSheet.Cells[0, 1].Value = 123456789;
// 列幅の設定
fpSpread1.ActiveSheet.Columns[0].Width = 50;
fpSpread1.ActiveSheet.Columns[1].Width = 50;
}
キーワード
セル型