package org.apache.poi.hssf.record.formula.functions;

import static org.junit.Assert.assertEquals;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.CellValue;
import org.apache.poi.ss.usermodel.FormulaEvaluator;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.junit.Test;

public class CountifTest {

	@Test
	public void testCountif() throws FileNotFoundException, IOException {
		final int REF_COL = 4;
		final int EVAL_COL = 3;
		Workbook workbook = new HSSFWorkbook(new FileInputStream(
				"test//resources//countif.xls"));
		FormulaEvaluator evaluator = workbook.getCreationHelper()
				.createFormulaEvaluator();
		Sheet sheet = workbook.getSheetAt(0);
		for (int i = 0; i < 8; i++) {
			CellValue expected = evaluator.evaluate(sheet.getRow(i).getCell(REF_COL));
			CellValue actual = evaluator.evaluate(sheet.getRow(i).getCell(EVAL_COL));
			assertEquals(expected.formatAsString(), actual.formatAsString());
		}
	}
}