public static void NewWorksheet(object book, object sheet)
{
Excel.Worksheet ws = (Excel.Worksheet) sheet;
Globals.Worksheets.Add(ws);
ws.Change += new Excel.DocEvents_ChangeEventHandler(ChangeWatcher.Change);
DeactivateSheetWatcher deactivateWatcher = new DeactivateSheetWatcher(ws);
ws.Deactivate += new Excel.DocEvents_DeactivateEventHandler(deactivateWatcher.Deactivate);
Excel.Range constrainedCell = ws.Cells.Find("CONSTRAIN", Type.Missing, Excel.XlFindLookIn.xlFormulas, Excel.XlLookAt.xlPart, Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlNext, true, Type.Missing, Type.Missing);
Excel.Range firstFind = constrainedCell;
while(constrainedCell != null) {
constrainedCell.Calculate();
System.Windows.Forms.MessageBox.Show("Inside the loop!");
constrainedCell = ws.Cells.FindNext(constrainedCell);
if(constrainedCell.get_Address(Type.Missing, Type.Missing, Excel.XlReferenceStyle.xlA1, Type.Missing, Type.Missing) ==
firstFind.get_Address(Type.Missing, Type.Missing, Excel.XlReferenceStyle.xlA1, Type.Missing, Type.Missing)) {
break;
}
}
}
public static void NewWorksheet(object book, object sheet)
{
Excel.Worksheet ws = (Excel.Worksheet)sheet;
Globals.Worksheets.Add(ws);
ws.Change += new Excel.DocEvents_ChangeEventHandler(ChangeWatcher.Change);
DeactivateSheetWatcher deactivateWatcher = new DeactivateSheetWatcher(ws);
ws.Deactivate += new Excel.DocEvents_DeactivateEventHandler(deactivateWatcher.Deactivate);
Excel.Range constrainedCell = ws.Cells.Find("CONSTRAIN", Type.Missing, Excel.XlFindLookIn.xlFormulas, Excel.XlLookAt.xlPart, Excel.XlSearchOrder.xlByRows, Excel.XlSearchDirection.xlNext, true, Type.Missing, Type.Missing);
Excel.Range firstFind = constrainedCell;
while (constrainedCell != null)
{
constrainedCell.Calculate();
System.Windows.Forms.MessageBox.Show("Inside the loop!");
constrainedCell = ws.Cells.FindNext(constrainedCell);
if (constrainedCell.get_Address(Type.Missing, Type.Missing, Excel.XlReferenceStyle.xlA1, Type.Missing, Type.Missing) ==
firstFind.get_Address(Type.Missing, Type.Missing, Excel.XlReferenceStyle.xlA1, Type.Missing, Type.Missing))
{
break;
}
}
}
