PowerTools SPREAD for Windows Forms 10.0J
GetStickyNoteStyleInfo メソッド


セルの行インデックス
セルの列インデックス
このシートの常に表示されるセルのメモのスタイル情報を取得します。
構文
'Declaration
 
Public Overridable Function GetStickyNoteStyleInfo( _
   ByVal row As Integer, _
   ByVal column As Integer _
) As StickyNoteStyleInfo
'使用法
 
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim value As StickyNoteStyleInfo
 
value = instance.GetStickyNoteStyleInfo(row, column)
public virtual StickyNoteStyleInfo GetStickyNoteStyleInfo( 
   int row,
   int column
)

パラメータ

row
セルの行インデックス
column
セルの列インデックス

戻り値の型

スティッキーメモのスタイル情報を含むStickyNoteStyleInfoオブジェクト
次のサンプルコードは、スティッキーメモのスタイルを設定します。次のサンプルコードは、GetNoteStyleInfoメソッドを使用します。
fpSpread1.ActiveSheet.SetNote(2, 0, "Head of Development");
fpSpread1.ActiveSheet.Cells[2, 0].NoteStyle = FarPoint.Win.Spread.NoteStyle.StickyNote;
FarPoint.Win.Spread.DrawingSpace.StickyNoteStyleInfo nsinfo = new FarPoint.Win.Spread.DrawingSpace.StickyNoteStyleInfo();
nsinfo = fpSpread1.ActiveSheet.GetStickyNoteStyleInfo(2, 0);
nsinfo.BackColor = Color.Bisque;
nsinfo.Font = new Font("Tahoma", 24);
nsinfo.ForeColor = Color.Cyan;
nsinfo.Width = 320;
nsinfo.ShapeOutlineColor = Color.Cyan;
nsinfo.ShapeOutlineThickness = 1;
nsinfo.ShadowOffsetX = 3;
nsinfo.ShadowOffsetY = 3;
fpSpread1.ActiveSheet.SetStickyNoteStyleInfo(2, 0, nsinfo);
FpSpread1.ActiveSheet.SetNote(2, 0, "Head of Development")
FpSpread1.ActiveSheet.Cells(2, 0).NoteStyle = FarPoint.Win.Spread.NoteStyle.StickyNote
Dim nsinfo As FarPoint.Win.Spread.DrawingSpace.StickyNoteStyleInfo = New FarPoint.Win.Spread.DrawingSpace.StickyNoteStyleInfo
nsinfo = FpSpread1.ActiveSheet.GetStickyNoteStyleInfo(2, 0)
nsinfo.BackColor = Color.Bisque
nsinfo.Font = New Font("Tahoma", 24)
nsinfo.ForeColor = Color.Cyan
nsinfo.Width = 320
nsinfo.ShapeOutlineColor = Color.Cyan
nsinfo.ShapeOutlineThickness = 1
nsinfo.ShadowOffsetX = 3
nsinfo.ShadowOffsetY = 3
FpSpread1.ActiveSheet.SetStickyNoteStyleInfo(2, 0, nsinfo)
fpSpread1.ActiveSheet.SetNote(2, 0, "Head of Development");
FarPoint.Win.Spread.DrawingSpace.StickyNoteStyleInfo nsinfo = new FarPoint.Win.Spread.DrawingSpace.StickyNoteStyleInfo();
nsinfo = fpSpread1.ActiveSheet.GetStickyNoteStyleInfo(2, 0);
nsinfo.BackColor = Color.Bisque;
nsinfo.Font = new Font("Tahoma", 24);
nsinfo.ForeColor = Color.Cyan;
nsinfo.Width = 320;
nsinfo.ShapeOutlineColor = Color.Cyan;
nsinfo.ShapeOutlineThickness = 1;
nsinfo.ShadowOffsetX = 3;
nsinfo.ShadowOffsetY = 3;
nsinfo.MarginLeft = 5;
fpSpread1.ActiveSheet.SetStickyNoteStyleInfo(2, 0, nsinfo);
fpSpread1.Sheets[0].Cells[2, 0].NoteIndicatorPosition = FarPoint.Win.Spread.NoteIndicatorPosition.BottomLeft;
FpSpread1.ActiveSheet.SetNote(2, 0, "Head of Development")
Dim nsinfo As FarPoint.Win.Spread.DrawingSpace.StickyNoteStyleInfo = New FarPoint.Win.Spread.DrawingSpace.StickyNoteStyleInfo()
nsinfo = FpSpread1.ActiveSheet.GetStickyNoteStyleInfo(2, 0)
nsinfo.BackColor = Color.Bisque
nsinfo.Font = New Font("Tahoma", 12)
nsinfo.ForeColor = Color.Cyan
nsinfo.Width = 250
nsinfo.ShapeOutlineColor = Color.Cyan
nsinfo.ShapeOutlineThickness = 1
nsinfo.ShadowOffsetX = 3
nsinfo.ShadowOffsetY = 3
nsinfo.MarginLeft = 5
FpSpread1.ActiveSheet.SetStickyNoteStyleInfo(2, 0, nsinfo)
FpSpread1.Sheets(0).Cells(2, 0).NoteIndicatorPosition = FarPoint.Win.Spread.NoteIndicatorPosition.BottomLeft
参照

SheetView クラス
SheetView メンバ
StyleInfo クラス

開発者ガイド

名前付きスタイル
セルノート

 

 


© 2004-2017, GrapeCity inc. All rights reserved.