レジストリに新しい元号の設定を行っても、フラットスタイルで新しい元号を表示できない – MESCIUS ナレッジベース

作成日: 2019/04/08 最終更新日: 2019/04/17

文書種別

不具合

状況

修正済み

詳細

レジストリに新しい元号の設定を行っても、フラットスタイルで新しい元号を表示できません。

【再現手順】

レジストリに新しい元号を設定します。

新規作成したFormにSPREADを貼り付け、下記サンプルコードを記述して実行します。

◎サンプルコード(VB)

Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
　　FpSpread1.AsWorkbook().ActiveSheet.Columns(0, 1).ColumnWidth = 150
　　FpSpread1.AsWorkbook().ActiveSheet.Columns(0, 1).HorizontalAlignment = GrapeCity.Spreadsheet.HorizontalAlignment.Left
　　FpSpread1.AsWorkbook().ActiveSheet.Cells(0, 0).Value = "flat style"
　　FpSpread1.AsWorkbook().ActiveSheet.Cells(1, 0).NumberFormat = "[$-ja-JP]ggge年m月d日"
　　FpSpread1.AsWorkbook().ActiveSheet.Cells(1, 0).Value = New DateTime(1989, 1, 8)
　　FpSpread1.AsWorkbook().ActiveSheet.Cells(2, 0).NumberFormat = "[$-ja-JP]ggge年m月d日"
　　FpSpread1.AsWorkbook().ActiveSheet.Cells(2, 0).Value = New DateTime(2019, 5, 1)

　　FpSpread1.AsWorkbook().ActiveSheet.Cells(0, 1).Value = "DateTimeCellType"

　　Dim dateCell1 = New FarPoint.Win.Spread.CellType.DateTimeCellType()
　　dateCell1.Calendar = New System.Globalization.JapaneseCalendar()
　　dateCell1.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined
　　dateCell1.UserDefinedFormat = "ggy年M月d日"
　　FpSpread1.ActiveSheet.Cells(1, 1).CellType = dateCell1
　　FpSpread1.AsWorkbook().ActiveSheet.Cells(1, 1).Value = New DateTime(1989, 1, 8)

　　Dim dateCell2 = New FarPoint.Win.Spread.CellType.DateTimeCellType()
　　dateCell2.Calendar = New System.Globalization.JapaneseCalendar()
　　dateCell2.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined
　　dateCell2.UserDefinedFormat = "ggy年M月d日"
　　FpSpread1.ActiveSheet.Cells(2, 1).CellType = dateCell2
　　FpSpread1.AsWorkbook().ActiveSheet.Cells(2, 1).Value = New DateTime(2019, 5, 1)
End Sub

◎サンプルコード(C#)

private void Form1_Load(object sender, EventArgs e)
{
　　fpSpread1.AsWorkbook().ActiveSheet.Columns[0, 1].ColumnWidth = 150;
　　fpSpread1.AsWorkbook().ActiveSheet.Columns[0, 1].HorizontalAlignment = GrapeCity.Spreadsheet.HorizontalAlignment.Left;

　　fpSpread1.AsWorkbook().ActiveSheet.Cells[0, 0].Value = "flat style";
　　fpSpread1.AsWorkbook().ActiveSheet.Cells[1, 0].NumberFormat = "[$-ja-JP]ggge¥"年¥"m¥"月¥"d¥"日¥"";
　　fpSpread1.AsWorkbook().ActiveSheet.Cells[1, 0].Value = new DateTime(1989, 1, 8);
　　fpSpread1.AsWorkbook().ActiveSheet.Cells[2, 0].NumberFormat = "[$-ja-JP]ggge¥"年¥"m¥"月¥"d¥"日¥"";
　　fpSpread1.AsWorkbook().ActiveSheet.Cells[2, 0].Value = new DateTime(2019, 5, 1);

　　fpSpread1.AsWorkbook().ActiveSheet.Cells[0, 1].Value = "DateTimeCellType";

　　FarPoint.Win.Spread.CellType.DateTimeCellType dateCell1 = new FarPoint.Win.Spread.CellType.DateTimeCellType();
　　dateCell1.Calendar = new System.Globalization.JapaneseCalendar();
　　dateCell1.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined;
　　dateCell1.UserDefinedFormat = "ggy年M月d日";
　　fpSpread1.ActiveSheet.Cells[1, 1].CellType = dateCell1;
　　fpSpread1.AsWorkbook().ActiveSheet.Cells[1, 1].Value = new DateTime(1989, 1, 8);

　　FarPoint.Win.Spread.CellType.DateTimeCellType dateCell2 = new FarPoint.Win.Spread.CellType.DateTimeCellType();
　　dateCell2.Calendar = new System.Globalization.JapaneseCalendar();
　　dateCell2.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined;
　　dateCell2.UserDefinedFormat = "ggy年M月d日";
　　fpSpread1.ActiveSheet.Cells[2, 1].CellType = dateCell2;
　　fpSpread1.AsWorkbook().ActiveSheet.Cells[2, 1].Value = new DateTime(2019, 5, 1);
}

回避方法

Service Pack 1（v12.0.4501.2012）で修正済み。

旧文書番号

83834