Examples of ChangeInfo

Examples of org.zkoss.zss.engine.impl.ChangeInfo

935
936
937
938
939
940
941
942
943
944
        final int tRow = ref.getTopRow();
        final int lCol = ref.getLeftCol();
        final int bRow = ref.getBottomRow();
        final int rCol = ref.getRightCol();
        final Worksheet sheet = BookHelper.getSheet(_sheet, refSheet);
        final ChangeInfo info = BookHelper.unMerge(sheet, tRow, lCol, bRow, rCol);
        notifyMergeChange(refBook, info, ref, SSDataEvent.ON_CONTENTS_CHANGE, SSDataEvent.MOVE_NO);
      }
    }
  }
View Full Code Here

Examples of org.zkoss.zss.engine.impl.ChangeInfo

1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194
          for (int cr = colRepeat; cr > 0; --cr) {
            for (int srcCol = lCol; srcCol <= rCol; ++srcCol, ++dstCol) {
              final Cell cell = BookHelper.getCell(srcSheet, srcRow, srcCol);
              if (cell != null) {
                if (!skipBlanks || cell.getCellType() != Cell.CELL_TYPE_BLANK) {
                  final ChangeInfo changeInfo0 = BookHelper.copyCell(cell, dstSheet, dstRow, dstCol, pasteType, pasteOp, transpose);
                  BookHelper.assignChangeInfo(toEval, affected, mergeChanges, changeInfo0);
                }
              } else if (!skipBlanks) {
                final Set<Ref>[] refs = BookHelper.removeCell(dstSheet, dstRow, dstCol);
                BookHelper.assignRefs(toEval, affected, refs);
              }
            }
          }
        }
      }
    } else { //row -> column, column -> row
      int dstCol = dstRef.getLeftCol();
      for(int rr = rowRepeat; rr > 0; --rr) {
        for(int srcRow = tRow; srcRow <= bRow; ++srcRow, ++dstCol) {
          int dstRow = dstRef.getTopRow();
          for (int cr = colRepeat; cr > 0; --cr) {
            for (int srcCol = lCol; srcCol <= rCol; ++srcCol, ++dstRow) {
              final Cell cell = BookHelper.getCell(srcSheet, srcRow, srcCol);
              if (cell != null) {
                if (!skipBlanks || cell.getCellType() != Cell.CELL_TYPE_BLANK) {
                  final ChangeInfo changeInfo0 = BookHelper.copyCell(cell, dstSheet, dstRow, dstCol, pasteType, pasteOp, transpose);
                  BookHelper.assignChangeInfo(toEval, affected, mergeChanges, changeInfo0);
                }
              } else if (!skipBlanks) {
                final Set<Ref>[] refs = BookHelper.removeCell(dstSheet, dstRow, dstCol);
                BookHelper.assignRefs(toEval, affected, refs);
View Full Code Here

Examples of org.zkoss.zss.engine.impl.ChangeInfo

1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
        final int tRow = ref.getTopRow();
        final int lCol = ref.getLeftCol();
        final int bRow = ref.getBottomRow();
        final int rCol = ref.getRightCol();
        final Worksheet sheet = BookHelper.getSheet(_sheet, refSheet);
        final ChangeInfo info = BookHelper.moveRange(sheet, tRow, lCol, bRow, rCol, nRow, nCol);
        notifyMergeChange(refBook, info, ref, SSDataEvent.ON_CONTENTS_CHANGE, SSDataEvent.MOVE_NO);
      }
    }
  }
View Full Code Here

Examples of org.zkoss.zss.engine.impl.ChangeInfo

1351
1352
1353
1354
1355
1356
1357
1358
    all.add(new AreaRefImpl(tRow, lCol, bRow, rCol, BookHelper.getRefSheet(book, sheet)));
    BookHelper.reevaluateAndNotify(book, last, all);
  }
 
  private void fillRef(Ref srcRef, Ref dstRef, int fillType) {
    final ChangeInfo info = BookHelper.fill(_sheet, srcRef, dstRef, fillType);
    notifyMergeChange(dstRef.getOwnerSheet().getOwnerBook(), info, dstRef, SSDataEvent.ON_CONTENTS_CHANGE, SSDataEvent.MOVE_NO);
  }
View Full Code Here

Examples of org.zkoss.zss.engine.impl.ChangeInfo

131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
    assertEquals(12, valueC13.getNumberValue(), 0.0000000000000001);
    assertEquals(Cell.CELL_TYPE_NUMERIC, valueC13.getCellType());
    testToFormulaString(cellC13, "B12");
   
    //Sort A1:C12
    ChangeInfo info = BookHelper.sort(sheet1, 0, 0, 11, 2, ((RangeImpl)Utils.getRange(sheet1, 0, 0)).getRefs().iterator().next(), false,
        null, 0, false, null, false, BookHelper.SORT_HEADER_NO, 0, false, false, 0,
        BookHelper.SORT_NORMAL_DEFAULT, BookHelper.SORT_NORMAL_DEFAULT, BookHelper.SORT_NORMAL_DEFAULT);
    Set<Ref> last = info.getToEval();
    Set<Ref> all = info.getAffected();
    _evaluator.notifySetFormula(cellC13);

    assertEquals(1, row1.getCell(0).getNumericCellValue(), 0.0000000000000001); //A1: 1
    assertEquals(2, row2.getCell(0).getNumericCellValue(), 0.0000000000000001);  //A2: 2
    assertEquals(3, row3.getCell(0).getNumericCellValue(), 0.0000000000000001); //A3: 3
View Full Code Here

Examples of org.zkoss.zss.engine.impl.ChangeInfo

231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
    /*sort(Sheet sheet, int tRow, int lCol, int bRow, int rCol,
        Ref key1, boolean desc1, Ref key2, int type, boolean desc2, Ref key3, boolean desc3, int header, int orderCustom,
        boolean matchCase, boolean sortByRows, int sortMethod, int dataOption1, int dataOption2, int dataOption3) */

    //Sort A15:L17
    ChangeInfo info = BookHelper.sort(sheet1, 14, 0, 16, 11, ((RangeImpl)Utils.getRange(sheet1, 14, 0)).getRefs().iterator().next(), false,
        null, 0, false, null, false, BookHelper.SORT_HEADER_NO, 0, false, true, 0,
        BookHelper.SORT_NORMAL_DEFAULT, BookHelper.SORT_NORMAL_DEFAULT, BookHelper.SORT_NORMAL_DEFAULT);
    Set<Ref> last = info.getToEval();
    Set<Ref> all = info.getAffected();
    _evaluator.notifySetFormula(cellM17);

    assertEquals(1, row15.getCell(0).getNumericCellValue(), 0.0000000000000001); //A15: 1
    assertEquals(2, row15.getCell(1).getNumericCellValue(), 0.0000000000000001); //B15: 2
    assertEquals(3, row15.getCell(2).getNumericCellValue(), 0.0000000000000001); //C15: 3
View Full Code Here

Examples of org.zkoss.zss.engine.impl.ChangeInfo

133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
    assertEquals(12, valueC13.getNumberValue(), 0.0000000000000001);
    assertEquals(Cell.CELL_TYPE_NUMERIC, valueC13.getCellType());
    testToFormulaString(cellC13, "B12");
   
    //Sort A1:C12
    ChangeInfo info = BookHelper.sort(sheet1, 0, 0, 11, 2, ((RangeImpl)Utils.getRange(sheet1, 0, 0)).getRefs().iterator().next(), false,
        null, 0, false, null, false, BookHelper.SORT_HEADER_NO, 0, false, false, 0,
        BookHelper.SORT_NORMAL_DEFAULT, BookHelper.SORT_NORMAL_DEFAULT, BookHelper.SORT_NORMAL_DEFAULT);
    Set<Ref> last = info.getToEval();
    Set<Ref> all = info.getAffected();
    _evaluator.notifySetFormula(cellC13);

    assertEquals(1, row1.getCell(0).getNumericCellValue(), 0.0000000000000001); //A1: 1
    assertEquals(2, row2.getCell(0).getNumericCellValue(), 0.0000000000000001);  //A2: 2
    assertEquals(3, row3.getCell(0).getNumericCellValue(), 0.0000000000000001); //A3: 3
View Full Code Here

Examples of org.zkoss.zss.engine.impl.ChangeInfo

233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
    /*sort(Sheet sheet, int tRow, int lCol, int bRow, int rCol,
        Ref key1, boolean desc1, Ref key2, int type, boolean desc2, Ref key3, boolean desc3, int header, int orderCustom,
        boolean matchCase, boolean sortByRows, int sortMethod, int dataOption1, int dataOption2, int dataOption3) */

    //Sort A15:L17
    ChangeInfo info = BookHelper.sort(sheet1, 14, 0, 16, 11, ((RangeImpl)Utils.getRange(sheet1, 14, 0)).getRefs().iterator().next(), false,
        null, 0, false, null, false, BookHelper.SORT_HEADER_NO, 0, false, true, 0,
        BookHelper.SORT_NORMAL_DEFAULT, BookHelper.SORT_NORMAL_DEFAULT, BookHelper.SORT_NORMAL_DEFAULT);
    Set<Ref> last = info.getToEval();
    Set<Ref> all = info.getAffected();
    _evaluator.notifySetFormula(cellM17);

    assertEquals(1, row15.getCell(0).getNumericCellValue(), 0.0000000000000001); //A15: 1
    assertEquals(2, row15.getCell(1).getNumericCellValue(), 0.0000000000000001); //B15: 2
    assertEquals(3, row15.getCell(2).getNumericCellValue(), 0.0000000000000001); //C15: 3
View Full Code Here

Examples of org.zkoss.zss.engine.impl.ChangeInfo

2326
2327
2328
2329
2330
2331
2332
    int nbRow = Math.min(maxrow, bRow + nRow);
    int nrCol = Math.min(maxcol, rCol + nCol);
    if (ntRow <= nbRow && nlCol <= nrCol)
    all.add(new AreaRefImpl(ntRow, nlCol, nbRow, nrCol, refSheet));
   
    return new ChangeInfo(last, all, changeMerges);
  }
View Full Code Here

Examples of org.zkoss.zss.engine.impl.ChangeInfo

2355
2356
2357
2358
2359
2360
2361
    int nbRow = Math.min(maxrow, bRow + nRow);
    int nrCol = Math.min(maxcol, rCol + nCol);
    if (ntRow <= nbRow && nlCol <= nrCol)
    all.add(new AreaRefImpl(ntRow, nlCol, nbRow, nrCol, refSheet));
   
    return new ChangeInfo(last, all, changeMerges);
  }
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.