EDIT

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.Arrays;

import com.vaadin.data.Item;

import com.vaadin.data.Property;

import com.vaadin.ui.ListSelect;

import com.vaadin.ui.VerticalLayout;

import eu.etaxonomy.cdm.hibernate.HibernateProxyHelper;

import eu.etaxonomy.cdm.model.common.CdmBase;

import eu.etaxonomy.cdm.model.common.Representation;

import eu.etaxonomy.cdm.model.description.PresenceAbsenceTerm;

import eu.etaxonomy.cdm.vaadin.util.CdmQueryFactory;

		// table + formatting

		table = new Table(){

			private static final long serialVersionUID = -5148756917468804385L;

			@Override

			protected String formatPropertyValue(Object rowId, Object colId, Property<?> property) {

				String formattedValue = null;

				PresenceAbsenceTerm presenceAbsenceTerm = null;

				Object value = property.getValue();

				if(value instanceof String){

                    try {

                        presenceAbsenceTerm = (PresenceAbsenceTerm)CdmSpringContextHelper.getTermService().load(UUID.fromString((String)value));

                    }catch(IllegalArgumentException|ClassCastException e) {

                        // Not a PresenceAbsenceTerm Column

                    }

				}

				if(presenceAbsenceTerm != null){

					Representation representation = presenceAbsenceTerm.getRepresentation(Language.DEFAULT());

					if(representation!=null){

						if(DistributionEditorUtil.isAbbreviatedLabels()){

							formattedValue = representation.getAbbreviatedLabel();

						}

						else{

							formattedValue = representation.getLabel();

						}

					}

					if(formattedValue==null){

						formattedValue = presenceAbsenceTerm.getTitleCache();

					}

					return formattedValue;

				}

				return super.formatPropertyValue(rowId, colId, property);

			}

		};

		table.setImmediate(false);

		table.setWidth("100.0%");

		table.setHeight("100.0%");

        table.setColumnReorderingAllowed(true);

        table.setSortEnabled(false);

        table.setColumnCollapsingAllowed(true);

        table.setSelectable(true);

        table.setPageLength(20);

        table.setFooterVisible(true);

        table.setCacheRate(20);

		table.addItemClickListener(event -> {

            if(!(event.getPropertyId().toString().equalsIgnoreCase(CdmQueryFactory.TAXON_COLUMN))

            		&& !(event.getPropertyId().toString().equalsIgnoreCase(CdmQueryFactory.RANK_COLUMN))

            		// TODO: HACK FOR RL 2017, REMOVE AS SOON AS POSSIBLE

            		&& !(event.getPropertyId().toString().equalsIgnoreCase("DE"))

            		&& !(event.getPropertyId().toString().equalsIgnoreCase("Deutschland"))){

                final Item item = event.getItem();

                Property<?> itemProperty = item.getItemProperty("uuid");

                UUID uuid = UUID.fromString(itemProperty.getValue().toString());

                final Taxon taxon = CdmBase.deproxy(CdmSpringContextHelper.getTaxonService()

                		.load(uuid,Arrays.asList("descriptions.descriptionElements","name.taxonBases","updatedBy")), Taxon.class);

                final String areaID = (String)event.getPropertyId();

                PresenceAbsenceTerm presenceAbsenceTerm = null;

                Object statusValue = item.getItemProperty(areaID).getValue();

                if(statusValue instanceof String){

                    try {

                        presenceAbsenceTerm = (PresenceAbsenceTerm)CdmSpringContextHelper.getTermService().load(UUID.fromString((String)statusValue));

                    }catch(IllegalArgumentException|ClassCastException e) {

                        // Not a PresenceAbsenceTerm Column

                    }

                }

                //popup window

                final Window popup = new Window("Choose distribution status");

                final ListSelect termSelect = new ListSelect();

                termSelect.setSizeFull();

                termSelect.setContainerDataSource(getPresenter().getPresenceAbsenceTermContainer());

                termSelect.setNullSelectionAllowed(presenceAbsenceTerm != null);

                if(presenceAbsenceTerm != null){

                	termSelect.setNullSelectionItemId("[no status]");

                }else{

                    logger.debug("No distribution status exists yet for area");

                }

                termSelect.setValue(presenceAbsenceTerm);

                termSelect.addValueChangeListener(valueChangeEvent -> {

						Object distributionStatus = valueChangeEvent.getProperty().getValue();

						getPresenter().updateDistributionField(areaID, distributionStatus, taxon);

						container.refresh();

						popup.close();

				});

                VerticalLayout layout = new VerticalLayout(termSelect);

                popup.setContent(layout);

                popup.setModal(true);

                popup.center();

                UI.getCurrent().addWindow(popup);

            }

        });

		mainLayout.addComponent(table, "top:75px;right:10.0px;left:10.0px;");

//		grid = new Grid();

//		grid.setSizeFull();

//		grid.setEditorEnabled(true);

//      grid.setFooterVisible(true);

//		mainLayout.addComponent(grid, "top:75px;right:10.0px;left:10.0px;"); //$NON-NLS-1$

		try {

			container = getPresenter().getSQLContainer();

		} catch (SQLException e) {

			DistributionEditorUtil.showSqlError(e);

			return;

		}

		if(container==null){

			return;

		}

		table.setContainerDataSource(container);

		List<String> columnHeaders = new ArrayList<>(Arrays.asList(table.getColumnHeaders()));

		columnHeaders.remove(CdmQueryFactory.DTYPE_COLUMN);

		columnHeaders.remove(CdmQueryFactory.ID_COLUMN);

		columnHeaders.remove(CdmQueryFactory.UUID_COLUMN);

		columnHeaders.remove(CdmQueryFactory.CLASSIFICATION_COLUMN);

		List<String> columnList = new ArrayList<>(columnHeaders);

		String[] string = new String[columnList.size()];

		table.setVisibleColumns(columnList.toArray());

		table.setColumnHeaders(columnList.toArray(string));

		table.setColumnFooter(CdmQueryFactory.TAXON_COLUMN, "Total amount of Taxa displayed: " + container.size());

//        gridcontainer = getPresenter().getAreaDistributionStatusContainer();

//        if(gridcontainer==null){

//            return;

//        }

//

//        if(footerRow != null) {

//            grid.removeFooterRow(footerRow);

//        }

//		grid.removeAllColumns();

//

//        grid.setContainerDataSource(gridcontainer);

//

//        Column uuidColumn = grid.getColumn(DistributionStatusQuery.UUID_COLUMN);

//        uuidColumn.setEditable(false);

//        uuidColumn.setHidden(true);

//        Column taxonColumn = grid.getColumn(DistributionStatusQuery.TAXON_COLUMN);

//        taxonColumn.setEditable(false);

//        taxonColumn.setHeaderCaption(Messages.DistributionTableViewBean_TAXON);

//        taxonColumn.setLastFrozenColumn();

//

//        Converter<String, UUID> displayConverter = new PresenceAbsenceTermUuidTitleStringConverter();

//        Converter<Object, UUID> editorConverter = new PresenceAbsenceTermUuidObjectConverter();

//        for(Column c : grid.getColumns()) {

//            if(c.isEditable()) {

//                NamedArea namedArea = (NamedArea) CdmSpringContextHelper.getTermService().load((UUID.fromString(c.getHeaderCaption())));

//                String caption = DistributionEditorUtil.isAbbreviatedLabels() ?

//                        namedArea.getRepresentation(Language.DEFAULT()).getAbbreviatedLabel() : namedArea.getTitleCache();

//                c.setHeaderCaption(caption);

//                c.setConverter(displayConverter);

//

//                NativeSelect termSelect = new NativeSelect();

//                termSelect.setSizeFull();

//                termSelect.setContainerDataSource(getPresenter().getPresenceAbsenceTermContainer());

//                termSelect.setItemCaptionMode(ItemCaptionMode.PROPERTY);

//                termSelect.setItemCaptionPropertyId("titleCache"); //$NON-NLS-1$

//                termSelect.setConverter(editorConverter);

//                termSelect.setImmediate(true);

//                c.setEditorField(termSelect);

//            }

//        }

//        grid.getEditorFieldGroup().addCommitHandler(new CommitHandler() {

//            private static final long serialVersionUID = 7515807188410712420L;

//

//            @Override

//            public void preCommit(CommitEvent commitEvent) throws CommitException {

//

//            }

//

//            @Override

//            public void postCommit(CommitEvent commitEvent) throws CommitException {

//                gridcontainer.commit();

//            }

//        });

//

//        footerRow = grid.appendFooterRow();

//        Object[] cells = grid.getColumns().stream().map(c -> c.getPropertyId()).toArray(Object[]::new);

//        if(cells.length == 0) {

//            return;

//        }

//        FooterCell footerCell = null;

//        if(cells.length > 1) {

//            footerCell = footerRow.join(cells);

//        }else {

//            footerCell = footerRow.getCell(cells[0]);

//        }

//        footerCell.setText(String.format(Messages.DistributionTableViewBean_TOTAL_TAXA, gridcontainer.size()));

				Object selectedItemId = DistributionTableViewBean.this.table.getValue();

//				Object selectedItemId = DistributionTableViewBean.this.grid.getSelectedRow();

				    final UUID uuid = UUID.fromString(table.getContainerDataSource().getItem(selectedItemId).getItemProperty("uuid").getValue().toString());

//					final UUID uuid = (UUID) selectedItemId;

					Taxon taxon = HibernateProxyHelper.deproxy(CdmSpringContextHelper.getTaxonService().load(uuid), Taxon.class);

//					Taxon taxon = (Taxon) CdmSpringContextHelper.getTaxonService().load(uuid);