private void btnEdit_Click(object sender, EventArgs e)
{
if (this.lstRanges.SelectedItems.Count > 0)
{
var item = this.lstRanges.SelectedItems[0];
var range = item.Tag as NamedRange;
if (range != null)
{
using (var dlg = new DefineNamedRangeDialog())
{
dlg.RangeName = range.Name;
dlg.Range = range;
if (dlg.ShowDialog(this) == System.Windows.Forms.DialogResult.OK)
{
range.Name = dlg.RangeName;
range.Comment = dlg.Comment;
range.Position = dlg.Range;
item.Text = dlg.RangeName;
item.SubItems[1].Text = dlg.Range.ToAddress();
this.grid.CurrentWorksheet.SelectionRange = range;
if (range.Worksheet == this.grid.CurrentWorksheet)
{
this.grid.CurrentWorksheet.SelectionRange = range;
}
}
}
}
}
}
private void btnNew_Click(object sender, EventArgs e)
{
using (var dlg = new DefineNamedRangeDialog())
{
if (dlg.ShowDialog(this) == System.Windows.Forms.DialogResult.OK)
{
NamedRange range = DefineNamedRange(this, this.grid.CurrentWorksheet,
dlg.RangeName, dlg.Comment, dlg.Range);
if (range != null)
{
lstRanges.Items.Add(new ListViewItem(new string[] { range.Name, range.Position.ToAddress() })
{
Tag = range
});
if (range.Worksheet == this.grid.CurrentWorksheet)
{
this.grid.CurrentWorksheet.SelectionRange = range;
}
}
}
}
}