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(); } }