private void namedRangeEditor_Click(object sender, EventArgs e)
{
GridFormulaEngine engine = ((GridFormulaCellModel)grid.Model.CellModels["FormulaCell"]).Engine;
GridFormulaNamedRangesEditerHelper.ShowNamedRangesDialog(engine);
}
/// <summary>
/// Displays a collection editor dialog for editing NamedRanges.
/// </summary>
/// <param name="engine">The GridFormulaEngine instance whose NamedRanges are being edited.</param>
public static void ShowNamedRangesDialog(GridFormulaEngine engine)
{
GridFormulaNamedRangesEditerHelper editHelper = new GridFormulaNamedRangesEditerHelper(engine);
CollectionEditor editor1 = new CollectionEditor(typeof(NamedRangeList));
WindowsFormsEditorServiceContainer esc = new WindowsFormsEditorServiceContainer(null);
////Subscribe to the event to change Dialog settings.
esc.ShowingDialog += new ControlEventHandler(ServiceContainerShowingDialog);
PropertyDescriptor pd = TypeDescriptor.GetProperties(editHelper)["List"];
TypeDescriptorContext tdc = new TypeDescriptorContext(editHelper, pd);
tdc.ServiceProvider = esc;
GridFormulaNamedRangesEditerHelper.NamedRangeList oldList = pd.GetValue(editHelper) as GridFormulaNamedRangesEditerHelper.NamedRangeList;
GridFormulaNamedRangesEditerHelper.NamedRangeList newList = editor1.EditValue(tdc, esc, oldList) as GridFormulaNamedRangesEditerHelper.NamedRangeList;
esc.ShowingDialog -= new ControlEventHandler(ServiceContainerShowingDialog);
if (newList != null && esc.DialogResult == DialogResult.OK)
{
ArrayList needUpdating = new ArrayList();
ArrayList needDeleting = new ArrayList();
Hashtable namedRanges = (Hashtable)engine.NamedRanges.Clone();
List <string> lst = new List <string>();
foreach (string key in namedRanges.Keys)
{
lst.Add(key);
}
lst.Sort();
engine.NamedRanges.Clear();
engine.NamedRangesOriginalNames.Clear();
int i = 0;
foreach (NamedRange range in newList)
{
string s = range.Key.ToUpper(CultureInfo.InvariantCulture);
if (namedRanges.Contains(range.Key) && !string.IsNullOrEmpty(range.Key) && namedRanges[lst[i]].Equals(range.Value))
{
engine.AddNamedRange(range.Key, range.Value);
}
else if (namedRanges.Contains(range.Key) && !string.IsNullOrEmpty(range.Key))
{
engine.AddNamedRange(range.Key, namedRanges[lst[i]].ToString());
}
else if (!namedRanges.Contains(range.Key) && !string.IsNullOrEmpty(range.Key) && !namedRanges.ContainsKey(range.Key))
{
engine.AddNamedRange(range.Key, range.Value);
}
if (namedRanges.ContainsKey(s))
{
if (namedRanges[s].Equals(range.Value))
{
needUpdating.Add(s);
}
}
i++;
}
foreach (string key in namedRanges.Keys)
{
if (!engine.NamedRanges.ContainsKey(key))
{
needDeleting.Add(key);
}
}
if (needDeleting.Count > 0 || needUpdating.Count > 0)
{
foreach (string s in needUpdating)
{
engine.UpdateDependentNamedRangeCell(s);
////Console.WriteLine("changed: " + s);
}
foreach (string s in needDeleting)
{
if (engine.NamedRanges.ContainsKey(s))
{
engine.UpdateDependentNamedRangeCell(s);
engine.RemoveNamedRangeDependency(s);
////Console.WriteLine("deleted: " + s);
}
}
}
engine.AdjustNameRangesForSize();
}
}
