xref: /trunk/test/testuno/source/fvt/uno/sc/cell/CellEffectOverline.java (revision 42a976b737d4e2b88cfbe2fe1cd610fe957bdc84)

/**************************************************************
 *
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership.  The ASF licenses this file
 * to you under the Apache License, Version 2.0 (the
 * "License"); you may not use this file except in compliance
 * with the License.  You may obtain a copy of the License at
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing,
 * software distributed under the License is distributed on an
 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 * KIND, either express or implied.  See the License for the
 * specific language governing permissions and limitations
 * under the License.
 *
 *************************************************************/


package fvt.uno.sc.cell;

import static org.junit.Assert.assertEquals;
import static org.junit.Assert.assertFalse;
import static org.junit.Assert.assertTrue;

import java.util.Arrays;
import java.util.Collection;

import org.junit.After;
import org.junit.AfterClass;
import org.junit.Before;
import org.junit.BeforeClass;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.junit.runners.Parameterized;
import org.junit.runners.Parameterized.Parameters;
import org.openoffice.test.uno.UnoApp;

import testlib.uno.SCUtil;
import testlib.uno.TestUtil;
import testlib.uno.CellInfo;

import com.sun.star.lang.XComponent;
import com.sun.star.sheet.XSpreadsheet;
import com.sun.star.sheet.XSpreadsheetDocument;
import com.sun.star.table.XCell;


/**
 *  Check the cell background color and font color setting can be applied and saved
 *
 */
@RunWith(value = Parameterized.class)
public class CellEffectOverline {

    private int expectedLine;
    private int expectedColor;
    private String[] inputType;
    private int inputStyle;
    private int inputColor;
    private String fileType;

    private static final UnoApp unoApp = new UnoApp();

    XComponent scComponent = null;
    XSpreadsheetDocument scDocument = null;

    @Parameters
    public static Collection<Object[]> data() throws Exception {
        String[] typeList = {"CharOverline", "CharOverlineHasColor", "CharOverlineColor"};
        int[] list = TestUtil.randColorList(19);
        return Arrays.asList(new Object[][] {
            {0, list[0], typeList, 0, list[0], "ods"}, //NONE 0
            {1, list[1], typeList, 1, list[1], "ods"}, //SIGNLE 1
            {2, list[2], typeList, 2, list[2], "ods"}, //DOUBLE 2
            {3, list[3], typeList, 3, list[3], "ods"}, //DOTTED 3
            {0, list[4], typeList, 4, list[4], "ods"}, //DONTKNOW 4  can not set this setting via UI
            {5, list[5], typeList, 5, list[5], "ods"}, //DASH 5
            {6, list[6], typeList, 6, list[6], "ods"}, //LONGDASH 6
            {7, list[7], typeList, 7, list[7], "ods"}, //DASHDOT 7
            {8, list[8], typeList, 8, list[8], "ods"}, //DASHDOTDOT 8
            {9, list[9], typeList, 9, list[9], "ods"}, //SMALLWAVE 9  can not set this setting via UI
            {10, list[10], typeList, 10, list[10], "ods"}, //WAVE 10
            {11, list[11], typeList, 11, list[11], "ods"}, //DOUBLEWAVE 11
            {12, list[12], typeList, 12, list[12], "ods"}, //BOLD 12
            {13, list[13], typeList, 13, list[13], "ods"}, //BOLDDOTTED 13
            {14, list[14], typeList, 14, list[14], "ods"}, //BOLDDASH 14
            {15, list[15], typeList, 15, list[15], "ods"}, //BOLDLONGDASH 15
            {16, list[16], typeList, 16, list[16], "ods"}, //BOLDDASHDOT 16
            {17, list[17], typeList, 17, list[17], "ods"}, //BOLDDASHDOTDOT 17
            {18, list[18], typeList, 18, list[18], "ods"}, //BOLDWAVE = 18

            {0, list[0], typeList, 0, list[0], "xls"}, //NONE 0
            {0, list[1], typeList, 1, list[1], "xls"}, //SIGNLE 1
            {0, list[2], typeList, 2, list[2], "xls"}, //DOUBLE 2
            {0, list[3], typeList, 3, list[3], "xls"}, //DOTTED 3
            {0, list[4], typeList, 4, list[4], "xls"}, //DONTKNOW 4  can not set this setting via UI
            {0, list[5], typeList, 5, list[5], "xls"}, //DASH 5
            {0, list[6], typeList, 6, list[6], "xls"}, //LONGDASH 6
            {0, list[7], typeList, 7, list[7], "xls"}, //DASHDOT 7
            {0, list[8], typeList, 8, list[8], "xls"}, //DASHDOTDOT 8
            {0, list[9], typeList, 9, list[9], "xls"}, //SMALLWAVE 9  can not set this setting via UI
            {0, list[10], typeList, 10, list[10], "xls"}, //WAVE 10
            {0, list[11], typeList, 11, list[11], "xls"}, //DOUBLEWAVE 11
            {0, list[12], typeList, 12, list[12], "xls"}, //BOLD 12
            {0, list[13], typeList, 13, list[13], "xls"}, //BOLDDOTTED 13
            {0, list[14], typeList, 14, list[14], "xls"}, //BOLDDASH 14
            {0, list[15], typeList, 15, list[15], "xls"}, //BOLDLONGDASH 15
            {0, list[16], typeList, 16, list[16], "xls"}, //BOLDDASHDOT 16
            {0, list[17], typeList, 17, list[17], "xls"}, //BOLDDASHDOTDOT 17
            {0, list[18], typeList, 18, list[18], "xls"} //BOLDWAVE = 18

        });
    }

    public CellEffectOverline(int expectedStyle, int expectedColor, String[] inputType, int inputStyle, int inputColor, String fileType) {
        this.expectedLine = expectedStyle;
        this.expectedColor = expectedColor;
        this.inputType = inputType;
        this.inputStyle = inputStyle;
        this.inputColor = inputColor;
        this.fileType = fileType;
    }


    @Before
    public void setUp() throws Exception {
        scComponent = unoApp.newDocument("scalc");
        scDocument = SCUtil.getSCDocument(scComponent);
    }

    @After
    public void tearDown() throws Exception {
        unoApp.closeDocument(scComponent);

    }

    @BeforeClass
    public static void setUpConnection() throws Exception {
        unoApp.start();
    }

    @AfterClass
    public static void tearDownConnection() throws InterruptedException, Exception {
        unoApp.close();
        SCUtil.clearTempDir();
    }

    /**
     * Check the cell overline style and overline color
     * 1. Create a spreadsheet file.
     * 2. Input number, text, formula into many cell.
     * 3. Set cell overline style.
     * 4. Set cell overline color, if overline style is not NONE.
     * 4. Save file as ODF/MSBinary format. (MSBinary file can not support overline, save as .xls, the overline setting will be lost)
     * 5. Close and reopen file.  -> Check the overline style and overline color setting.
     * @throws Exception
     */
    @Test
    public void testCharOverline() throws Exception {
        String fileName = "testCharOverline";
        int cellNum = 5;
        XCell[] cells = new XCell[cellNum];
        int[] styleResults = new int[cellNum];
        boolean[] hasColor = new boolean[cellNum];
        int[] colorResults = new int[cellNum];
        CellInfo cInfo = TestUtil.randCell(100, 100);

        XSpreadsheet sheet = SCUtil.getCurrentSheet(scDocument);

        for (int i = 0; i < cellNum; i++) {
            cells[i] = sheet.getCellByPosition(cInfo.getCol(), cInfo.getRow() + i);
        }

        cells[0].setValue(inputColor);
        SCUtil.setTextToCell(cells[1], inputType[0]);
        cells[2].setFormula("=10/0");
        cells[3].setValue(-0.0000001);

        for (int i = 0; i < cellNum; i++) {
            SCUtil.setCellProperties(cells[i], inputType[0], inputStyle);
            if (inputStyle > 0) {
                SCUtil.setCellProperties(cells[i], inputType[1], true);
                SCUtil.setCellProperties(cells[i], inputType[2], inputColor);
            }
        }

        SCUtil.saveFileAs(scComponent, fileName, fileType);
        scDocument = SCUtil.reloadFile(unoApp, scDocument, fileName + "." + fileType);
        sheet = SCUtil.getCurrentSheet(scDocument);

        for (int i = 0; i < cellNum; i++) {
            cells[i] = sheet.getCellByPosition(cInfo.getCol(), cInfo.getRow() + i);
            styleResults[i] = ((Short) SCUtil.getCellProperties(cells[i], inputType[0])).shortValue();

            if (inputStyle > 0) {
                hasColor[i] = ((Boolean) SCUtil.getCellProperties(cells[i], inputType[1])).booleanValue();
                colorResults[i] = ((Integer) SCUtil.getCellProperties(cells[i], inputType[2])).intValue();
            }
        }

        SCUtil.closeFile(scDocument);

        for (int i = 0; i < cellNum; i++) {
            assertEquals("Incorrect cell overline style(" + inputType[0] + ") value got in ." + fileType + " file.", expectedLine, styleResults[i], 0);

            if (inputStyle > 0) {

                if( fileType.equalsIgnoreCase("xls") || fileType.equalsIgnoreCase("xlt")) {
                    assertFalse("Incorrect cell overline has color setting(" + inputType[1] + ") value got in ." + fileType + " file.", hasColor[i]);
                }

                else {
                    assertTrue("Incorrect cell overline has color setting(" + inputType[1] + ") value got in ." + fileType + " file.", hasColor[i]);
                    assertEquals("Incorrect cell overline color(" + inputType[2] + ") value got in ." + fileType + " file.", expectedColor, colorResults[i], 0);
                }

            }
        }

    }

}