Examples of XSSFComment

Examples of org.apache.poi.xssf.usermodel.XSSFComment

135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
      throw new AssertionFailedError("didn't find comments table");
    }
    assertEquals(2, ct.getNumberOfComments());
    assertEquals(1, ct.getNumberOfAuthors());

    XSSFComment comment = ct.findCellComment("C5");

    assertEquals("Nick Burch", comment.getAuthor());
    assertEquals("Nick Burch:\nThis is a comment", comment.getString().getString());

    wb = XSSFTestDataSamples.writeOutAndReadBack(wb);
    rels = wb.getSheetAt(0).getRelations();
    ct = null;
    for(POIXMLDocumentPart p : rels) {
      if(p instanceof CommentsTable){
        ct = (CommentsTable)p;
        break;
      }
    }
    if (ct == null) {
      throw new AssertionFailedError("didn't find comments table");
    }

    assertEquals(2, ct.getNumberOfComments());
    assertEquals(1, ct.getNumberOfAuthors());

    comment = ct.findCellComment("C5");

    assertEquals("Nick Burch", comment.getAuthor());

    assertEquals("Nick Burch:\nThis is a comment", comment.getString().getString());
  }
View Full Code Here

Examples of org.apache.poi.xssf.usermodel.XSSFComment

93
94
95
96
97
98
99
100
101
102
    }

    public XSSFComment findCellComment(String cellRef) {
        for (CTComment comment : getCommentsList().getCommentArray()) {
            if (cellRef.equals(comment.getRef())) {
                return new XSSFComment(this, comment);
            }
        }
        return null;
    }
View Full Code Here

Examples of org.apache.poi.xssf.usermodel.XSSFComment

104
105
106
107
108
109
110
    /**
     * Generates a new XSSFComment, associated with the
     *  current comments list.
     */
    public XSSFComment addComment() {
        return new XSSFComment(this, getCommentsList().addNewComment());
    }
View Full Code Here

Examples of org.apache.poi.xssf.usermodel.XSSFComment

107
108
109
110
111
112
113
        return addNewAuthor(author);
    }

    public XSSFComment findCellComment(String cellRef) {
        CTComment ct = getCTComment(cellRef);
        return ct == null ? null : new XSSFComment(this, ct, null);
    }
View Full Code Here

Examples of org.apache.poi.xssf.usermodel.XSSFComment

107
108
109
110
111
112
113
        return addNewAuthor(author);
    }

    public XSSFComment findCellComment(String cellRef) {
        CTComment ct = getCTComment(cellRef);
        return ct == null ? null : new XSSFComment(this, ct, null);
    }
View Full Code Here

Examples of org.apache.poi.xssf.usermodel.XSSFComment

94
95
96
97
98
99
100
101
102
103
  }
 
  public XSSFComment findCellComment(String cellRef) {
    for (CTComment comment : getCommentsList().getCommentArray()) {
      if (cellRef.equals(comment.getRef())) {
        return new XSSFComment(this, comment);
      }
    }
    return null;
  }
View Full Code Here

Examples of org.apache.poi.xssf.usermodel.XSSFComment

105
106
107
108
109
110
111
  /**
   * Generates a new XSSFComment, associated with the
   *  current comments list.
   */
  public XSSFComment addComment() {
    return new XSSFComment(this, getCommentsList().addNewComment());
  }
View Full Code Here

Examples of org.apache.poi.xssf.usermodel.XSSFComment

88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
    CTComments comments = CTComments.Factory.newInstance();
    CommentsTable sheetComments = new CommentsTable(comments);
    CTCommentList commentList = comments.addNewCommentList();
    assertEquals(0, commentList.sizeOfCommentArray());
   
    XSSFComment comment = sheetComments.addComment();
    comment.setAuthor("test A1 author");
    comment.setRow(0);
    comment.setColumn((short)0);
   
    assertEquals(1, commentList.sizeOfCommentArray());
    assertEquals("test A1 author", sheetComments.getAuthor(commentList.getCommentArray(0).getAuthorId()));
    assertEquals("test A1 author", comment.getAuthor());
   
    // Change the author, check it updates
    comment.setAuthor("Another Author");
    assertEquals(1, commentList.sizeOfCommentArray());
    assertEquals("Another Author", comment.getAuthor());
  }
View Full Code Here

Examples of org.apache.poi.xssf.usermodel.XSSFComment

119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
   
    CommentsTable ct = new CommentsTable(cpart.getInputStream());
    assertEquals(2, ct.getNumberOfComments());
    assertEquals(1, ct.getNumberOfAuthors());

    XSSFComment comment = ct.findCellComment("C5");
   
    assertEquals("Nick Burch", comment.getAuthor());
    assertEquals("Nick Burch:\nThis is a comment", comment.getString().getString());
   
    // Re-serialise
    ByteArrayOutputStream baos = new ByteArrayOutputStream();
    ct.writeTo(baos);
    ByteArrayInputStream bais = new ByteArrayInputStream(baos.toByteArray());
    ct = new CommentsTable(bais);
   
    assertEquals(2, ct.getNumberOfComments());
    assertEquals(1, ct.getNumberOfAuthors());
   
    comment = ct.findCellComment("C5");
   
    assertEquals("Nick Burch", comment.getAuthor());
   
    // TODO: Fix this!
    // New line should still be there, but isn't!
    //assertEquals("Nick Burch:\nThis is a comment", comment.getString().getString());
  }
View Full Code Here

Examples of org.apache.poi.xssf.usermodel.XSSFComment

107
108
109
110
111
112
113
        return addNewAuthor(author);
    }

    public XSSFComment findCellComment(String cellRef) {
        CTComment ct = getCTComment(cellRef);
        return ct == null ? null : new XSSFComment(this, ct, null);
    }
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.