Package org.zkoss.poi.hssf.record

Examples of org.zkoss.poi.hssf.record.NoteRecord


            //  destination row. Note that comments can
            //  exist for cells which are null
            if(moveComments) {
                // This code would get simpler if NoteRecords could be organised by HSSFRow.
                for(int i=noteRecs.length-1; i>=0; i--) {
                    NoteRecord nr = noteRecs[i];
                    if (nr.getRow() != rowNum) {
                        continue;
                    }
                    HSSFComment comment = getCellComment(rowNum, nr.getColumn());
                    if (comment != null) {
                       comment.setRow(rowNum + n);
                    }
                }
            }
View Full Code Here


              // Move comments from the source column to the
              //  destination column. Note that comments can
              //  exist for cells which are null
              if(moveComments) {
                  for(int i=noteRecs.length-1; i>=0; i--) {
                      NoteRecord nr = noteRecs[i];
                      if (nr.getColumn() != colNum) {
                          continue;
                      }
                      HSSFComment comment = getCellComment(nr.getRow(), colNum);
                      if (comment != null) {
                         comment.setColumn(newColNum);
                      }
                  }
              }
View Full Code Here

              // Move comments from the source column to the
              //  destination column. Note that comments can
              //  exist for cells which are null
              if(moveComments) {
                  for(int i=noteRecs.length-1; i>=0; i--) {
                      NoteRecord nr = noteRecs[i];
                      if (nr.getColumn() != colNum || nr.getRow() < tRow || nr.getRow() > bRow) { //not in range
                          continue;
                      }
                      HSSFComment comment = getCellComment(nr.getRow(), colNum);
                      if (comment != null) {
                         comment.setColumn(newColNum);
                      }
                  }
              }
View Full Code Here

            //  destination row. Note that comments can
            //  exist for cells which are null
            if(moveComments) {
                // This code would get simpler if NoteRecords could be organised by HSSFRow.
                for(int i=noteRecs.length-1; i>=0; i--) {
                    NoteRecord nr = noteRecs[i];
                    if (nr.getRow() != rowNum || nr.getColumn() < lCol || nr.getColumn() > rCol) {
                        continue;
                    }
                    HSSFComment comment = getCellComment(rowNum, nr.getColumn());
                    if (comment != null) {
                       comment.setRow(rowNum + n);
                    }
                }
            }
View Full Code Here

            //  destination row. Note that comments can
            //  exist for cells which are null
            if(moveComments) {
                // This code would get simpler if NoteRecords could be organised by HSSFRow.
                for(int i=noteRecs.length-1; i>=0; i--) {
                    NoteRecord nr = noteRecs[i];
                    if (nr.getRow() != rowNum || nr.getColumn() < lCol || nr.getColumn() > rCol) {
                        continue;
                    }
                    HSSFComment comment = getCellComment(rowNum, nr.getColumn());
                    if (comment != null) {
                      comment.setRow(rowNum + nRow);
                      int colNum = nr.getColumn()+nCol;
                      if (colNum >= 0 && colNum <= maxcol) {
                        comment.setColumn(colNum);
                      }
                    }
                }
View Full Code Here

TOP

Related Classes of org.zkoss.poi.hssf.record.NoteRecord

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.