Package org.apache.poi.hssf.util

Examples of org.apache.poi.hssf.util.Region

302
303
304
305
306
307
308
309
310
311
312
313
    public void test22720() {
       HSSFWorkbook workBook = new HSSFWorkbook();
       workBook.createSheet("TEST");
       HSSFSheet template = workBook.getSheetAt(0);

       template.addMergedRegion(new Region(0, (short)0, 1, (short)2));
       template.addMergedRegion(new Region(1, (short)0, 2, (short)2));

       HSSFSheet clone = workBook.cloneSheet(0);
       int originalMerged = template.getNumMergedRegions();
       assertEquals("2 merged regions", 2, originalMerged);
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
        HSSFRow row = sheet.createRow((short) 1);
        HSSFCell cell = row.createCell((short) 1);
        cell.setCellValue("This is a test of merging");

        sheet.addMergedRegion(new Region(1,(short)1,1,(short)2));

        // Write the output to a file
        FileOutputStream fileOut = new FileOutputStream("workbook.xls");
        wb.write(fileOut);
        fileOut.close();
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
    };

    short col = 1;
    Region [] regions =
    {
      new Region(0,col,65535,col)
    };

    sheetCF.addConditionalFormatting(regions, cfRules);
    sheetCF.addConditionalFormatting(regions, cfRules);

    // Verification
    assertEquals(2, sheetCF.getNumConditionalFormattings());
    sheetCF.removeConditionalFormatting(1);
    assertEquals(1, sheetCF.getNumConditionalFormattings());
    HSSFConditionalFormatting cf = sheetCF.getConditionalFormattingAt(0);
    assertNotNull(cf);

    regions = cf.getFormattingRegions();
    assertNotNull(regions);
    assertEquals(1, regions.length);
    Region r = regions[0];
    assertEquals(1, r.getColumnFrom());
    assertEquals(1, r.getColumnTo());
    assertEquals(0, r.getRowFrom());
    assertEquals(65535, r.getRowTo());

    assertEquals(2, cf.getNumberOfRules());

    rule1 = cf.getRule(0);
    assertEquals("7",rule1.getFormula1());
View Full Code Here
572
573
574
575
576
577
578
     * @return the merged region (simple eh?)
     */

    public Region getMergedRegionAt(int index)
    {
        return new Region(sheet.getMergedRegionAt(index));
    }
View Full Code Here
521
522
523
524
525
526
527
     * @return the merged region (simple eh?)
     */

    public Region getMergedRegionAt(int index)
    {
        return new Region(sheet.getMergedRegionAt(index));
    }
View Full Code Here
543
544
545
546
547
548
549
     * @return the merged region (simple eh?)
     */

    public Region getMergedRegionAt(int index)
    {
        return new Region(sheet.getMergedRegionAt(index));
    }
View Full Code Here
237
238
239
240
241
242
243
244
245
246
247
248
249
250
     * @return HSSFCellStyle
     */
    HSSFCellStyle getCellStyleForRegion(int row, short col) {
        Iterator iregions = regions.keySet().iterator();
        while (iregions.hasNext()) {
            Region region = ((Region)iregions.next());
            //            if (col == 1)
            //                getLogger().debug("breakpoint support");
            if (region.contains(row, col)) {
                //getLogger().debug("Returning style for " + row +"," + col);
                return (HSSFCellStyle)regions.get(region);
            }
        }
        //getLogger().debug("returning null for "+row+","+col);
View Full Code Here
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
     * defined.
     */
    public void assignBlanksToRegions() {
        Iterator iregions = regions.keySet().iterator();
        while (iregions.hasNext()) {
            Region region = ((Region)iregions.next());
            //getLogger().debug("fixing region
            // "+region.getRowFrom()+","+region.getColumnFrom()+"-"+
            //          region.getRowTo()+","+region.getColumnTo());
            for (int rownum = region.getRowFrom();
                        rownum < region.getRowTo() + 1; rownum++) {
                HSSFRow row = _sheet.getRow(rownum);
                for (short colnum = region.getColumnFrom();
                            colnum < region.getColumnTo() + 1; colnum++) {
                    HSSFCellStyle style = (HSSFCellStyle)regions.get(region);
                    if (!isBlank(style)) {
                        //don't waste time with huge blocks of blankly styled
                        // cells
                        if (row == null) {
View Full Code Here
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
     */
    public void initialize(final Attribute[] attributes,
                final ElementProcessor parent) throws IOException {
        super.initialize(attributes, parent);

        Region region = new Region(getStartRow(), (short)getStartCol(),
                getEndRow(), (short)getEndCol());

        //        if (region.getRowFrom() == 0 &&
        //            region.getColumnFrom() ==0)
        //            getLogger().debug("got 0,0");

        getLogger().debug("region area is " + region.getArea());
        if (region.getArea() < MAX_AREA) {
            //protect against stupid mega regions
            //of generally NOTHING and no real
            //puprose created by gnumeric
            getLogger().debug("region added");
            _style = getSheet().addStyleRegion(region); //test
View Full Code Here
103
104
105
106
107
108
109
110
        if (getLogger().isDebugEnabled()) {
            getLogger().debug("Merging Range: Row (" + fromRow + ") Col ("
                    + fromCol + ")" + " to Row (" + toRow + ") Col (" + toCol
                    + ")");
        }
        Region region = new Region(fromRow, fromCol, toRow, toCol);
        sheet.addMergedRegion(region);
    }
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.util.Region

  • com.jfinal.ext.render.excel.PoiKit
  • net.fqsc.inscriptions.view.component.principalcontent.admin.evenements.reports.plaques.ListePlaquePanel
  • net.loyin.jFinal.render.excel.ExcelKit
  • no.ugland.utransprod.util.excel.ExcelUtil
  • org.apache.cocoon.components.elementprocessor.impl.poi.hssf.elements.EPCell
  • org.apache.cocoon.components.elementprocessor.impl.poi.hssf.elements.EPMerge
  • org.apache.cocoon.components.elementprocessor.impl.poi.hssf.elements.EPStyleRegion
  • org.apache.cocoon.components.elementprocessor.impl.poi.hssf.elements.Sheet
  • org.apache.poi.hssf.record.cf.CellRange
  • org.apache.poi.hssf.usermodel.examples.MergedCells
    • 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.