void Worksheet_Change(object sh) { Ribbon1 ribbon = Globals.Ribbons.Ribbon1; ribbon.buttonStates(); ribbon.removeInexistentWorksheet(); }
void Application_SheetChange(object Sh, Excel.Range target) { Ribbon1 ribbon = Globals.Ribbons.Ribbon1; int row = target.Row; int column = target.Column; String newValue = ribbon.getCellType(row, column); String address = target.Address; string[] cellArray = address.Split('$'); String key = cellArray[1] + cellArray[2]; Boolean hasFormula = target.HasFormula; ribbon.cellChanged(newValue, key, row, column, hasFormula); }
void Application_WorkbookOpen(Excel.Workbook Wb) { Ribbon1 ribbon = Globals.Ribbons.Ribbon1; if (getWorksheet("WorkQWERTY10745TY") == null) { createNewWorksheet(); } getWorksheet("WorkQWERTY10745TY").Visible = Excel.XlSheetVisibility.xlSheetVeryHidden; //ver se o ficheiro temp para se ler existe //se existir ler (fazer o import) ribbon.initializeAllWorksheets(); ribbon.importTemporaryXMLFile(); }
void Application_SheetSelectionChange(object Sh, Excel.Range target) { Ribbon1 ribbon = Globals.Ribbons.Ribbon1; ribbon.buttonStates(); }