void xlWorkSheet_Change(Excel.Range Target) { //Console.WriteLine("{0}:{1} -> {2}", Target.Row, Target.Column, Target.Value2.ToString()); //Console.WriteLine(Target.Count); //Called when a cell or cells on a worksheet are changed. Debug.WriteLine("Delegate: You Changed Cells " + Target.get_Address(Missing.Value, Missing.Value, Excel.XlReferenceStyle.xlA1, Missing.Value, Missing.Value) + " on " + Target.Worksheet.Name); }
public static void Change(Excel.Range target) { string address = target.get_Address((object) false, (object) false, Excel.XlReferenceStyle.xlA1, (object) false, Type.Missing); string key = Globals.Workbooks[(Excel.Workbook) target.Worksheet.Parent] + "." + Globals.Worksheets[(Excel.Worksheet) target.Parent] + "." + address; string formula = Globals.FixFormula((string) target.Formula); if(formula.StartsWith("CONSTRAIN")) { formula = formula.Substring(11, formula.Length - 13); formula = "CONSTRAIN(" + formula + ")"; } Globals.ConstraintSolver.Change(key, formula); }
protected string getSelectedRangeAddress(Excel.Range r) { return ((Excel.Worksheet)r.Parent).Name + "!" + r.get_Address(Type.Missing, Type.Missing, Excel.XlReferenceStyle.xlA1, Type.Missing, Type.Missing); }
private void CellsChange(Excel.Range Target) { //This is called when any cell on a worksheet is changed. Debug.WriteLine("Delegate: You Changed Cells " + Target.get_Address(Missing.Value, Missing.Value, Excel.XlReferenceStyle.xlA1, Missing.Value, Missing.Value) + " on " + Target.Worksheet.Name); }