Examples with CTCols org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols used on opensource projects

Example 26 with CTCols

use of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols in project poi by apache.

the class TestColumnHelper method assertMinMaxHiddenBestFit.

private static void assertMinMaxHiddenBestFit(CTCols cols, int index, int min, int max, boolean hidden, boolean bestFit) {
    CTCol col = cols.getColArray(index);
    assertEquals(min, col.getMin());
    assertEquals(max, col.getMax());
    assertEquals(hidden, col.getHidden());
    assertEquals(bestFit, col.getBestFit());
}

Example 27 with CTCols

use of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols in project poi by apache.

the class TestColumnHelper method testGetColumn.

@Test
public void testGetColumn() {
    CTWorksheet worksheet = CTWorksheet.Factory.newInstance();
    CTCols cols1 = worksheet.addNewCols();
    CTCol col1 = cols1.addNewCol();
    col1.setMin(1);
    col1.setMax(1);
    col1.setWidth(88);
    col1.setHidden(true);
    CTCol col2 = cols1.addNewCol();
    col2.setMin(2);
    col2.setMax(3);
    CTCols cols2 = worksheet.addNewCols();
    CTCol col4 = cols2.addNewCol();
    col4.setMin(3);
    col4.setMax(6);
    // Remember - POI column 0 == OOXML column 1
    ColumnHelper helper = new ColumnHelper(worksheet);
    assertNotNull(helper.getColumn(0, false));
    assertNotNull(helper.getColumn(1, false));
    assertEquals(88.0, helper.getColumn(0, false).getWidth(), 0.0);
    assertEquals(0.0, helper.getColumn(1, false).getWidth(), 0.0);
    assertTrue(helper.getColumn(0, false).getHidden());
    assertFalse(helper.getColumn(1, false).getHidden());
    assertNull(helper.getColumn(99, false));
    assertNotNull(helper.getColumn(5, false));
}

Example 28 with CTCols

use of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols in project poi by apache.

the class TestColumnHelper method testCleanColumns.

@Test
public void testCleanColumns() {
    CTWorksheet worksheet = CTWorksheet.Factory.newInstance();
    CTCols cols1 = worksheet.addNewCols();
    CTCol col1 = cols1.addNewCol();
    col1.setMin(1);
    col1.setMax(1);
    col1.setWidth(88);
    col1.setHidden(true);
    CTCol col2 = cols1.addNewCol();
    col2.setMin(2);
    col2.setMax(3);
    CTCols cols2 = worksheet.addNewCols();
    CTCol col4 = cols2.addNewCol();
    col4.setMin(13);
    col4.setMax(16384);
    // Test cleaning cols
    assertEquals(2, worksheet.sizeOfColsArray());
    int count = countColumns(worksheet);
    assertEquals(16375, count);
    // Clean columns and test a clean worksheet
    ColumnHelper helper = new ColumnHelper(worksheet);
    assertEquals(1, worksheet.sizeOfColsArray());
    count = countColumns(worksheet);
    assertEquals(16375, count);
    // Remember - POI column 0 == OOXML column 1
    assertEquals(88.0, helper.getColumn(0, false).getWidth(), 0.0);
    assertTrue(helper.getColumn(0, false).getHidden());
    assertEquals(0.0, helper.getColumn(1, false).getWidth(), 0.0);
    assertFalse(helper.getColumn(1, false).getHidden());
}

Example 29 with CTCols

use of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols in project poi by apache.

the class TestColumnHelper method testAddCleanColIntoColsNewOverlapsOverhangingLeftNotRight.

@Test
public void testAddCleanColIntoColsNewOverlapsOverhangingLeftNotRight() throws Exception {
    CTCols cols = createHiddenAndBestFitColsWithHelper(2, 3, 1, 2);
    assertEquals(3, cols.sizeOfColArray());
    assertMinMaxHiddenBestFit(cols, 0, 1, 1, false, true);
    assertMinMaxHiddenBestFit(cols, 1, 2, 2, true, true);
    assertMinMaxHiddenBestFit(cols, 2, 3, 3, true, false);
}

Example 30 with CTCols

use of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols in project poi by apache.

the class TestColumnHelper method testAddCleanColIntoColsOverlapsOverhangingBothSides.

@Test
public void testAddCleanColIntoColsOverlapsOverhangingBothSides() throws Exception {
    CTCols cols = createHiddenAndBestFitColsWithHelper(2, 2, 1, 3);
    assertEquals(3, cols.sizeOfColArray());
    assertMinMaxHiddenBestFit(cols, 0, 1, 1, false, true);
    assertMinMaxHiddenBestFit(cols, 1, 2, 2, true, true);
    assertMinMaxHiddenBestFit(cols, 2, 3, 3, false, true);
}