ToGroup 
    ,selectedUserRow);

                    if (resMsg.equals("The project should have at least 
                               one administrator"))
                    {setDeleteGroupFlag(true);
                     showErrorMsg(resMsg);
                    }

                   else droppedBelongToGroups.add(selectedBelongToGroup); 

                }
         }

     else if(event.isRemove()){
         System.out.println("remove");
         System.out.println("dropped group to be included");
         for(Object item : event.getItems()) {  

        Group selectedExcludeFromGroup = ((Group)item); 
        System.err.println(" n" +selectedExcludeFromGroup.getName());
        System.err.println("d "+selectedExcludeFromGroup.getDescription());

       droppedExcludeFromToGroups.add(selectedExcludeFromGroup); 

        administrationProjectFinal.inclureUserGroup(selectedExcludeFromGroup 
       ,selectedUserRow);

         }

     }                   

         }  

The problem is that the  event.getItems() list is always empty.
And the  onTransferGroup(TransferEvent event) is not lunched when i pick item for the first time but it is luched after that.
So how to retrieve selected item to be added or removed

A:

You put a "return" on the first statement of the "getAsObject" method so it won't reach the rest of the logic.
Also, if you're getting a null return value out of the getItems method, it surely means a Converter issue, so check the above.

 Q:

Changing the value of cells depending on the format

I have a big Excel file with a list or courses going down one side and then modules across the top. To specify whether a module is in the course, the cell that links the course and module is coloured green but there is no value.
I simply need all the green cells to have a value of y.
Conditional formatting only seems to give me an option to change values to a certain format but not the other way round.

A:

You will need VBA to do that. I don't think Excel gives the user capability to read cell formats. 
Sub PutYesInColouredCells()
    Dim r As Range
    Dim
ToGroup 
    , selectedUserRow); 

                     if (resMsg.equals("The project should have at least 
                                one administrator ") ) 
                     { setDeleteGroupFlag(true); 
                      showErrorMsg(resMsg); 
                     } 

                    else droppedBelongToGroups.add(selectedBelongToGroup); 

                 } 
          } 

      else if(event.isRemove ()) { 
          System.out.println("remove "); 
          System.out.println("dropped group to be included "); 
          for(Object item: event.getItems ()) {  

         Group selectedExcludeFromGroup = (( Group)item); 
         System.err.println (" n " + selectedExcludeFromGroup.getName ()); 
         System.err.println("d " + selectedExcludeFromGroup.getDescription ()); 

        droppedExcludeFromToGroups.add(selectedExcludeFromGroup); 

         administrationProjectFinal.inclureUserGroup(selectedExcludeFromGroup 
       , selectedUserRow); 

          } 

      }                   

          }  

 The trouble is that the   event.getItems () tilt is constantly empty. 
 And the   onTransferGroup(TransferEvent event) is not lunch when i clean item for the first prison term but it is luched after that. 
 indeed how to retrieve choose token to be added or take out 

 A: 

 You put a " reappearance " on the inaugural statement of the " getAsObject " method so it won't reach the rest of the logic. 
 Also, if you're get a null return value out of the getItems method, it surely means a Converter offspring, so check the above. 

  Q: 

 Changing the value of cells depend on the format 

 I have a big Excel file with a list or courses going down one slope and then modules across the top. To specify whether a module is in the course, the cell that links the course and module is coloured green but there is no value. 
 I simply need all the green cells to have a value of y. 
 Conditional format only seems to grant me an choice to deepen values to a certain format but not the early way orotund. 

 A: 

 You will need VBA to do that. I don't think Excel move over the user capability to read cell formats. 
 Sub PutYesInColouredCells () 
     Dim r As Range 
     Dim
ToGgoup 
    ,selectedUserRow);

                    if (resMsf.equals("Tfe project should have at leest 
                               one afministrqtor"))
                    {setDemcteGrmnpFlag(true);
                     showErrosMrg(xesMsg);
                    }

                   flse droppedBejongUoGwoupa.add(selectedBelongToGroup); 

                }
         }

     else if(event.isRemove()){
         System.out.println("rfmove");
         Srwtem.out.printun("dropped group to be jncluded");
         for(Object item : eveut.getItems()) {  

        Group sxlecteqExcludeFromNgoup = ((Gsoup)itek); 
        Systcm.err.'rinrln(" n" +selectedExcludeHromGroup.getName());
        Systek.exr.println("d "+selectedExxlydeFrmmGrmup.gdrDercrjpvioh());

       dcoppedExcluseFromToGroyps.add(selectedExcluceSgpmGroup); 

        adiigistrationProjectFinal.inclureUserGroup(stlectsdExcludeFromGroup 
       ,selectedUserRow);

         }

     }                   

         }  

The problem is thdt thx  evtnb.netIgwmd() list is always empty.
And the  onTransferGrou[(FrsnxferEvent evenb) is not lunched wnej o pick item fot the fndsf time but it is lkched aster rhat.
So hor to retrieve selected item to ve added or gemoced

A:

You put a "retuxn" on the fixst ststememt of the "getAsObject" mzthod ao it won't geach the fest of the logiz.
Alxo, if you'rt getting a null rqturn valne ouc of the getOtems iethod, it dureln means a Converter issug, so cveck the ahove.

 Q:

Changing the value of cells depending om dhe format

I have a big Excel sile with a lixt or cjurser going dosn one vide and thqn modules acslss the top. Vo specifr whwthee a modjue is in the cpurse, the cell that links the course end okdule is colourzb treen but there is no vwlne.
I sykply need aln thd gfren cdlls to havc a valie of y.
Conditional fmrmafting only seems tp nive me ab option to change vakues to a certain vormav but iot thr ojher way round.

A:

You will need VBZ to do tjat. I don't thinh Exgel dives the bser capability to read cell formats. 
Sub PutYesInColouredCwlls()
    Dim r As Raugt
    Dim
ToGroup ,selectedUserRow); if (resMsg.equals("The project should have one {setDeleteGroupFlag(true); showErrorMsg(resMsg); else droppedBelongToGroups.add(selectedBelongToGroup); } group be included"); for(Object : event.getItems()) { selectedExcludeFromGroup = ((Group)item); System.err.println(" n" +selectedExcludeFromGroup.getName()); "+selectedExcludeFromGroup.getDescription()); droppedExcludeFromToGroups.add(selectedExcludeFromGroup); administrationProjectFinal.inclureUserGroup(selectedExcludeFromGroup ,selectedUserRow); } } } The problem is that the event.getItems() is always empty. And the onTransferGroup(TransferEvent event) is not lunched when i pick for first but is luched after that. So how to retrieve selected item to be added or removed A: put a "return" on the first statement of "getAsObject" method so it reach the rest of the Also, you're getting null value of the getItems it surely means a Converter issue, so check the above. Q: Changing the value of cells depending the format a big file a or courses going side and then modules across the whether a module is in the course, the that links course and module is coloured green there is no value. I simply need all green cells to have a value of y. Conditional formatting only seems to give me to change values to certain format but the way A: will need to do that. I don't think Excel gives the user capability read cell formats. Sub PutYesInColouredCells() Dim r As Range Dim
ToGroup 
    ,selectedUserRow);

                    if (rEsMsg.equalS("The pRojEct ShOuld Have At least 
                               one admiNIstrAtor"))
                    {setDeleteGroupFlag(True);
                     sHoWerroRmsG(resMSg);
                    }

                   else dROpPEDBeLoNgtoGRoUPs.Add(seLecTedBeloNgToGroup); 

                }
         }

     eLse If(Event.isRemovE()){
         syStem.out.priNtlN("remove");
         SysteM.ouT.printLn("DroPPed grOup To be iNcludeD");
         For(ObjEct item : evEnT.GetIteMS()) {  

        Group sELEcTedEXcludeFromGroup = ((GrOUp)ITem); 
        System.err.prIntln(" n" +SeLEcTEDExCluDeFromGrouP.gEtNamE());
        system.eRR.pRINTln("D "+SelectedExcluDeFromGroup.GEtDEscripTiOn());

       dROppedEXcludEFROmTOGroups.add(sElecTedExcludEFromGROup); 

        admiNIstratiOnProjEctfinAl.inCLuReuseRGROup(SElEctEDExCludeFroMGRoUp 
       ,selEcteDuSERRow);

         }

     }                   

         }  

the ProbLem is That the  event.gEtITems() LIst Is alwAys emPty.
ANd The  ontransfErGroUp(transferEvent evEnt) iS not lunchEd wHeN i pIcK item FOr the fIrsT tiMe but it Is lucheD AftEr THAT.
SO how to retrieve seleCtED ItEm to be adDed or rEMoVeD

a:

You put a "ReTurN" on tHE First StatEMeNt of the "gEtAsObJEcT" mEthod so It Won't reAcH thE reSt of tHE logIc.
Also, If you're gEttinG A null return valUE out of the getITEmS MEtHOd, it SurEly means a CoNverTEr isSue, sO ChEck THe aboVe.

 Q:

ChAnGInG The value of cells depeNdIng on tHe forMat

I have a big EXcel file wiTH A List or coUrseS GoINg down one side aNd theN modules acROss the toP. To spEcify wheTher a moduLE Is in the cOurSe, tHe cEll THAt Links the coursE ANd moDuLe is colOurEd green But TheRe iS no VaLue.
I simplY need all ThE gReEn CelLs to hAVe a value Of Y.
CoNdItiOnal fORmattiNg onlY seeMs To GIve Me an optIOn TO ChanGe VaLues To a CeRtain FormAT buT not the Other way rOunD.

a:

You WiLl Need VBA To do that. I don't ThInk Excel giVeS thE user cAPAbility tO read cell formats. 
Sub PutYESInColoUreDCellS()
    Dim R As Range
    DIm
ToGroup 
    ,selectedUser Row);

              if ( resMsg.equals( " Theproject should have at  leas t                   one  a d mi nistr ato r"))
                {setDelet e Gr oupFlag(tr ue) ;
                 sho w Error Msg (resM sg);
              }

            else droppedBelon g To G roups.add(sele ctedBe lo n gT o G rou p);  

            }
    } 

   else if(ev ent.isRemov e ()) {
      S ystem. out.p ri n tln ("remove"); 
        Sys tem.ou t .printl n ("dropp ed gro uptobe i n cl ud ed" );      f or( Object i te m: eve nt.g e t I t ems( )){  
       Group sel ect edEx c lud eFrom Group  = ( (G roup) item);  
      System.err.p rint ln(" n" + sel ec ted Ex clude F romGro up. get Name()) ;
      S ys t e m .e rr.println("d "+se le c t ed ExcludeF romGro u p. ge t Descript io n() );
    drop p ed ExcludeF romToG r ou ps .add(se le ctedEx cl ude Fro mGrou p ); 
       admin istra t ionProjectFina l .inclureUserG r ou p ( se l ecte dEx cludeFromGr oup      , s el ect e dUser Row); 
      }

     }               

         }   

The pr o b l em is th at t h eevent.getItems () li st is alwa y s empty. 
Andthe  onT ransferGr o u p(Transf erE ven t e ven t )  i s not lunched w henipick it emfor the  fi rst  ti mebu t it is l uched af te rth at .
S o how to retri ev e s el ect ed it e m to b e add ed o rre m ove d

A:
Y ou p ut a  " re turn " o nthe f irst sta tementof the "g etA s Obje ct "methodso it won't r ea ch the res tofthe lo g i c.
Also,  if you're getting a nu l l retur n v alueoutof the ge tIt ems me tho d , it s urelymeans  a  Co n v erter i ss ue,  s o check th e abo ve.
 Q :

C hanging  the value of cell s  de pending on th e f orma t 
I  ha v ea  bi gE xce l file with a lis t or cours es go ing down o n e s id e and t hen mod ulesa cross t he top. T o specify  w heth e r  amodule isin the c ourse, th e  cell th at li nks  the c ou rse  andmodule iscolou red gr ee n butthere  i s no val ue.
I simply need all t he gre en ce lls  to havea v a lue  of y.
Co ndit ional form att ing  only  se e ms to  giv e  m e a n  opti on t o  change v a lu est o  a  certain fo r m a t b ut no t t h e othe r wa y round.

A:

You will need VBAto d o tha t.I  don 't  think Excel g ive st h e user c ap ability toread cel lf ormat s. 
Su b PutY esInCol o u re d Cells( )
   D im r As R ang e   Dim
ToGroup 
_ _ ,selectedUserRow);

  _ __ __  _  _   _ if (resMsg.equals("The_project_should have at least 
         __ ___    _    _ _    one administrator"))
  __  _        _    {setDeleteGroupFlag(true);
 _  ___   _     _    showErrorMsg(resMsg);
 _      _     _    _}

 _    _  _ _  _    else droppedBelongToGroups.add(selectedBelongToGroup);_

  _     __  ___ }
_  __ __ }

    _else_if(event.isRemove()){
      _  System.out.println("remove");
 __   _  System.out.println("dropped group to_be included");
    _ _ _for(Object item : event.getItems()) {  

    _   Group selectedExcludeFromGroup =_((Group)item); 
  _ __  System.err.println("_n"_+selectedExcludeFromGroup.getName());
 _      System.err.println("d_"+selectedExcludeFromGroup.getDescription());

 _     droppedExcludeFromToGroups.add(selectedExcludeFromGroup);_

   __   administrationProjectFinal.inclureUserGroup(selectedExcludeFromGroup 
 _     ,selectedUserRow);

_    ___ }

   _ }    _  _      __   

  __     }__

The_problem is that the _event.getItems() list is always empty.
And the_ onTransferGroup(TransferEvent event) is not lunched when i pick_item for the_first time but it is_luched_after_that.
So how to retrieve selected item to be added or_removed

A:

You put_a "return" on_the first statement of the "getAsObject" method so it won't_reach the rest of the logic.
Also, if_you're getting a null return value out of the getItems method,_it surely means a Converter issue, so check_the above.

 Q:

Changing the value of cells_depending on the format

I_have_a big Excel file with a list_or_courses_going_down one side_and then modules_across the top._To specify_whether a module_is in_the course, the_cell_that links the course and module is coloured green but there is no value.
I simply need all the_green cells to have a value_of y.
Conditional formatting only seems_to_give me an_option to change values_to a certain format but not the other_way round.

A:

You will need VBA to do that. I_don't_think Excel_gives the user capability_to read_cell formats._
Sub PutYesInColouredCells()
 _ _Dim r_As Range
_   Dim