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