Package org.openxmlformats.schemas.spreadsheetml.x2006.main

Examples of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols

1826
1827
1828
1829
1830
1831
1832
1833
1834
1835
1836
1837
1838
1839
1840
1841
1842
1843
1844
1845
1846
1847
1848
        }
        return startHidden;
    }

    private int findColInfoIdx(int columnValue, int fromColInfoIdx) {
        CTCols cols = worksheet.getColsArray(0);

        if (columnValue < 0) {
            throw new IllegalArgumentException(
                    "column parameter out of range: " + columnValue);
        }
        if (fromColInfoIdx < 0) {
            throw new IllegalArgumentException(
                    "fromIdx parameter out of range: " + fromColInfoIdx);
        }

        for (int k = fromColInfoIdx; k < cols.sizeOfColArray(); k++) {
            CTCol ci = cols.getColArray(k);

            if (containsColumn(ci, columnValue)) {
                return k;
            }
View Full Code Here
1864
1865
1866
1867
1868
1869
1870
1871
1872
1873
1874
1875
1876
1877
1878
1879
1880
1881
1882
     *
     * @param idx
     * @return a boolean represented if the column is collapsed
     */
    private boolean isColumnGroupCollapsed(int idx) {
        CTCols cols = worksheet.getColsArray(0);
        int endOfOutlineGroupIdx = findEndOfColumnOutlineGroup(idx);
        int nextColInfoIx = endOfOutlineGroupIdx + 1;
        if (nextColInfoIx >= cols.sizeOfColArray()) {
            return false;
        }
        CTCol nextColInfo = cols.getColArray(nextColInfoIx);

        CTCol col = cols.getColArray(endOfOutlineGroupIdx);
        if (!isAdjacentBefore(col, nextColInfo)) {
            return false;
        }

        return nextColInfo.getCollapsed();
View Full Code Here
2295
2296
2297
2298
2299
2300
2301
2302
2303
2304
2305
        String cellRef = cellReference.formatAsString();
        getPane().setTopLeftCell(cellRef);
    }

    public void ungroupColumn(int fromColumn, int toColumn) {
        CTCols cols = worksheet.getColsArray(0);
        for (int index = fromColumn; index <= toColumn; index++) {
            CTCol col = columnHelper.getColumn(index, false);
            if (col != null) {
                short outlineLevel = col.getOutlineLevel();
                col.setOutlineLevel((short) (outlineLevel - 1));
View Full Code Here
2537
2538
2539
2540
2541
2542
2543
2544
2545
2546
2547
2548
    }

    protected void write(OutputStream out) throws IOException {

        if(worksheet.sizeOfColsArray() == 1) {
            CTCols col = worksheet.getColsArray(0);
            if(col.sizeOfColArray() == 0) {
                worksheet.setColsArray(null);
            }
        }

        // Now re-generate our CTHyperlinks, if needed
View Full Code Here
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
     */
    public void groupColumn(int fromColumn, int toColumn) {
        groupColumn1Based(fromColumn+1, toColumn+1);
    }
    private void groupColumn1Based(int fromColumn, int toColumn) {
        CTCols ctCols=worksheet.getColsArray(0);
        CTCol ctCol=CTCol.Factory.newInstance();
        ctCol.setMin(fromColumn);
        ctCol.setMax(toColumn);
        this.columnHelper.addCleanColIntoCols(ctCols, ctCol);
        for(int index=fromColumn;index<=toColumn;index++){
View Full Code Here
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
        return outlineLevel;
    }


    private short getMaxOutlineLevelCols(){
        CTCols ctCols=worksheet.getColsArray(0);
        CTCol[]colArray=ctCols.getColArray();
        short outlineLevel=0;
        for(CTCol col: colArray){
            outlineLevel=col.getOutlineLevel()>outlineLevel? col.getOutlineLevel(): outlineLevel;
        }
        return outlineLevel;
View Full Code Here
1315
1316
1317
1318
1319
1320
1321
1322
1323
1324
1325
1326
1327
1328
1329
1330
1331
1332
1333
1334
        expandColumn(columnNumber);
      }
    }

    private void collapseColumn(int columnNumber) {
      CTCols cols = worksheet.getColsArray(0);
      CTCol col = columnHelper.getColumn(columnNumber, false);
      int colInfoIx = columnHelper.getIndexOfColumn(cols, col);
      if (colInfoIx == -1) {
        return;
      }
      // Find the start of the group.
      int groupStartColInfoIx = findStartOfColumnOutlineGroup(colInfoIx);

      CTCol columnInfo = cols.getColArray(groupStartColInfoIx);

      // Hide all the columns until the end of the group
      int lastColMax = setGroupHidden(groupStartColInfoIx, columnInfo
          .getOutlineLevel(), true);
View Full Code Here
1337
1338
1339
1340
1341
1342
1343
1344
1345
1346
1347
1348
1349
1350
1351
    }

    private void setColumn(int targetColumnIx, Short xfIndex, Integer style,
        Integer level, Boolean hidden, Boolean collapsed) {
      CTCols cols = worksheet.getColsArray(0);
      CTCol ci = null;
      int k = 0;
      for (k = 0; k < cols.sizeOfColArray(); k++) {
        CTCol tci = cols.getColArray(k);
        if (tci.getMin() >= targetColumnIx
            && tci.getMax() <= targetColumnIx) {
          ci = tci;
          break;
        }
View Full Code Here
1437
1438
1439
1440
1441
1442
1443
1444
1445
1446
1447
1448
1449
1450
1451
1452
1453
     * @param pIdx
     *                the col info index of the start of the outline group
     * @return the column index of the last column in the outline group
     */
    private int setGroupHidden(int pIdx, int level, boolean hidden) {
      CTCols cols = worksheet.getColsArray(0);
      int idx = pIdx;
      CTCol columnInfo = cols.getColArray(idx);
      while (idx < cols.sizeOfColArray()) {
        columnInfo.setHidden(hidden);
        if (idx + 1 < cols.sizeOfColArray()) {
          CTCol nextColumnInfo = cols.getColArray(idx + 1);

          if (!isAdjacentBefore(columnInfo, nextColumnInfo)) {
            break;
          }

View Full Code Here
1465
1466
1467
1468
1469
1470
1471
1472
1473
1474
1475
1476
1477
1478
1479
1480
      return (col.getMax() == (other_col.getMin() - 1));
    }

    private int findStartOfColumnOutlineGroup(int pIdx) {
      // Find the start of the group.
      CTCols cols = worksheet.getColsArray(0);
      CTCol columnInfo = cols.getColArray(pIdx);
      int level = columnInfo.getOutlineLevel();
      int idx = pIdx;
      while (idx != 0) {
        CTCol prevColumnInfo = cols.getColArray(idx - 1);
        if (!isAdjacentBefore(prevColumnInfo, columnInfo)) {
          break;
        }
        if (prevColumnInfo.getOutlineLevel() < level) {
          break;
View Full Code Here
TOP

Related Classes of org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCols

  • com.narirelays.ems.utils.ExcelUtility
  • org.apache.poi.hssf.extractor.HXFExcelExtractor
  • org.apache.poi.hssf.HSSFXML
  • org.apache.poi.hssf.model.SharedStringsTable
  • org.apache.poi.xssf.eventusermodel.TestReadOnlySharedStringsTable
  • org.apache.poi.xssf.eventusermodel.XSSFReader$SheetIterator
  • org.apache.poi.xssf.model.CommentsTable
  • org.apache.poi.xssf.model.Control
  • org.apache.poi.xssf.model.Drawing
  • org.apache.poi.xssf.model.ExternalLinksTable
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.