Package org.zkoss.zss.engine

Examples of org.zkoss.zss.engine.Ref

2208
2209
2210
2211
2212
2213
2214
2215
2216
2217
2218
2219
2220
2221
2222
2223
2224
2225
2226
2227
        bottom = lastrow;
      }
      org.zkoss.zk.ui.event.Events.postEvent(new CellSelectionEvent(Events.ON_CELL_CHANGE, Spreadsheet.this, sheet, CellSelectionEvent.SELECT_CELLS, left, top, right,  bottom));
    }
    private void onRangeInsert(SSDataEvent event) {
      final Ref rng = event.getRef();
      final Worksheet sheet = getSheet(rng);
      if (!getSelectedSheet().equals(sheet))
        return;
      _updateCellId.next();
      if (rng.isWholeColumn()) {
        final int left = rng.getLeftCol();
        final int right = rng.getRightCol();
        ((ExtraCtrl) getExtraCtrl()).insertColumns(sheet, left, right - left + 1);
      } else if (rng.isWholeRow()) {
        final int top = rng.getTopRow();
        final int bottom = rng.getBottomRow();
        ((ExtraCtrl) getExtraCtrl()).insertRows(sheet, top, bottom - top + 1);
      }
    }
View Full Code Here
2224
2225
2226
2227
2228
2229
2230
2231
2232
2233
2234
2235
2236
2237
2238
2239
2240
2241
2242
2243
2244
        final int bottom = rng.getBottomRow();
        ((ExtraCtrl) getExtraCtrl()).insertRows(sheet, top, bottom - top + 1);
      }
    }
    private void onRangeDelete(SSDataEvent event) {
      final Ref rng = event.getRef();
      final Worksheet sheet = getSheet(rng);
      if (!getSelectedSheet().equals(sheet))
        return;
      _updateCellId.next();
      if (rng.isWholeColumn()) {
        final int left = rng.getLeftCol();
        final int right = rng.getRightCol();
        ((ExtraCtrl) getExtraCtrl()).removeColumns(sheet, left,
            right - left + 1);
      } else if (rng.isWholeRow()) {
        final int top = rng.getTopRow();
        final int bottom = rng.getBottomRow();
        ((ExtraCtrl) getExtraCtrl()).removeRows(sheet, top, bottom - top + 1);
      }
    }
View Full Code Here
2241
2242
2243
2244
2245
2246
2247
2248
2249
2250
2251
2252
2253
2254
        final int bottom = rng.getBottomRow();
        ((ExtraCtrl) getExtraCtrl()).removeRows(sheet, top, bottom - top + 1);
      }
    }
    private void onMergeChange(SSDataEvent event) {
      final Ref rng = event.getRef();
      final Ref orng = event.getOriginalRef();
      final Worksheet sheet = getSheet(orng);
      if (!getSelectedSheet().equals(sheet))
        return;
      ((ExtraCtrl) getExtraCtrl()).updateMergeCell(sheet,
          rng.getLeftCol(), rng.getTopRow(), rng.getRightCol(), rng.getBottomRow(),
          orng.getLeftCol(), orng.getTopRow(), orng.getRightCol(), orng.getBottomRow());
    }
View Full Code Here
2251
2252
2253
2254
2255
2256
2257
2258
2259
2260
2261
2262
2263
      ((ExtraCtrl) getExtraCtrl()).updateMergeCell(sheet,
          rng.getLeftCol(), rng.getTopRow(), rng.getRightCol(), rng.getBottomRow(),
          orng.getLeftCol(), orng.getTopRow(), orng.getRightCol(), orng.getBottomRow());
    }
    private void onMergeAdd(SSDataEvent event) {
      final Ref rng = event.getRef();
      final Worksheet sheet = getSheet(rng);
      if (!getSelectedSheet().equals(sheet))
        return;
      ((ExtraCtrl) getExtraCtrl()).addMergeCell(sheet,
          rng.getLeftCol(), rng.getTopRow(), rng.getRightCol(), rng.getBottomRow());

    }
View Full Code Here
2260
2261
2262
2263
2264
2265
2266
2267
2268
2269
2270
2271
      ((ExtraCtrl) getExtraCtrl()).addMergeCell(sheet,
          rng.getLeftCol(), rng.getTopRow(), rng.getRightCol(), rng.getBottomRow());

    }
    private void onMergeDelete(SSDataEvent event) {
      final Ref orng = event.getRef();
      final Worksheet sheet = getSheet(orng);
      if (!getSelectedSheet().equals(sheet))
        return;
      ((ExtraCtrl) getExtraCtrl()).deleteMergeCell(sheet, orng.getLeftCol(),
          orng.getTopRow(), orng.getRightCol(), orng.getBottomRow());
    }
View Full Code Here
2269
2270
2271
2272
2273
2274
2275
2276
2277
2278
2279
2280
2281
2282
2283
2284
2285
2286
2287
2288
2289
2290
2291
2292
2293
      ((ExtraCtrl) getExtraCtrl()).deleteMergeCell(sheet, orng.getLeftCol(),
          orng.getTopRow(), orng.getRightCol(), orng.getBottomRow());
    }
    private void onSizeChange(SSDataEvent event) {
      //TODO shall pass the range over to the client side and let client side do it; rather than iterate each column and send multiple command
      final Ref rng = event.getRef();
      final Worksheet sheet = getSheet(rng);
      if (!getSelectedSheet().equals(sheet))
        return;
      if (rng.isWholeColumn()) {
        final int left = rng.getLeftCol();
        final int right = rng.getRightCol();
        for (int c = left; c <= right; ++c) {
          updateColWidth(sheet, c);
        }
        final Rect rect = ((SpreadsheetCtrl) getExtraCtrl()).getVisibleRect();
        syncFriendFocusesPosition(left, rect.getTop(), rect.getRight(), rect.getBottom());
      } else if (rng.isWholeRow()) {
        final int top = rng.getTopRow();
        final int bottom = rng.getBottomRow();
        for (int r = top; r <= bottom; ++r) {
          updateRowHeight(sheet, r);
        }
        final Rect rect = ((SpreadsheetCtrl) getExtraCtrl()).getVisibleRect();
        syncFriendFocusesPosition(rect.getLeft(), top, rect.getRight(), rect.getBottom());
View Full Code Here
2292
2293
2294
2295
2296
2297
2298
2299
2300
2301
2302
        final Rect rect = ((SpreadsheetCtrl) getExtraCtrl()).getVisibleRect();
        syncFriendFocusesPosition(rect.getLeft(), top, rect.getRight(), rect.getBottom());
      }
    }
    private void onBtnChange(SSDataEvent event) {
      final Ref rng = event.getRef();
      final Worksheet sheet = getSheet(rng);
      if (!getSelectedSheet().equals(sheet))
        return;
      updateAutoFilter(sheet.getAutoFilter());
    }
View Full Code Here
2299
2300
2301
2302
2303
2304
2305
2306
2307
2308
2309
      if (!getSelectedSheet().equals(sheet))
        return;
      updateAutoFilter(sheet.getAutoFilter());
    }
    private void onDisplayGridlines(SSDataEvent event) {
      final Ref rng = event.getRef();
      final Worksheet sheet = getSheet(rng);
      if (!getSelectedSheet().equals(sheet))
        return;
      setDisplayGridlines(event.isShow());
    }
View Full Code Here
2306
2307
2308
2309
2310
2311
2312
2313
2314
2315
2316
      if (!getSelectedSheet().equals(sheet))
        return;
      setDisplayGridlines(event.isShow());
    }
    private void onProtectSheet(SSDataEvent event) {
      final Ref rng = event.getRef();
      final Worksheet sheet = getSheet(rng);
      if (!getSelectedSheet().equals(sheet))
        return;
      setProtectSheet(event.getProtect());
    }
View Full Code Here
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
  }

  @Override
  public Hyperlink getHyperlink() {
    synchronized(_sheet) {
      Ref ref = _refs != null && !_refs.isEmpty() ? _refs.iterator().next() : null;
      if (ref != null) {
        final int tRow = ref.getTopRow();
        final int lCol = ref.getLeftCol();
        final RefSheet refSheet = ref.getOwnerSheet();
        final Cell cell = getCell(tRow, lCol, refSheet);
        if (cell != null)
          return BookHelper.getHyperlink(cell);
      }
      return null;
View Full Code Here
TOP

Related Classes of org.zkoss.zss.engine.Ref

  • org.zkoss.zss.engine.impl.AbstractRefImpl
  • org.zkoss.zss.engine.impl.DependencyTrackerHelper
  • org.zkoss.zss.engine.impl.RefBookImpl
  • org.zkoss.zss.engine.impl.RefSheetImpl
  • org.zkoss.zss.engine.impl.RefSheetTest
  • org.zkoss.zss.model.impl.Book01XlsFormulaHitTest
  • org.zkoss.zss.model.impl.BookHelper
  • org.zkoss.zss.model.impl.RangeImpl
  • org.zkoss.zss.ui.Spreadsheet$InnerDataListener
    • 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.