Package org.apache.poi.ss.util

Examples of org.apache.poi.ss.util.CellRangeAddress.formatAsString()

3121
3122
3123
3124
3125
3126
3127
3128
3129
3130
3131
        CTAutoFilter af = worksheet.getAutoFilter();
        if(af == null) af = worksheet.addNewAutoFilter();

        CellRangeAddress norm = new CellRangeAddress(range.getFirstRow(), range.getLastRow(),
                range.getFirstColumn(), range.getLastColumn());
        String ref = norm.formatAsString();
        af.setRef(ref);

        XSSFWorkbook wb = getWorkbook();
        int sheetIndex = getWorkbook().getSheetIndex(this);
        XSSFName name = wb.getBuiltInName(XSSFName.BUILTIN_FILTER_DB, sheetIndex);
View Full Code Here
161
162
163
164
165
166
167
168
169
170
171
   
    CellRangeAddress[] cellRangeAddresses = cellRangeAddressList.getCellRangeAddresses();
    List<String> sqref = new ArrayList<String>();
    for (int i = 0; i < cellRangeAddresses.length; i++) {
      CellRangeAddress cellRangeAddress = cellRangeAddresses[i];
      sqref.add(cellRangeAddress.formatAsString());
    }
    newDataValidation.setSqref(sqref);
   
    return new XSSFDataValidation(dataValidationConstraint,cellRangeAddressList,newDataValidation);
  }
View Full Code Here
157
158
159
160
161
162
163
164
165
166
167
   
    CellRangeAddress[] cellRangeAddresses = cellRangeAddressList.getCellRangeAddresses();
    List<String> sqref = new ArrayList<String>();
    for (int i = 0; i < cellRangeAddresses.length; i++) {
      CellRangeAddress cellRangeAddress = cellRangeAddresses[i];
      sqref.add(cellRangeAddress.formatAsString());
    }
    newDataValidation.setSqref(sqref);
   
    return new XSSFDataValidation(dataValidationConstraint,cellRangeAddressList,newDataValidation);
  }
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
        // check getFirstCell...
        XSSFCell firstCell = cells.getTopLeftCell();
        assertSame(firstCell, sheet.getFirstCellInArrayFormula(firstCell));
        //retrieve the range and check it is the same
        assertEquals(range.formatAsString(), firstCell.getArrayFormulaRange().formatAsString());
        confirmArrayFormulaCell(firstCell, "C3", formula1, "C3");
    }

    public void testXSSFSetArrayFormula_multiCell() {
        CellRange<XSSFCell> cells;
View Full Code Here
3498
3499
3500
3501
3502
3503
3504
3505
3506
3507
3508
        CTAutoFilter af = worksheet.getAutoFilter();
        if(af == null) af = worksheet.addNewAutoFilter();

        CellRangeAddress norm = new CellRangeAddress(range.getFirstRow(), range.getLastRow(),
                range.getFirstColumn(), range.getLastColumn());
        String ref = norm.formatAsString();
        af.setRef(ref);

        XSSFWorkbook wb = getWorkbook();
        int sheetIndex = getWorkbook().getSheetIndex(this);
        XSSFName name = wb.getBuiltInName(XSSFName.BUILTIN_FILTER_DB, sheetIndex);
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
        HSSFCell cell = sheet.getRow(2).getCell(2);
        assertNotNull(cell);

        assertTrue(cell.isPartOfArrayFormulaGroup());
        //retrieve the range and check it is the same
        assertEquals(range.formatAsString(), cell.getArrayFormulaRange().formatAsString());

        FormulaRecordAggregate agg = (FormulaRecordAggregate)cell.getCellValueRecord();
        assertEquals(range.formatAsString(), agg.getArrayFormulaRange().formatAsString());
        assertTrue(agg.isPartOfArrayFormula());
    }
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
        assertTrue(cell.isPartOfArrayFormulaGroup());
        //retrieve the range and check it is the same
        assertEquals(range.formatAsString(), cell.getArrayFormulaRange().formatAsString());

        FormulaRecordAggregate agg = (FormulaRecordAggregate)cell.getCellValueRecord();
        assertEquals(range.formatAsString(), agg.getArrayFormulaRange().formatAsString());
        assertTrue(agg.isPartOfArrayFormula());
    }

    /**
     * Makes sure the internal state of HSSFSheet is consistent after removing array formulas
View Full Code Here
3139
3140
3141
3142
3143
3144
3145
3146
3147
3148
3149
        CTAutoFilter af = worksheet.getAutoFilter();
        if(af == null) af = worksheet.addNewAutoFilter();

        CellRangeAddress norm = new CellRangeAddress(range.getFirstRow(), range.getLastRow(),
                range.getFirstColumn(), range.getLastColumn());
        String ref = norm.formatAsString();
        af.setRef(ref);

        XSSFWorkbook wb = getWorkbook();
        int sheetIndex = getWorkbook().getSheetIndex(this);
        XSSFName name = wb.getBuiltInName(XSSFName.BUILTIN_FILTER_DB, sheetIndex);
View Full Code Here
3164
3165
3166
3167
3168
3169
3170
3171
3172
3173
3174
        CTAutoFilter af = worksheet.getAutoFilter();
        if(af == null) af = worksheet.addNewAutoFilter();

        CellRangeAddress norm = new CellRangeAddress(range.getFirstRow(), range.getLastRow(),
                range.getFirstColumn(), range.getLastColumn());
        String ref = norm.formatAsString();
        af.setRef(ref);

        XSSFWorkbook wb = getWorkbook();
        int sheetIndex = getWorkbook().getSheetIndex(this);
        XSSFName name = wb.getBuiltInName(XSSFName.BUILTIN_FILTER_DB, sheetIndex);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.