问独立的SpreadsheetApp.getActiveSheet()总是返回第一张纸

EN

function callActivateNewMember(){
   LibraryName.activateNewMember()
}


 this is the standalone SCRIPT A

 function activateNewMember(){
 // DECLARE THE CURRENT ACTIVE WORKSHEET as ssCentral
 var ssCentral = SpreadsheetApp.openById("xxxxxxxxxxxxxx");

 // check if TeamList sheet is active - if not land on Teamlist and ask to select a 
new member by his/her first name
 // goto and activate TeamList 
 var teamListSheet = ssCentral.getSheetByName('TEAM LIST');
 var teamListSheetIndex = teamListSheet.getIndex()-1;
 Logger.log('the teamListSheetIndex is ' + teamListSheetIndex);
 var currentSheet = SpreadsheetApp.getActiveSheet().getName();
 Logger.log('the currentSheet is ' + currentSheet);
 if(currentSheet !='TEAM LIST'){
   ssCentral.setActiveSheet(ssCentral.getSheets( 
  [teamListSheetIndex]).getRange('B5').activate();
  Logger.log('WRONG TABLE'); 
  return;
 }


 var teamListSheetLastRow = teamListSheet.getLastRow();
 var nberRows = teamListSheetLastRow-7


 // CHECK IF THE CELL IS IN THE FIRST COL AND IS NOT EMPTY
 // ------------------get the current row of the member selected
 var MemberRow  = ssCentral.getCurrentCell().getRow();
 var MemberCol  = ssCentral.getCurrentCell().getColumn();

 if(MemberRow <8 ||MemberCol>1 ){
   Logger.log('RIGHT TABLE - WRONG CELL SELECTED'); 
   return;
 }
 var memberCellValue = ssCentral.getCurrentCell().getValue(); 

 if(memberCellValue=='' ){
   Logger.log('CELL SELECTED EMPTY'); 
   return;
 }

 // VALIDATION : IS THIS MEMBER WAS ALREADY ACTIVATED
 //-----------get the column with “Reporting Activated” as header
 var repActiveCol = teamListSheet.getRange("D7").getColumn();

//-----------check if the cell of “Reporting Activated” is Y 
var checkY = teamListSheet.getRange(MemberRow, repActiveCol).getValue();
//-----------If checkY = “Y” then Alert OK
if (checkY == "Y") {
  Logger.log('MEMBER WAS ALREADY ACTIVATED'); 
  return;
}
// rest of the function
}