Package org.zkoss.zss.model

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

95
96
97
98
99
100
101
102
103
104
105
    Sheet sheet1 = (Sheet) book.getSheets().get(0);
    assertEquals("#ff0000", ((SheetImpl)sheet1).getCell(1, 1).getFormat().getFillColor()); //B2
    assertEquals("#008000", ((SheetImpl)sheet1).getCell(5, 1).getFormat().getFillColor()); //B6
 
    //insert two columns
    sheet1.insertColumns(2, 3);
   
    assertEquals("#ff0000", ((SheetImpl)sheet1).getCell(1, 2).getFormat().getFillColor()); //C2
    assertEquals("#008000", ((SheetImpl)sheet1).getCell(5, 2).getFormat().getFillColor()); //C6
    assertEquals("#ff0000", ((SheetImpl)sheet1).getCell(1, 3).getFormat().getFillColor()); //D2
    assertEquals("#008000", ((SheetImpl)sheet1).getCell(5, 3).getFormat().getFillColor()); //D6
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
    final String nm = "row200.xls";
    Book book = new ExcelImporter().imports(getClass().getResource("/"+nm));
   
    Sheet sheet1 = (Sheet) book.getSheets().get(0);
    try {
      sheet1.insertColumns(-1, -1);
      assertFalse("Should come here after sheet1.insertColumns(-1, -1);",true);
    } catch(Exception ex) {
      System.out.println(ex.getMessage());//correct and ignore
    }
  }
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
    Sheet sheet1 = (Sheet) book.getSheets().get(0);
    int widthA = sheet1.getColumnWidth(0);
    int widthB = sheet1.getColumnWidth(1);
    int widthC = sheet1.getColumnWidth(2);
   
    sheet1.insertColumns(1,3);
   
    assertEquals(widthA, sheet1.getColumnWidth(0));
    assertTrue(widthB != sheet1.getColumnWidth(1));
    assertTrue(widthC != sheet1.getColumnWidth(2));
    assertEquals(widthB, sheet1.getColumnWidth(4));
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.