FormulaDisplayConverterTest.java example

Explorer
nebula.widgets.nattable-master
/*****************************************************************************
 * Copyright (c) 2015 CEA LIST.
 *
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the Eclipse Public License v1.0
 * which accompanies this distribution, and is available at
 * http://www.eclipse.org/legal/epl-v10.html
 *
 * Contributors:
 *      Dirk Fauth <dirk.fauth@googlemail.com> - Initial API and implementation
 *
 *****************************************************************************/
package org.eclipse.nebula.widgets.nattable.formula;

import static org.junit.Assert.assertEquals;

import java.text.DecimalFormat;
import java.util.Locale;

import org.eclipse.nebula.widgets.nattable.config.ConfigRegistry;
import org.eclipse.nebula.widgets.nattable.data.IDataProvider;
import org.eclipse.nebula.widgets.nattable.layer.DataLayer;
import org.junit.Test;

public class FormulaDisplayConverterTest {

    IDataProvider dataProvider = new TwoDimensionalArrayDataProvider(new String[10][10]);
    FormulaDataProvider formulaDataProvider = new FormulaDataProvider(this.dataProvider);

    FormulaResultDisplayConverter resultConverter = new FormulaResultDisplayConverter(this.formulaDataProvider);
    FormulaEditDisplayConverter editConverter = new FormulaEditDisplayConverter(this.formulaDataProvider);

    @Test
    public void shouldConvertFormulaResult() {
        this.formulaDataProvider.getFormulaParser().setDecimalFormat((DecimalFormat) DecimalFormat.getInstance(Locale.ENGLISH));

        this.dataProvider.setDataValue(0, 0, "5.3");
        this.dataProvider.setDataValue(1, 0, "3.2");
        this.dataProvider.setDataValue(2, 0, "=A1+B1");

        assertEquals("8.5", this.resultConverter.canonicalToDisplayValue(this.formulaDataProvider.getDataValue(2, 0)));

        this.dataProvider.setDataValue(0, 0, "5.3");
        this.dataProvider.setDataValue(1, 0, "2");
        this.dataProvider.setDataValue(2, 0, "=A1*B1");

        assertEquals("10.6", this.resultConverter.canonicalToDisplayValue(this.formulaDataProvider.getDataValue(2, 0)));
    }

    @Test
    public void shouldConvertFormulaResultLocalized() {
        this.formulaDataProvider.getFormulaParser().setDecimalFormat((DecimalFormat) DecimalFormat.getInstance(Locale.GERMAN));

        this.dataProvider.setDataValue(0, 0, "5,3");
        this.dataProvider.setDataValue(1, 0, "3,2");
        this.dataProvider.setDataValue(2, 0, "=A1+B1");

        assertEquals("8,5", this.resultConverter.canonicalToDisplayValue(this.formulaDataProvider.getDataValue(2, 0)));

        this.dataProvider.setDataValue(0, 0, "5,3");
        this.dataProvider.setDataValue(1, 0, "2");
        this.dataProvider.setDataValue(2, 0, "=A1*B1");

        assertEquals("10,6", this.resultConverter.canonicalToDisplayValue(this.formulaDataProvider.getDataValue(2, 0)));
    }

    @Test
    public void shouldConvertToNativeFormulaResult() {
        this.formulaDataProvider.getFormulaParser().setDecimalFormat((DecimalFormat) DecimalFormat.getInstance(Locale.ENGLISH));

        this.dataProvider.setDataValue(0, 0, "5.3");
        this.dataProvider.setDataValue(1, 0, "3.2");
        this.dataProvider.setDataValue(2, 0, "=A1+B1");

        DataLayer dataLayer = new DataLayer(this.formulaDataProvider);
        ConfigRegistry configRegistry = new ConfigRegistry();

        assertEquals("=A1+B1", this.editConverter.canonicalToDisplayValue(
                dataLayer.getCellByPosition(2, 0), configRegistry, this.formulaDataProvider.getDataValue(2, 0)));

        this.dataProvider.setDataValue(0, 0, "5.3");
        this.dataProvider.setDataValue(1, 0, "2");
        this.dataProvider.setDataValue(2, 0, "=A1*B1");

        assertEquals("=A1*B1", this.editConverter.canonicalToDisplayValue(
                dataLayer.getCellByPosition(2, 0), configRegistry, this.formulaDataProvider.getDataValue(2, 0)));
    }
}