public void ChangeCellEventHandler(Range Target) { ExcelSheetInfo currentsheet = appData.eSheetsInfomation.getCurrentSheet(); if (appData.eSheetsInfomation.getCurrentSheet() == null || appData.eSheetsInfomation.getCurrentSheet().ignoreChangeEvent) { return; } if (Target.Column == ExcelColumsDefinition.SCHEMANAMEEXCELCOL + 1 && appData.eSheetsInfomation.getCurrentSheet().sheetType == ExcelSheetInfo.ExcelSheetType.attribute) { Utils.unprotectSheet(currentsheet); currentsheet.excelsheet.Cells[ExcelColumsDefinition.HEADERCOL + 1][Target.Row] = Target.Text == string.Empty ? string.Empty : string.Format("New Field : {0}", Target.Text); Utils.protectSheet(currentsheet); } if (Target.Column == ExcelColumsDefinition.SCHEMANAMEEXCELCOL + 1 && appData.eSheetsInfomation.getCurrentSheet().sheetType == ExcelSheetInfo.ExcelSheetType.entity) { Utils.unprotectSheet(currentsheet); currentsheet.excelsheet.Cells[ExcelColumsDefinition.HEADERCOL + 1][Target.Row] = Target.Text == string.Empty ? string.Empty : string.Format("New entity : {0}", Target.Text); Utils.protectSheet(currentsheet); } if (Target.Column == ExcelColumsDefinition.ATTRIBUTETYPEEXCELCOL + 1 && appData.eSheetsInfomation.getCurrentSheet() != null && Target.Row > ExcelColumsDefinition.FIRSTROW) { Utils.unprotectSheet(currentsheet); excellData.changeCellsColorOnTypeChange(Target, true); Utils.protectSheet(currentsheet); } if ((Target.Column == ExcelColumsDefinition.SCHEMANAMEEXCELCOL + 1 || Target.Column == ExcelColumsDefinition.ATTRIBUTETYPEEXCELCOL + 1 || Target.Column == ExcelColumsDefinition.LOOKUPTARGET + 1) && appData.eSheetsInfomation.getCurrentSheet().sheetType == ExcelSheetInfo.ExcelSheetType.attribute && currentsheet.excelsheet.Cells[Target.Row, ExcelColumsDefinition.ATTRIBUTETYPEEXCELCOL + 1].Text == "Lookup") { Utils.unprotectSheet(currentsheet); String lookUpAttributeName = string.Format("{0}_{1}_{2}_{3}", currentsheet.orgPrefix, currentsheet.excelsheet.Cells[Target.Row, ExcelColumsDefinition.LOOKUPTARGET + 1].Text, currentsheet.objectName, Utils.removeOrgPrefix(currentsheet.excelsheet.Cells[Target.Row, ExcelColumsDefinition.SCHEMANAMEEXCELCOL + 1].Text, currentsheet.objectName)); currentsheet.excelsheet.Cells[Target.Row, ExcelColumsDefinition.LOOKUPRELATIONSHIPNAME + 1] = lookUpAttributeName; Utils.protectSheet(currentsheet); } if ((Target.Column == ExcelColumsDefinition.VIEWATTRIBUTEENTITY + 1) && appData.eSheetsInfomation.getCurrentSheet().sheetType == ExcelSheetInfo.ExcelSheetType.view) { Utils.unprotectSheet(currentsheet); excellData.ShowRelatedAttributes(Target); Utils.protectSheet(currentsheet); } }