Package org.zkoss.zss.engine

Examples of org.zkoss.zss.engine.RefSheet

321
322
323
324
325
326
327
328
329
330
331
    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);
       
        final Object[] values = BookHelper.editTextToValue(txt, cell);
        final Worksheet sheet = BookHelper.getSheet(_sheet, refSheet);
       
View Full Code Here
343
344
345
346
347
348
349
350
351
352
353
    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);
       
        final Object[] values = BookHelper.editTextToValue(txt, cell);
        final Worksheet sheet = BookHelper.getSheet(_sheet, refSheet);
       
View Full Code Here
391
392
393
394
395
396
397
398
399
400
401
    for(Ref ref : _refs) {
      final int tRow = ref.getTopRow();
      final int lCol = ref.getLeftCol();
      final int bRow = ref.getBottomRow();
      final int rCol = ref.getRightCol();
      final RefSheet refSheet = ref.getOwnerSheet();
      final Worksheet sheet = BookHelper.getSheet(_sheet, refSheet);
      final Workbook book = sheet.getWorkbook();
     
      for(int row = tRow; row <= bRow; ++row) {
        for (int col = lCol; col <= rCol; ++col) {
View Full Code Here
663
664
665
666
667
668
669
670
671
672
673
674
  @Override
  public void delete(int shift) {
    synchronized(_sheet) {
      if (_refs != null && !_refs.isEmpty()) {
        final Ref ref = _refs.iterator().next();
        final RefSheet refSheet = ref.getOwnerSheet();
        final RefBook refBook = refSheet.getOwnerBook();
        final Worksheet sheet = BookHelper.getSheet(_sheet, refSheet);
        if (!((SheetCtrl)sheet).isEvalAll()) {
          ((SheetCtrl)sheet).evalAll();
        }
        switch(shift) {
View Full Code Here
706
707
708
709
710
711
712
713
714
715
716
717
  @Override
  public void insert(int shift, int copyOrigin) {
    synchronized(_sheet) {
      if (_refs != null && !_refs.isEmpty()) {
        final Ref ref = _refs.iterator().next();
        final RefSheet refSheet = ref.getOwnerSheet();
        final RefBook refBook = refSheet.getOwnerBook();
        final Worksheet sheet = BookHelper.getSheet(_sheet, refSheet);
        if (!((SheetCtrl)sheet).isEvalAll()) {
          ((SheetCtrl)sheet).evalAll();
        }
        switch(shift) {
View Full Code Here
910
911
912
913
914
915
916
917
918
919
920
921
  @Override
  public void merge(boolean across) {
    synchronized (_sheet) {
      if (_refs != null && !_refs.isEmpty()) {
        final Ref ref = _refs.iterator().next();
        final RefSheet refSheet = ref.getOwnerSheet();
        final RefBook refBook = refSheet.getOwnerBook();
        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);
View Full Code Here
928
929
930
931
932
933
934
935
936
937
938
939
  @Override
  public void unMerge() {
    synchronized (_sheet) {
      if (_refs != null && !_refs.isEmpty()) {
        final Ref ref = _refs.iterator().next();
        final RefSheet refSheet = ref.getOwnerSheet();
        final RefBook refBook = refSheet.getOwnerBook();
        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);
View Full Code Here
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
  @Override
  public boolean isAnyCellProtected() {
    synchronized (_sheet) {
      final Ref ref = _refs != null && !_refs.isEmpty() ? _refs.iterator().next() : null;
      if (ref != null) {
        final RefSheet refSheet = ref.getOwnerSheet();
        final int left = ref.getLeftCol();
        final int right = ref.getRightCol();
        final int top = ref.getTopRow();
        final int bottom = ref.getBottomRow();
       
View Full Code Here
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
      return true;
    }
  }
 
  private Ref getPasteRef(int srcRowCount, int srcColCount, int rowRepeat, int colRepeat, Ref dstRef, boolean transpose) {
    final RefSheet dstRefSheet = dstRef.getOwnerSheet();
    final int dstT = dstRef.getTopRow();
    final int dstL = dstRef.getLeftCol();
    final int dstRowCount = transpose ? srcColCount * colRepeat : srcRowCount * rowRepeat;
    final int dstColCount = transpose ? srcRowCount * rowRepeat : srcColCount * colRepeat;
    final int dstB = dstT + dstRowCount - 1;
View Full Code Here
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
      final int widthRepeatCount = srcRef.getColumnCount();
      copyColumnWidths(srcSheet, widthRepeatCount, srclCol, pasteRef);
      return pasteRef;
    }
   
    final RefSheet dstSheet = dstRef.getOwnerSheet();
    final int tRow = dstRef.getTopRow();
    final int lCol = dstRef.getLeftCol();
    if (!transpose) {
      final int bRow = tRow + srcRowCount - 1;
      final int rCol = lCol + srcColCount - 1;
View Full Code Here
TOP

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

  • org.zkoss.poi.ss.formula.DefaultDependencyTracker
  • org.zkoss.zss.engine.impl.RefBookImpl
  • org.zkoss.zss.model.impl.BookHelper
  • org.zkoss.zss.model.impl.RangeImpl
  • org.zkoss.zss.model.impl.RangeImpl$ValueSetter
    • 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.