org.netxilia.spi.impl.formula.TestCellCommands.java Source code

Introduction

Here is the source code for org.netxilia.spi.impl.formula.TestCellCommands.java

Source

/*******************************************************************************
 * 
 * Copyright 2010 Alexandru Craciun, and individual contributors as indicated
 * by the @authors tag. 
 * 
 * This is free software; you can redistribute it and/or modify it
 * under the terms of the GNU Lesser General Public License as
 * published by the Free Software Foundation; either version 3 of
 * the License, or (at your option) any later version.
 * 
 * This software is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
 * Lesser General Public License for more details.
 * 
 * You should have received a copy of the GNU Lesser General Public
 * License along with this software; if not, write to the Free
 * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
 * 02110-1301 USA, or see the FSF site: http://www.fsf.org.
 ******************************************************************************/
package org.netxilia.spi.impl.formula;

import junit.framework.Assert;

import org.junit.Before;
import org.junit.Test;
import org.netxilia.api.command.IMoreCellCommands;
import org.netxilia.api.exception.AlreadyExistsException;
import org.netxilia.api.exception.NetxiliaBusinessException;
import org.netxilia.api.exception.NetxiliaResourceException;
import org.netxilia.api.exception.NotFoundException;
import org.netxilia.api.exception.StorageException;
import org.netxilia.api.formula.Formula;
import org.netxilia.api.impl.NetxiliaSystemImpl;
import org.netxilia.api.model.CellData;
import org.netxilia.api.model.ISheet;
import org.netxilia.api.reference.AreaReference;
import org.netxilia.api.reference.CellReference;
import org.netxilia.api.user.AclPrivilegedMode;
import org.netxilia.spi.impl.structure.NoCheckAclServiceImpl;
import org.netxilia.spi.impl.structure.SheetUtils;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

public class TestCellCommands {
    private IMoreCellCommands cellCommands;

    @Before
    public void startup() throws AlreadyExistsException, StorageException, NotFoundException {
        ApplicationContext context = new ClassPathXmlApplicationContext("classpath:test-domain-services.xml");
        NetxiliaSystemImpl nx = context.getBean(NetxiliaSystemImpl.class);
        nx.setAclService(new NoCheckAclServiceImpl());
        cellCommands = context.getBean(IMoreCellCommands.class);
        AclPrivilegedMode.set();
    }

    @Test
    public void testCopyContent() throws NetxiliaResourceException, NetxiliaBusinessException {
        ISheet sheet = SheetUtils.sheetWithCell();

        CellData data = new CellData(new CellReference("A1"), new Formula("=B1 + 10"));
        sheet.sendCommand(cellCommands.copyContent(new AreaReference("C2:C3"), data));

        CellData newData = sheet.receiveCell(new CellReference("C2")).getNonBlocking();
        Assert.assertNotNull(newData);
        Assert.assertEquals(new Formula("=D2 + 10"), newData.getFormula());

        CellData newData2 = sheet.receiveCell(new CellReference("C3")).getNonBlocking();
        Assert.assertNotNull(newData2);
        Assert.assertEquals(new Formula("=D3 + 10"), newData2.getFormula());
    }

    @Test
    public void testPasteFromCell() throws NetxiliaResourceException, NetxiliaBusinessException {
        ISheet sheet = SheetUtils.sheetWithCell();

        String[][] data = { { "=B1 + 10", "100" }, { "true", "=$B$2 + 100" } };
        sheet.sendCommand(cellCommands.paste(new AreaReference("C2:D3"), data, new CellReference("A1")));

        CellData newDataC2 = sheet.receiveCell(new CellReference("C2")).getNonBlocking();
        Assert.assertNotNull(newDataC2);
        Assert.assertEquals(new Formula("=D2 + 10"), newDataC2.getFormula());

        CellData newDataC3 = sheet.receiveCell(new CellReference("C3")).getNonBlocking();
        Assert.assertNotNull(newDataC3);
        Assert.assertEquals(true, newDataC3.getValue().getBooleanValue().booleanValue());

        CellData newDataD2 = sheet.receiveCell(new CellReference("D2")).getNonBlocking();
        Assert.assertNotNull(newDataD2);
        Assert.assertEquals(100.0, newDataD2.getValue().getNumberValue());

        CellData newDataD3 = sheet.receiveCell(new CellReference("D3")).getNonBlocking();
        Assert.assertNotNull(newDataD3);
        Assert.assertEquals(new Formula("=$B$2 + 100"), newDataD3.getFormula());
    }

    @Test
    public void testPasteNoCell() throws NetxiliaResourceException, NetxiliaBusinessException {
        ISheet sheet = SheetUtils.sheetWithCell();

        String[][] data = { { "=B1 + 10", "100" }, { "true", "=$B$2 + 100" } };
        sheet.sendCommand(cellCommands.paste(new AreaReference("C2:D3"), data, null));

        CellData newDataC2 = sheet.receiveCell(new CellReference("C2")).getNonBlocking();
        Assert.assertNotNull(newDataC2);
        Assert.assertEquals(new Formula("=B1 + 10"), newDataC2.getFormula());

        CellData newDataC3 = sheet.receiveCell(new CellReference("C3")).getNonBlocking();
        Assert.assertNotNull(newDataC3);
        Assert.assertEquals(true, newDataC3.getValue().getBooleanValue().booleanValue());

        CellData newDataD2 = sheet.receiveCell(new CellReference("D2")).getNonBlocking();
        Assert.assertNotNull(newDataD2);
        Assert.assertEquals(100.0, newDataD2.getValue().getNumberValue());

        CellData newDataD3 = sheet.receiveCell(new CellReference("D3")).getNonBlocking();
        Assert.assertNotNull(newDataD3);
        Assert.assertEquals(new Formula("=$B$2 + 100"), newDataD3.getFormula());
    }
}