作成日: 2017/05/22 最終更新日: 2017/05/22
文書種別
使用方法
詳細
通貨型セル、倍精度型セル、標準型セル、整数型セル、パーセント型セルのNegativeRed プロパティをTrueに設定することで、マイナスの値の文字の色が赤で表示されます。
◎サンプルコード(VB)
◎サンプルコード(C#)
◎サンプルコード(VB)
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If IsPostBack Then
Return
End If
FpSpread1.ActiveSheetView.ColumnCount = 5
' 通貨型セルの設定
Dim currcell As New FarPoint.Web.Spread.CurrencyCellType
currcell.NegativeRed = True
FpSpread1.ActiveSheetView.Columns(0).CellType = currcell
' 倍精度型セルの設定
Dim dblcell As New FarPoint.Web.Spread.DoubleCellType()
dblcell.NegativeRed = True
FpSpread1.ActiveSheetView.Columns(1).CellType = dblcell
' 標準型セルの設定
Dim gencell As New FarPoint.Web.Spread.GeneralCellType()
gencell.NegativeRed = True
FpSpread1.ActiveSheetView.Columns(2).CellType = gencell
' 整数型セルの設定
Dim intcell As New FarPoint.Web.Spread.IntegerCellType()
intcell.NegativeRed = True
FpSpread1.ActiveSheetView.Columns(3).CellType = intcell
' パーセント型セルの設定
Dim pctcell As New FarPoint.Web.Spread.PercentCellType()
pctcell.NegativeRed = True
FpSpread1.ActiveSheetView.Columns(4).CellType = pctcell
' 値の設定
FpSpread1.ActiveSheetView.Cells(0, 0).Value = -1
FpSpread1.ActiveSheetView.Cells(0, 1).Value = -1
FpSpread1.ActiveSheetView.Cells(0, 2).Value = -1
FpSpread1.ActiveSheetView.Cells(0, 3).Value = -1
FpSpread1.ActiveSheetView.Cells(0, 4).Value = -1
End Sub
If IsPostBack Then
Return
End If
FpSpread1.ActiveSheetView.ColumnCount = 5
' 通貨型セルの設定
Dim currcell As New FarPoint.Web.Spread.CurrencyCellType
currcell.NegativeRed = True
FpSpread1.ActiveSheetView.Columns(0).CellType = currcell
' 倍精度型セルの設定
Dim dblcell As New FarPoint.Web.Spread.DoubleCellType()
dblcell.NegativeRed = True
FpSpread1.ActiveSheetView.Columns(1).CellType = dblcell
' 標準型セルの設定
Dim gencell As New FarPoint.Web.Spread.GeneralCellType()
gencell.NegativeRed = True
FpSpread1.ActiveSheetView.Columns(2).CellType = gencell
' 整数型セルの設定
Dim intcell As New FarPoint.Web.Spread.IntegerCellType()
intcell.NegativeRed = True
FpSpread1.ActiveSheetView.Columns(3).CellType = intcell
' パーセント型セルの設定
Dim pctcell As New FarPoint.Web.Spread.PercentCellType()
pctcell.NegativeRed = True
FpSpread1.ActiveSheetView.Columns(4).CellType = pctcell
' 値の設定
FpSpread1.ActiveSheetView.Cells(0, 0).Value = -1
FpSpread1.ActiveSheetView.Cells(0, 1).Value = -1
FpSpread1.ActiveSheetView.Cells(0, 2).Value = -1
FpSpread1.ActiveSheetView.Cells(0, 3).Value = -1
FpSpread1.ActiveSheetView.Cells(0, 4).Value = -1
End Sub
◎サンプルコード(C#)
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
FpSpread1.ActiveSheetView.ColumnCount = 5;
// 通貨型セルの設定
FarPoint.Web.Spread.CurrencyCellType currcell = new FarPoint.Web.Spread.CurrencyCellType();
currcell.NegativeRed = true;
FpSpread1.ActiveSheetView.Columns[0].CellType = currcell;
// 倍精度型セルの設定
FarPoint.Web.Spread.DoubleCellType dblcell = new FarPoint.Web.Spread.DoubleCellType();
dblcell.NegativeRed = true;
FpSpread1.ActiveSheetView.Columns[1].CellType = dblcell;
// 標準型セルの設定
FarPoint.Web.Spread.GeneralCellType gencell = new FarPoint.Web.Spread.GeneralCellType();
gencell.NegativeRed = true;
FpSpread1.ActiveSheetView.Columns[2].CellType = gencell;
// 整数型セルの設定
FarPoint.Web.Spread.IntegerCellType intcell = new FarPoint.Web.Spread.IntegerCellType();
intcell.NegativeRed = true;
FpSpread1.ActiveSheetView.Columns[3].CellType = intcell;
// パーセント型セルの設定
FarPoint.Web.Spread.PercentCellType pctcell = new FarPoint.Web.Spread.PercentCellType();
pctcell.NegativeRed = true;
FpSpread1.ActiveSheetView.Columns[4].CellType = pctcell;
// 値の設定
FpSpread1.ActiveSheetView.Cells[0, 0].Value = -1;
FpSpread1.ActiveSheetView.Cells[0, 1].Value = -1;
FpSpread1.ActiveSheetView.Cells[0, 2].Value = -1;
FpSpread1.ActiveSheetView.Cells[0, 3].Value = -1;
FpSpread1.ActiveSheetView.Cells[0, 4].Value = -1;
}
{
if (IsPostBack)
{
return;
}
FpSpread1.ActiveSheetView.ColumnCount = 5;
// 通貨型セルの設定
FarPoint.Web.Spread.CurrencyCellType currcell = new FarPoint.Web.Spread.CurrencyCellType();
currcell.NegativeRed = true;
FpSpread1.ActiveSheetView.Columns[0].CellType = currcell;
// 倍精度型セルの設定
FarPoint.Web.Spread.DoubleCellType dblcell = new FarPoint.Web.Spread.DoubleCellType();
dblcell.NegativeRed = true;
FpSpread1.ActiveSheetView.Columns[1].CellType = dblcell;
// 標準型セルの設定
FarPoint.Web.Spread.GeneralCellType gencell = new FarPoint.Web.Spread.GeneralCellType();
gencell.NegativeRed = true;
FpSpread1.ActiveSheetView.Columns[2].CellType = gencell;
// 整数型セルの設定
FarPoint.Web.Spread.IntegerCellType intcell = new FarPoint.Web.Spread.IntegerCellType();
intcell.NegativeRed = true;
FpSpread1.ActiveSheetView.Columns[3].CellType = intcell;
// パーセント型セルの設定
FarPoint.Web.Spread.PercentCellType pctcell = new FarPoint.Web.Spread.PercentCellType();
pctcell.NegativeRed = true;
FpSpread1.ActiveSheetView.Columns[4].CellType = pctcell;
// 値の設定
FpSpread1.ActiveSheetView.Cells[0, 0].Value = -1;
FpSpread1.ActiveSheetView.Cells[0, 1].Value = -1;
FpSpread1.ActiveSheetView.Cells[0, 2].Value = -1;
FpSpread1.ActiveSheetView.Cells[0, 3].Value = -1;
FpSpread1.ActiveSheetView.Cells[0, 4].Value = -1;
}
旧文書番号
40368