FarPoint.Win.Spread アセンブリ > FarPoint.Win.Spread.CellType 名前空間 > DateTimeCellType クラス : ShortDayNames プロパティ |
これは個々のセルに適用できます。書式がUserDefinedで、短い形式の2つのプロパティが"ddd MMM"、長い形式の2つのプロパティが"dddd MMMM"の場合のみ効果があります。
FarPoint.Win.Spread.CellType.DateTimeCellType dt = new FarPoint.Win.Spread.CellType.DateTimeCellType(); string[] dNames = {"Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday"}; string[] mNames = {"Jan", "Feb", "Mar", "Apr", "May", "June", "July", "Aug", "Sep", "Oct", "Nov", "Dec",""}; string[] sdNames = {"SU", "M", "T", "W", "TH", "F", "S"}; string[] smNames = {"J", "F", "M", "A", "MY", "J", "JY", "AG", "S", "O", "N", "D",""}; string okbutn = "Accept"; string canbutn = "Decline"; dt.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined; dt.UserDefinedFormat = "dddd MMMM d, yyyy"; dt.DayNames = dNames; dt.MonthNames = mNames; dt.ShortDayNames = sdNames; dt.ShortMonthNames = smNames; dt.SetCalendarText(okbutn, canbutn); fpSpread1.ActiveSheet.Cells[0, 0].CellType = dt; fpSpread1.ActiveSheet.Cells[0, 0].Value = System.DateTime.Now; fpSpread1.ActiveSheet.Columns[0].Width = 130;
Dim dt As New FarPoint.Win.Spread.CellType.DateTimeCellType() Dim dNames() As String = {"Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday"} Dim mNames() As String = {"Jan", "Feb", "Mar", "Apr", "May", "June", "July", "Aug", "Sep", "Oct", "Nov", "Dec",""} Dim sdNames() As String = {"SU", "M", "T", "W", "TH", "F", "S"} Dim smNames() As String = {"J", "F", "M", "A", "MY", "J", "JY", "AG", "S", "O", "N", "D",""} Dim okbutn As String = "Accept" Dim canbutn As String = "Decline" dt.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined dt.UserDefinedFormat = "dddd MMMM d, yyyy" dt.DayNames = dNames dt.MonthNames = mNames dt.ShortDayNames = sdNames dt.ShortMonthNames = smNames dt.SetCalendarText(okbutn, canbutn) fpSpread1.ActiveSheet.Cells(0, 0).CellType = dt fpSpread1.ActiveSheet.Cells(0, 0).Value = Now fpSpread1.ActiveSheet.Columns(0).Width = 130