// Path: src/org/tiefaces/components/websheet/dataobjects/TieCommandAlias.java
// public class TieCommandAlias {
// 	
// /** The alias. */
// private String alias = null;
// 
// /** The command. */
// private String command = null;
// 
// /** The remove. */
// private boolean remove = false;
// 
// /** The pattern. */
// private Pattern pattern = null;
// 
// 
// /**
//  * Instantiates a new tie command alias.
//  *
//  * @param alias the alias
//  * @param command the command
//  */
// public TieCommandAlias(String alias, String command) {
// 	this.alias = alias;
// 	this.command = command;
// }
// 
// 
// /**
//  * Instantiates a new tie command alias.
//  *
//  * @param alias the alias
//  * @param command the command
//  * @param remove the remove
//  */
// public TieCommandAlias(String alias, String command, boolean remove) {
// 	this.alias = alias;
// 	this.command = command;
// 	this.remove = remove;
// }
// 
// /**
//  * Gets the alias.
//  *
//  * @return the alias
//  */
// public String getAlias() {
// 	return alias;
// }
// 
// /**
//  * Sets the alias.
//  *
//  * @param alias the new alias
//  */
// public void setAlias(String alias) {
// 	this.alias = alias;
// }
// 
// /**
//  * Gets the command.
//  *
//  * @return the command
//  */
// public String getCommand() {
// 	return command;
// }
// 
// /**
//  * Sets the command.
//  *
//  * @param command the new command
//  */
// public void setCommand(String command) {
// 	this.command = command;
// }
// 
// /**
//  * Checks if is removes the.
//  *
//  * @return true, if is removes the
//  */
// public boolean isRemove() {
// 	return remove;
// }
// 
// /**
//  * Sets the removes the.
//  *
//  * @param remove the new removes the
//  */
// public void setRemove(boolean remove) {
// 	this.remove = remove;
// }
// 
// 
// 
// /**
//  * Gets the pattern.
//  *
//  * @return the pattern
//  */
// public Pattern getPattern() {
// 	if ((this.pattern == null) && (alias != null)) {
// 		this.pattern = Pattern.compile("\\s*" + ParserUtility.wildcardToRegex(alias));
// 	}	
// 	return pattern;
// }
// 
// 
// 
// 
// }


import static org.junit.Assert.assertEquals;
import static org.junit.Assert.assertNull;
import java.util.ArrayList;
import java.util.List;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.junit.Test;
import org.tiefaces.components.websheet.dataobjects.TieCommandAlias;

    }

	@SuppressWarnings("resource")
	@Test
	public void testBuildSheetCommentFromAlias() throws Exception {

			
			Workbook wb = new XSSFWorkbook();
			// XSSFEvaluationWorkbook wbWrapper = XSSFEvaluationWorkbook
			// .create((XSSFWorkbook) wb);
			XSSFSheet sheet = (XSSFSheet) wb.createSheet("sheet1");
			// Create a row and put some cells in it. Rows are 0 based.
			XSSFRow row1 = sheet.createRow((short) 0);
			// Create a cell and put a value in it.
			Cell cell1 = row1.createCell(0);
			cell1.setCellValue("${employee.birthDate}");
			Cell cell2 = row1.createCell(1);
			cell2.setCellValue("${employee.birthdate}");
			Cell cell3 = row1.createCell(2);
			cell3.setCellValue("${employee.worktime} ${inputWorkTime}");
			Cell cell4 = row1.createCell(3);
			cell4.setCellValue("${employee.worktime}    ${inputWorkTime}");
			Cell cell5 = row1.createCell(4);
			cell5.setCellValue("${employee.worktime}${inputWorkTime}");
			
			List<TieCommandAlias> tieCommandAliasList = new ArrayList<>();
			
			String comment1 = "$widget.calendar{showOn=\"button\" pattern=\"yyyy/MM/dd\" readonlyInput=\"true\"}";
			String comment2 = "$widget.inputnumber{symbol=\" years\" symbolPosition=\"s\" minValue=\"0\" maxValue=\"999\" decimalPlaces=\"2\"}\r\n"; 


// Path: src/org/tiefaces/components/websheet/dataobjects/TieCommandAlias.java
// public class TieCommandAlias {
// 	
// /** The alias. */
// private String alias = null;
// 
// /** The command. */
// private String command = null;
// 
// /** The remove. */
// private boolean remove = false;
// 
// /** The pattern. */
// private Pattern pattern = null;
// 
// 
// /**
//  * Instantiates a new tie command alias.
//  *
//  * @param alias the alias
//  * @param command the command
//  */
// public TieCommandAlias(String alias, String command) {
// 	this.alias = alias;
// 	this.command = command;
// }
// 
// 
// /**
//  * Instantiates a new tie command alias.
//  *
//  * @param alias the alias
//  * @param command the command
//  * @param remove the remove
//  */
// public TieCommandAlias(String alias, String command, boolean remove) {
// 	this.alias = alias;
// 	this.command = command;
// 	this.remove = remove;
// }
// 
// /**
//  * Gets the alias.
//  *
//  * @return the alias
//  */
// public String getAlias() {
// 	return alias;
// }
// 
// /**
//  * Sets the alias.
//  *
//  * @param alias the new alias
//  */
// public void setAlias(String alias) {
// 	this.alias = alias;
// }
// 
// /**
//  * Gets the command.
//  *
//  * @return the command
//  */
// public String getCommand() {
// 	return command;
// }
// 
// /**
//  * Sets the command.
//  *
//  * @param command the new command
//  */
// public void setCommand(String command) {
// 	this.command = command;
// }
// 
// /**
//  * Checks if is removes the.
//  *
//  * @return true, if is removes the
//  */
// public boolean isRemove() {
// 	return remove;
// }
// 
// /**
//  * Sets the removes the.
//  *
//  * @param remove the new removes the
//  */
// public void setRemove(boolean remove) {
// 	this.remove = remove;
// }
// 
// 
// 
// /**
//  * Gets the pattern.
//  *
//  * @return the pattern
//  */
// public Pattern getPattern() {
// 	if ((this.pattern == null) && (alias != null)) {
// 		this.pattern = Pattern.compile("\\s*" + ParserUtility.wildcardToRegex(alias));
// 	}	
// 	return pattern;
// }
// 
// 
// 
// 
// }


// Path: tests/org/tiefaces/components/websheet/utility/ConfigurationUtilityTest.java
import static org.junit.Assert.assertEquals;
import static org.junit.Assert.assertNull;
import java.util.ArrayList;
import java.util.List;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.junit.Test;
import org.tiefaces.components.websheet.dataobjects.TieCommandAlias;

    }

	@SuppressWarnings("resource")
	@Test
	public void testBuildSheetCommentFromAlias() throws Exception {

			
			Workbook wb = new XSSFWorkbook();
			// XSSFEvaluationWorkbook wbWrapper = XSSFEvaluationWorkbook
			// .create((XSSFWorkbook) wb);
			XSSFSheet sheet = (XSSFSheet) wb.createSheet("sheet1");
			// Create a row and put some cells in it. Rows are 0 based.
			XSSFRow row1 = sheet.createRow((short) 0);
			// Create a cell and put a value in it.
			Cell cell1 = row1.createCell(0);
			cell1.setCellValue("${employee.birthDate}");
			Cell cell2 = row1.createCell(1);
			cell2.setCellValue("${employee.birthdate}");
			Cell cell3 = row1.createCell(2);
			cell3.setCellValue("${employee.worktime} ${inputWorkTime}");
			Cell cell4 = row1.createCell(3);
			cell4.setCellValue("${employee.worktime}    ${inputWorkTime}");
			Cell cell5 = row1.createCell(4);
			cell5.setCellValue("${employee.worktime}${inputWorkTime}");
			
			List<TieCommandAlias> tieCommandAliasList = new ArrayList<>();
			
			String comment1 = "$widget.calendar{showOn=\"button\" pattern=\"yyyy/MM/dd\" readonlyInput=\"true\"}";
			String comment2 = "$widget.inputnumber{symbol=\" years\" symbolPosition=\"s\" minValue=\"0\" maxValue=\"999\" decimalPlaces=\"2\"}\r\n"; 


			tieCommandAliasList.add(new TieCommandAlias("Date", comment1)); 
