Package org.apache.poi.hssf.usermodel

Examples of org.apache.poi.hssf.usermodel.HSSFComment

76
77
78
79
80
81
82
83
84
85
86
                      }
                    } else if (celltype == HSSFCell.CELL_TYPE_NUMERIC) {
                      double num = cell.getNumericCellValue();
                      contents = contents + num + ",";
                    }
                    HSSFComment comm = cell.getCellComment();
                    if (comm != null) {
                      contents = contents + comm + ",";
                    }

                  }
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
121
                    iterator.remove();
                    break;
            }
        }

        HSSFComment comment = (HSSFComment)shape;
        opt.addEscherProperty( new EscherSimpleProperty( EscherProperties.GROUPSHAPE__PRINT, comment.isVisible() ? 0x000A0000 : 0x000A0002) );
        opt.addEscherProperty( new EscherSimpleProperty( EscherProperties.SHADOWSTYLE__SHADOWOBSURED, 0x00030003 ) );
        opt.addEscherProperty( new EscherSimpleProperty( EscherProperties.SHADOWSTYLE__COLOR, 0x00000000 ) );
        opt.sortProperties();
        return opt.getEscherProperties().size();   // # options added
    }
View Full Code Here
117
118
119
120
121
122
123
124
125
126
127
128
                    iterator.remove();
                    break;
            }
        }

        HSSFComment comment = (HSSFComment)shape;
        opt.addEscherProperty( new EscherSimpleProperty( EscherProperties.GROUPSHAPE__PRINT, comment.isVisible() ? 0x000A0000 : 0x000A0002) );
        opt.addEscherProperty( new EscherSimpleProperty( EscherProperties.SHADOWSTYLE__SHADOWOBSURED, 0x00030003 ) );
        opt.addEscherProperty( new EscherSimpleProperty( EscherProperties.SHADOWSTYLE__COLOR, 0x00000000 ) );
        opt.sortProperties();
        return opt.getEscherProperties().size();   // # options added
    }
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
121
                    iterator.remove();
                    break;
            }
        }

        HSSFComment comment = (HSSFComment)shape;
        opt.addEscherProperty( new EscherSimpleProperty( EscherProperties.GROUPSHAPE__PRINT, comment.isVisible() ? 0x000A0000 : 0x000A0002) );
        opt.addEscherProperty( new EscherSimpleProperty( EscherProperties.SHADOWSTYLE__SHADOWOBSURED, 0x00030003 ) );
        opt.addEscherProperty( new EscherSimpleProperty( EscherProperties.SHADOWSTYLE__COLOR, 0x00000000 ) );
        opt.sortProperties();
        return opt.getEscherProperties().size();   // # options added
    }
View Full Code Here
117
118
119
120
121
122
123
124
125
126
127
128
                    iterator.remove();
                    break;
            }
        }

        HSSFComment comment = (HSSFComment)shape;
        opt.addEscherProperty( new EscherSimpleProperty( EscherProperties.GROUPSHAPE__PRINT, comment.isVisible() ? 0x000A0000 : 0x000A0002) );
        opt.addEscherProperty( new EscherSimpleProperty( EscherProperties.SHADOWSTYLE__SHADOWOBSURED, 0x00030003 ) );
        opt.addEscherProperty( new EscherSimpleProperty( EscherProperties.SHADOWSTYLE__COLOR, 0x00000000 ) );
        opt.sortProperties();
        return opt.getEscherProperties().size();   // # options added
    }
View Full Code Here
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
              default:
                throw new RuntimeException("Unexpected cell type (" + cell.getCellType() + ")");
            }
           
            // Output the comment, if requested and exists
            HSSFComment comment = cell.getCellComment();
            if(_includeCellComments && comment != null) {
              // Replace any newlines with spaces, otherwise it
              //  breaks the output
              String commentText = comment.getString().getString().replace('\n', ' ');
              text.append(" Comment by "+comment.getAuthor()+": "+commentText);
            }
          }
         
          // Output a tab if we're not on the last cell
          if(outputContents && k < (lastCell-1)) {
View Full Code Here
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
              default:
                throw new RuntimeException("Unexpected cell type (" + cell.getCellType() + ")");
            }
           
            // Output the comment, if requested and exists
            HSSFComment comment = cell.getCellComment();
            if(_includeCellComments && comment != null) {
              // Replace any newlines with spaces, otherwise it
              //  breaks the output
              String commentText = comment.getString().getString().replace('\n', ' ');
              text.append(" Comment by "+comment.getAuthor()+": "+commentText);
            }
          }
         
          // Output a tab if we're not on the last cell
          if(outputContents && k < (lastCell-1)) {
View Full Code Here
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
                if (sourceObj instanceof ReportElementHandle) {
                    String comments = ((ReportElementHandle) sourceObj).getComments();

                    if (comments != null && comments.length() > 0) {
                        HSSFComment hssfcomment = patriarch.createComment(new HSSFClientAnchor(0,
                                0,
                                0,
                                0,
                                (short) commentsAnchorColumnIndex,
                                commentsAnchorRowIndex,
                                (short) (commentsAnchorColumnIndex + COMMENTS_WIDTH_IN_COLUMN),
                                commentsAnchorRowIndex + COMMENTS_HEIGHT_IN_ROW));
                        hssfcomment.setString(new HSSFRichTextString(comments));

                        cell.setCellComment(hssfcomment);

                        return true;
                    }
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
121
                    iterator.remove();
                    break;
            }
        }

        HSSFComment comment = (HSSFComment)shape;
        opt.addEscherProperty( new EscherSimpleProperty( EscherProperties.GROUPSHAPE__PRINT, comment.isVisible() ? 0x000A0000 : 0x000A0002) );
        opt.addEscherProperty( new EscherSimpleProperty( EscherProperties.SHADOWSTYLE__SHADOWOBSURED, 0x00030003 ) );
        opt.addEscherProperty( new EscherSimpleProperty( EscherProperties.SHADOWSTYLE__COLOR, 0x00000000 ) );
        opt.sortProperties();
        return opt.getEscherProperties().size();   // # options added
    }
View Full Code Here
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
              outputContents = true;
              break;
          }
         
          // Output the comment, if requested and exists
            HSSFComment comment = cell.getCellComment();
          if(includeCellComments && comment != null) {
              // Replace any newlines with spaces, otherwise it
              //  breaks the output
              String commentText = comment.getString().getString().replace('\n', ' ');
              text.append(" Comment by "+comment.getAuthor()+": "+commentText);
          }
         
          // Output a tab if we're not on the last cell
          if(outputContents && k < (lastCell-1)) {
            text.append("\t");
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.usermodel.HSSFComment

  • com.gentics.cr.lucene.indexer.transformer.xls.XLSContentTransformer
  • org.apache.poi.ddf.DefaultEscherRecordFactory
  • org.apache.poi.ddf.EscherBSERecord
  • org.apache.poi.ddf.EscherContainerRecord
  • org.apache.poi.ddf.EscherOptRecord
  • org.apache.poi.ddf.EscherSimpleProperty
  • org.apache.poi.hssf.extractor.ExcelExtractor
  • org.apache.poi.hssf.model.CommentShape
  • org.apache.poi.hssf.model.TestShapes
  • org.apache.poi.hssf.record.CommonObjectDataSubRecord
    • 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.