関数で曜日を設定すると英語で表示される
対象製品
SPREAD for ASP.NET 8.0J
状況
修正済み
詳細
カルチャがja-JPになっている場合でも、関数で曜日を設定すると英語で表示されます。
Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
If IsPostBack Then Return
System.Diagnostics.Debug.WriteLine(Threading.Thread.CurrentThread.CurrentCulture)
FpSpread1.ActiveSheetView.Columns(0).Width = 200
FpSpread1.ActiveSheetView.Cells(0, 0).Formula = "TEXT(TODAY(), ""yyyy年MM月dd日(ddd)"")"
Dim dt As New FarPoint.Web.Spread.DateTimeCellType()
dt.FormatString = "yyyy年MM月dd日(ddd)"
FpSpread1.ActiveSheetView.Cells(1, 0).CellType = dt
FpSpread1.ActiveSheetView.Cells(1, 0).Value = Now
End Sub
Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
If IsPostBack Then Return
System.Diagnostics.Debug.WriteLine(Threading.Thread.CurrentThread.CurrentCulture)
FpSpread1.ActiveSheetView.Columns(0).Width = 200
FpSpread1.ActiveSheetView.Cells(0, 0).Formula = "TEXT(TODAY(), ""yyyy年MM月dd日(ddd)"")"
Dim dt As New FarPoint.Web.Spread.DateTimeCellType()
dt.FormatString = "yyyy年MM月dd日(ddd)"
FpSpread1.ActiveSheetView.Cells(1, 0).CellType = dt
FpSpread1.ActiveSheetView.Cells(1, 0).Value = Now
End Sub
回避方法
Service Pack 3(v8.0.4004.2010)で修正済み。