Package org.zkoss.zss.model

Examples of org.zkoss.zss.model.Book

100
101
102
103
104
105
106
107
108
109
110
111
112
      System.out.println(ex.getMessage());//correct and ignore
    }
  }
  public void testInsertRowOutOfRange() {
    final String nm = "row200.xls";
    Book book = new ExcelImporter().imports(getClass().getResource("/"+nm));
   
    Sheet sheet1 = (Sheet) book.getSheets().get(0);
    try {
      sheet1.insertRows(-1, -1);
      assertFalse("Should come here after sheet1.insertRows(-1, -1);",true);
    } catch(Exception ex) {
      System.out.println(ex.getMessage());//correct and ignore
View Full Code Here
113
114
115
116
117
118
119
120
121
122
123
124
125
      //correct and ignore
    }
  }
  public void testDeleteRowOutOfRange() {
    final String nm = "row200.xls";
    Book book = new ExcelImporter().imports(getClass().getResource("/"+nm));
   
    Sheet sheet1 = (Sheet) book.getSheets().get(0);
    try {
      sheet1.deleteRows(-1, -1);
      assertFalse("Should come here after sheet1.deleteRows(-1, -1);",true);
    } catch(Exception ex) {
      System.out.println(ex.getMessage());//correct and ignore
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
55
    super.tearDown();
  }
 
  public void testDeleteColumnsWidth() {
    final String nm = "colwidth.xls";
    Book book = new ExcelImporter().imports(getClass().getResource("/"+nm));
    Sheet sheet1 = (Sheet) book.getSheets().get(0);
    int widthA = sheet1.getColumnWidth(0);
    int widthB = sheet1.getColumnWidth(1);
    int widthC = sheet1.getColumnWidth(2);
   
    sheet1.deleteColumns(1,1);
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
70
    assertEquals(widthC, sheet1.getColumnWidth(1));
  }

  public void testInsertColumnsWidth() {
    final String nm = "colwidth.xls";
    Book book = new ExcelImporter().imports(getClass().getResource("/"+nm));
    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);
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
    super.tearDown();
  }

  public void testDeleteColumnUnnecesarySSEvent() {
    final String nm = "row200.xls";
    Book book = new ExcelImporter().imports(getClass().getResource("/"+nm));
    final SimpleSSDataListener ssl = new SimpleSSDataListener();
    book.addSSDataListener(ssl);

    Sheet sheet1 = (Sheet) book.getSheets().get(0);
    sheet1.deleteColumns(2,2); //delete column C (C1 ~ C100)

    List evts = ssl.getList();
   
    for(Iterator it = evts.iterator(); it.hasNext();) {
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
86
87
    assertEquals(rng, evt.getRange());
  }
 
  public void testInsertColumnOutOfRange() {
    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
88
89
90
91
92
93
94
95
96
97
98
99
100
    }
  }

  public void testDeleteColumnOutOfRange() {
    final String nm = "row200.xls";
    Book book = new ExcelImporter().imports(getClass().getResource("/"+nm));
   
    Sheet sheet1 = (Sheet) book.getSheets().get(0);
    try {
      sheet1.deleteColumns(-1, -1);
      assertFalse("Should come here after sheet1.deleteColumns(-1, -1);",true);
    } catch(Exception ex) {
      System.out.println(ex.getMessage());//correct and ignore
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
 
  public Collection getCells() {
    final List list = new LinkedList();
    final Sheet sheetTo = getSheetTo();
    if (sheetTo != null) { //3d range
      final Book book = getSheet().getBook();
      final Sheet sheetFrom = getSheet();
      boolean start = false;
      boolean stop = false;
      for(final Iterator it = book.getSheets().iterator(); it.hasNext() && !stop;) {
        final Sheet sheet = (Sheet) it.next();
        if (sheet == sheetFrom) {
          start = true;
        } else if (sheet == sheetTo) {
          stop = true;
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
      return matrix.getCells(getLeft(), getTop(), getRight(), getBottom(), list);
    }
  }
 
  public Cell[][][] getCellsArray() {
    final Book book = getSheet().getBook();
    final Sheet sheetTo = getSheetTo();
    Cell[][][] cella = null;
    int startj = -1;
    if (sheetTo != null) { //3d range
      final Sheet sheetFrom = getSheet();
      int j = 0;
      int endj = -1;
      for(final Iterator it = book.getSheets().iterator(); it.hasNext(); ++j) {
        final Sheet sheet = (Sheet) it.next();
        if (sheet == sheetFrom) {
          startj = j;
        } else if (sheet == sheetTo) {
          endj = j;
          break;
        }
      }
      if (startj < 0 || endj < 0) { //reach sheetTo first, reverse sequence.
        throw new SSErrorXelException(SSError.REF);
      }
      final int sheetsz = endj - startj + 1;
      cella = new Cell[sheetsz][][];
     
    } else { //2d range
      startj = 0;
      cella = new Cell[1][][];
    }
    final int sheetsz = cella.length;
    final int top = getTop();
    final int left = getLeft();
    final int rowsz = getBottom() - top + 1;
    final int colsz = getRight() - left + 1;
    int sj = 0;
    for (final ListIterator it = book.getSheets().listIterator(startj); it.hasNext() && sj < sheetsz; ++sj) {
      final Sheet sheet = (Sheet) it.next();
      cella[sj] = new Cell[rowsz][];
      for (int rj = 0; rj < rowsz; ++rj) {
        cella[sj][rj] = new Cell[colsz];
        for (int cj = 0; cj < colsz; ++cj) {
View Full Code Here
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
  public static List toListHelper(List result, Object arg, boolean skipBoolean, boolean skipText, XelContext ctx){
    if (arg instanceof SSError) {
      throw new SSErrorXelException((SSError) arg);
    } else if (arg instanceof Range) { // a range, iterator thru available cells
      final Range rng = (Range) arg;
      final Book book = rng.getSheet().getBook();
      final Collection cells = rng.getCells();
      for(final Iterator it = cells.iterator(); it.hasNext();) {
        final Cell cell = (Cell) it.next();
        toListHelper(result, cell.getResult(), skipBoolean, skipText, (XelContext) book); // recursive
      }
    } else if (arg instanceof Range[]) { //a range array, iterator thru available ranges
      for (int j = 0; j < ((Range[])arg).length; ++j) {
        final Range rng = (Range) ((Range[])arg)[j];
        final Book book = rng.getSheet().getBook();
        toListHelper(result, rng, skipBoolean, skipText, (XelContext) book); // recursive
      }
    } else if (arg instanceof String) {
      if (!skipText) {
        result.add(Objects.ZERO_DOUBLE);
View Full Code Here
TOP

Related Classes of org.zkoss.zss.model.Book

  • org.zkoss.poi.ss.formula.DefaultDependencyTracker
  • org.zkoss.zss.app.cell.CellHelper
  • org.zkoss.zss.app.file.ExportToHtmlWindowCtrl
  • org.zkoss.zss.app.file.ExportToPdfWindowCtrl
  • org.zkoss.zss.app.file.FileHelper
  • org.zkoss.zss.app.link.InsertHyperlinkWindowCtrl
  • org.zkoss.zss.app.RangeHelper
  • org.zkoss.zss.app.sheet.SheetHelper
  • org.zkoss.zss.app.test.InvalidateSpreadsheetComposer
  • org.zkoss.zss.app.zul.ctrl.SSWorkbookCtrl
    • 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.