Package org.zkoss.poi.ss.util

Examples of org.zkoss.poi.ss.util.CellReference.formatAsString()

182
183
184
185
186
187
188
189
190
191
192
                  CTCommentList lst = sheetComments.getCTComments().getCommentList();
                  for (CTComment comment : lst.getCommentArray()) {
                      CellReference ref = new CellReference(comment.getRef());
                      if(ref.getRow() == rownum){
                          ref = new CellReference(rownum + n, ref.getCol());
                          comment.setRef(ref.formatAsString());
                      }
                  }
              }
            }
        }
View Full Code Here
397
398
399
400
401
402
403
404
405
406
407
                  for (CTComment comment : lst.getCommentArray()) {
                      CellReference ref = new CellReference(comment.getRef());
                      final int colnum = ref.getCol();
                      if(ref.getRow() == rownum && lCol <= colnum && colnum <= rCol){
                          ref = new CellReference(rownum + n, colnum);
                          comment.setRef(ref.formatAsString());
                      }
                  }
              }
            }
        }
View Full Code Here
630
631
632
633
634
635
636
637
638
639
640
                      int newColNum = colnum + n;
                      if (newColNum < 0 || newColNum > maxcol) { //out of bound, shall remove it
                        it.remove();
                      } else {
                          ref = new CellReference(ref.getRow(), newColNum);
                          comment.setRef(ref.formatAsString());
                      }
                    }
                }
            }
        }
View Full Code Here
923
924
925
926
927
928
929
930
931
932
933
                      int newColNum = colnum + n;
                      if (newColNum < 0 || newColNum > maxcol) { //out of bound, shall remove it
                        it.remove();
                      } else {
                          ref = new CellReference(ref.getRow(), newColNum);
                          comment.setRef(ref.formatAsString());
                      }
                    }
                }
            }
        }
View Full Code Here
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
                      if (newColNum < 0 || newColNum > maxcol
                        || newRowNum < 0 || newRowNum > maxrow) { //out of bound, shall remove it
                        it.remove();
                      } else {
                          ref = new CellReference(newRowNum, newColNum);
                          comment.setRef(ref.formatAsString());
                      }
                    }
                }
            }
        }
View Full Code Here
4705
4706
4707
4708
4709
4710
4711
4712
4713
4714
4715
        CellReference cellRefTo = new CellReference(cra.getLastRow(), cra.getLastColumn(),true,true);
        sb.append(cellRefFrom.formatAsString());
        //for a single-cell reference return A1 instead of A1:A1
        if(!cellRefFrom.equals(cellRefTo)){
            sb.append(':');
            sb.append(cellRefTo.formatAsString());
        }
        return sb.toString();
  }

  //20110512, peterkuo@potix.com
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.