Package org.apache.poi.hssf.util

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

250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
   *
   */   
  public void testRemoveMerged() {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet();
    Region region = new Region(0, (short)0, 1, (short)1);    
    sheet.addMergedRegion(region);
    region = new Region(1, (short)0, 2, (short)1);
    sheet.addMergedRegion(region);
   
      sheet.removeMergedRegion(0);
     
      region = sheet.getMergedRegionAt(0);
      assertEquals("Left over region should be starting at row 1", 1, region.getRowFrom());
     
      sheet.removeMergedRegion(0);
     
    assertEquals("there should be no merged regions left!", 0, sheet.getNumMergedRegions());
   
    //an, add, remove, get(0) would null pointer
    sheet.addMergedRegion(region);
    assertEquals("there should now be one merged region!", 1, sheet.getNumMergedRegions());
    sheet.removeMergedRegion(0);
    assertEquals("there should now be zero merged regions!", 0, sheet.getNumMergedRegions());
    //add it again!
    region.setRowTo(4);
     
    sheet.addMergedRegion(region);
    assertEquals("there should now be one merged region!", 1, sheet.getNumMergedRegions());
   
    //should exist now!
    assertTrue("there isn't more than one merged region in there", 1 <= sheet.getNumMergedRegions());
    region = sheet.getMergedRegionAt(0);
    assertEquals("the merged row to doesnt match the one we put in ", 4, region.getRowTo());
     
    }
View Full Code Here
293
294
295
296
297
298
299
300
301
302
303
304
305
306
   
    row = sheet.createRow(1);
    cell = row.createCell((short)1);
    cell.setCellValue("second row, second cell");
   
    Region region = new Region(1, (short)0, 1, (short)1);    
    sheet.addMergedRegion(region);
   
    sheet.shiftRows(1, 1, 1);
   
    region = sheet.getMergedRegionAt(0);
    assertEquals("Merged region not moved over to row 2", 2, region.getRowFrom());
   
  }
View Full Code Here
525
526
527
528
529
530
531
     * @return the merged region (simple eh?)
     */

    public Region getMergedRegionAt(int index)
    {
        return new Region(sheet.getMergedRegionAt(index));
    }
View Full Code Here
659
660
661
662
663
664
665
666
     * @deprecated (Aug-2008) use {@link HSSFSheet#getMergedRegion(int)}
     */
    public Region getMergedRegionAt(int index) {
        CellRangeAddress cra = getMergedRegion(index);
       
        return new Region(cra.getFirstRow(), (short)cra.getFirstColumn(),
                cra.getLastRow(), (short)cra.getLastColumn());
    }
View Full Code Here
764
765
766
767
768
769
770
771
     * @deprecated (Aug-2008) use {@link HSSFSheet#getMergedRegion(int)}
     */
    public Region getMergedRegionAt(int index) {
        CellRangeAddress cra = getMergedRegion(index);

        return new Region(cra.getFirstRow(), (short)cra.getFirstColumn(),
                cra.getLastRow(), (short)cra.getLastColumn());
    }
View Full Code Here
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
  }

  public void unmergeCells(Region region) {
    int numRegions = sheet.getNumMergedRegions();
    for(int i = 0; i < numRegions; i++) {
      Region r = sheet.getMergedRegionAt(i);
      if( r != null && r.equals(region) ) {
        sheet.removeMergedRegion(i);
        return;
      }
    }
  }
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
     */
    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
68
69
70
71
72
73
74
75
        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
202
203
204
205
206
207
208
209
210
211
212
213
214
215
     * @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
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
     * 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
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.