protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
worksheet = this.grid.CurrentWorksheet;
// ソースコードのコメントと説明は「折れ線グラフ（LineChartDemo.cs）」をご覧ください。
worksheet["A2"] = new object[, ] {
{ null, 2008, 2009, 2010, 2011, 2012 },
{ "札幌", 3, 2, 4, 2, 6 },
{ "名古屋", 7, 5, 3, 6, 4 },
{ "東京", 13, 10, 9, 10, 9 },
{ "合計", "=SUM(B3:B5)", "=SUM(C3:C5)", "=SUM(D3:D5)", "=SUM(E3:E5)", "=SUM(F3:F5)" },
};
var dataRange = worksheet.Ranges["B3:F5"];
var rowTitleRange = worksheet.Ranges["A3:A6"];
var categoryNamesRange = worksheet.Ranges["B2:F2"];
worksheet.AddHighlightRange(rowTitleRange);
worksheet.AddHighlightRange(categoryNamesRange);
worksheet.AddHighlightRange(dataRange);
var c1 = new BarChart
{
Location = new Graphics.Point(220, 160),
Size = new Graphics.Size(400, 260),
Title = "横棒グラフ",
DataSource = new WorksheetChartDataSource(worksheet, rowTitleRange, dataRange)
{
CategoryNameRange = categoryNamesRange,
},
};
worksheet.FloatingObjects.Add(c1);
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
worksheet = this.grid.CurrentWorksheet;
worksheet["A2"] = new object[, ] {
{ null, 2008, 2009, 2010, 2011, 2012 },
{ "City 1", 3, 2, 4, 2, 6 },
{ "City 2", 7, 5, 3, 6, 4 },
{ "City 3", 13, 10, 9, 10, 9 },
{ "Total", "=SUM(B3:B5)", "=SUM(C3:C5)", "=SUM(D3:D5)", "=SUM(E3:E5)", "=SUM(F3:F5)" },
};
var dataRange = worksheet.Ranges["B3:F5"];
var rowTitleRange = worksheet.Ranges["A3:A6"];
var categoryNamesRange = worksheet.Ranges["B2:F2"];
worksheet.AddHighlightRange(rowTitleRange);
worksheet.AddHighlightRange(categoryNamesRange);
worksheet.AddHighlightRange(dataRange);
var chart = new Chart.BarChart
{
Location = new Graphics.Point(220, 160),
Size = new Graphics.Size(400, 260),
Title = "Bar Chart Sample",
DataSource = new WorksheetChartDataSource(worksheet, rowTitleRange, dataRange)
{
CategoryNameRange = categoryNamesRange,
},
};
worksheet.FloatingObjects.Add(chart);
}
/// <summary>
/// Undo this action
/// </summary>
public override void Undo()
{
if (Range.Rows == -1)
{
Logger.Log("remove rows", "attempt to undo removing all rows from the worksheet must it must be have at least one row, operation aborted.");
return;
}
Worksheet.InsertRows(Range.Row, Range.Rows);
if (backupData == null)
{
#if DEBUG
Logger.Log("remove rows", "no backup data");
Debug.Assert(false, "why no backup data here?");
#else
return;
#endif // DEBUG
}
// restore deleted data
Worksheet.SetPartialGrid(Range, backupData);
#region Restore Outlines
#if OUTLINE
// restore outlines
if (this.changedOutlines != null)
{
foreach (var changedOutlineInfo in this.changedOutlines)
{
changedOutlineInfo.Key.Start = changedOutlineInfo.Value.start;
changedOutlineInfo.Key.Count = changedOutlineInfo.Value.count;
}
}
if (this.deletedOutlines != null)
{
foreach (var outline in this.deletedOutlines)
{
Worksheet.GroupRows(outline.Start, outline.Count);
}
}
#endif // OUTLINE
#endregion // Restore Outlines
#region Restore Named Range
// restore named ranges
//if (this.changedNamedRange != null)
//{
// foreach (var changedRangeInfo in this.changedNamedRange)
// {
// changedRangeInfo.Key.Row = changedRangeInfo.Value.start;
// changedRangeInfo.Key.Rows = changedRangeInfo.Value.count;
// }
//}
if (this.deletedNamedRanges != null)
{
foreach (var namedRange in this.deletedNamedRanges)
{
Worksheet.AddNamedRange(namedRange);
}
}
#endregion // Restore Named Range
#region Restore Highlight Ranges
// restore highlight ranges
//if (this.changedHighlightRanges != null)
//{
// foreach (var changedRangeInfo in this.changedHighlightRanges)
// {
// changedRangeInfo.Key.Row = changedRangeInfo.Value.start;
// changedRangeInfo.Key.Rows = changedRangeInfo.Value.count;
// }
//}
if (this.deletedHighlightRanges != null)
{
foreach (var range in this.deletedHighlightRanges)
{
Worksheet.AddHighlightRange(range);
}
}
#endregion // Restore Highlight Ranges
#if OUTLINE
if (this.changedOutlines != null && this.changedOutlines.Count > 0)
{
this.Worksheet.UpdateViewportController();
}
#endif // OUTLINE
}
