List of mergeCells() Examples

Examples of mergeCells()

Merge the Cells contained in this CellRange @param boolean remove - true to delete the Cells following the first in the range

com.trulytech.mantis.util.ExcelWriter.mergeCells()

jxl.write.WritableSheet.mergeCells()

Merges the specified cells. Any clashes or intersections between merged cells are resolved when the spreadsheet is written out @param col1 the column number of the top left cell @param row1 the row number of the top left cell @param col2 the column number of the bottom right cell @param row2 the row number of the bottom right cell @return the Range object representing the merged cells @exception jxl.write..WriteException @exception jxl.write.biff.RowsExceededException

org.zkoss.zss.model.Sheet.mergeCells()

Merge the cells of the specified range. @param left left column of the range. @param top top row of the range. @param right right column of the range. @param bottom bottom row of the range.

  
  public void testMerge() {
    Sheet sheet1 = ((BookImpl)_book).addSheet("sheet1", 256, 64*1024);
    assertEquals(sheet1, _book.lookupSheet("sheet1"));
    
    sheet1.mergeCells(0, 0, 1, 0); //A1:B1
    sheet1.mergeCells(0, 1, 2, 1); //A2:C2
    
    try {
      sheet1.mergeCells(1, 0, 2, 0);
      assertTrue("Shall throw ModelException for cross merging.", false);

Examples of org.zkoss.zss.model.Sheet.mergeCells()

  public void testMerge() {
    Sheet sheet1 = ((BookImpl)_book).addSheet("sheet1", 256, 64*1024);
    assertEquals(sheet1, _book.lookupSheet("sheet1"));
    
    sheet1.mergeCells(0, 0, 1, 0); //A1:B1
    sheet1.mergeCells(0, 1, 2, 1); //A2:C2
    
    try {
      sheet1.mergeCells(1, 0, 2, 0);
      assertTrue("Shall throw ModelException for cross merging.", false);
    } catch(ModelException ex) {

Examples of org.zkoss.zss.model.Sheet.mergeCells()

    
    sheet1.mergeCells(0, 0, 1, 0); //A1:B1
    sheet1.mergeCells(0, 1, 2, 1); //A2:C2
    
    try {
      sheet1.mergeCells(1, 0, 2, 0);
      assertTrue("Shall throw ModelException for cross merging.", false);
    } catch(ModelException ex) {
      //ignore
    }
  }

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.