src/org/tiefaces/components/websheet/service/ValidationHandler.java
private boolean validateByTieWebSheetValidationBean(final Cell poiCell, final int topRow, final int leftCol,
			final FacesCell cell, final String value, boolean updateGui) {
		if (parent.getTieWebSheetValidationBean() != null) {
			String errormsg = null;
			String fullName = ConfigurationUtility.getFullNameFromRow(poiCell.getRow());
			String saveAttr = SaveAttrsUtility.prepareContextAndAttrsForCell(poiCell, fullName, parent.getCellHelper());
			if (saveAttr != null) {
				int row = poiCell.getRowIndex();
				int col = poiCell.getColumnIndex();
				errormsg = parent.getTieWebSheetValidationBean().validate(
						parent.getSerialDataContext().getDataContext(), saveAttr, ConfigurationUtility
								.getFullNameFromRow(poiCell.getRow()), poiCell.getSheet().getSheetName(),
						row, col, value);
				if ((errormsg != null) && (!errormsg.isEmpty())) {
					cell.setErrormsg(errormsg);
					refreshAfterStatusChanged(false, true, row - topRow, col - leftCol, cell, updateGui);
					return false;
				}
			}
		}
		return true;
	}
private boolean validateByTieWebSheetValidationBean(final Cell poiCell, final int topRow, final int leftCol,
			final FacesCell cell, final String value, boolean updateGui) {
		if (parent.getTieWebSheetValidationBean() != null) {
			String errormsg = null;
			String fullName = ConfigurationUtility.getFullNameFromRow(poiCell.getRow());
			String saveAttr = SaveAttrsUtility.prepareContextAndAttrsForCell(poiCell, fullName, parent.getCellHelper());
			if (saveAttr != null) {
				int row = poiCell.getRowIndex();
				int col = poiCell.getColumnIndex();
				errormsg = parent.getTieWebSheetValidationBean().validate(
						parent.getSerialDataContext().getDataContext(), saveAttr, ConfigurationUtility
								.getFullNameFromRow(poiCell.getRow()), poiCell.getSheet().getSheetName(),
						row, col, value);
				if ((errormsg != null) && (!errormsg.isEmpty())) {
					cell.setErrormsg(errormsg);
					refreshAfterStatusChanged(false, true, row - topRow, col - leftCol, cell, updateGui);
					return false;
				}
			}
		}
		return true;
	}
private boolean validateByTieWebSheetValidationBean ( final Cell poiCell , final int topRow , final int leftCol , final FacesCell cell , final String value , boolean updateGui ) { if ( parent . getTieWebSheetValidationBean ( ) != null ) { String errormsg = null ; String fullName = ConfigurationUtility . getFullNameFromRow ( poiCell . getRow ( ) ) ; String saveAttr = SaveAttrsUtility . prepareContextAndAttrsForCell ( poiCell , fullName , parent . getCellHelper ( ) ) ; if ( saveAttr != null ) { int row = poiCell . getRowIndex ( ) ; int col = poiCell . getColumnIndex ( ) ; errormsg = parent . getTieWebSheetValidationBean ( ) . validate ( parent . getSerialDataContext ( ) . getDataContext ( ) , saveAttr , ConfigurationUtility . getFullNameFromRow ( poiCell . getRow ( ) ) , poiCell . getSheet ( ) . getSheetName ( ) , row , col , value ) ; if ( ( errormsg != null ) && ( ! errormsg . isEmpty ( ) ) ) { cell . setErrormsg ( errormsg ) ; refreshAfterStatusChanged ( false , true , row - topRow , col - leftCol , cell , updateGui ) ; return false ; } } } return true ; }
Validate by tie web sheet validation bean.

@param poiCell the poi cell
@param topRow the top row
@param leftCol the left col
@param cell the cell
@param value the value
@param updateGui the update gui
@return true, if successful
Validate by tie web sheet validation bean .