Package org.apache.poi.hssf.usermodel

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

103
104
105
106
107
108
109
110
111
112
113
        XSSFSheet sh = wb.createSheet();
        XSSFComment comment = sh.createDrawingPatriarch().createCellComment(new XSSFClientAnchor());

        //passing HSSFRichTextString is incorrect
        try {
            comment.setString(new HSSFRichTextString(TEST_RICHTEXTSTRING));
            fail("expected exception");
        } catch (IllegalArgumentException e){
            assertEquals("Only XSSFRichTextString argument is supported", e.getMessage());
        }
View Full Code Here
742
743
744
745
746
747
748
749
750
751
752
        DrawingRecord d2 = new DrawingRecord();
        d2.setData( HexRead.readFromString( msoDrawingRecord2 ) );

        TextObjectRecord r2 = new TextObjectRecord();
        r2.setStr(new HSSFRichTextString("Aggregated"));
        NoteRecord n2 = new NoteRecord();

        List<Record> recordStream = new ArrayList<Record>();
        recordStream.add(InternalSheet.createBOF());
        recordStream.add( d1 );
View Full Code Here
92
93
94
95
96
97
98
 
    private void addColumnValue(Row rowHeader, UIComponent component, int index) {
        Cell cell = rowHeader.createCell(index);
        String value = component == null ? "" : exportValue(FacesContext.getCurrentInstance(), component);

        cell.setCellValue(new HSSFRichTextString(value));
    }
View Full Code Here
108
109
110
111
112
113
114
                if(value != null)
                  builder.append(value);
            }
    } 
       
        cell.setCellValue(new HSSFRichTextString(builder.toString()));
    }
View Full Code Here
124
125
126
127
128
129
130
131
132
133
134
                {
                    c.setCellStyle(cs);
                }
                c = r.createCell(cellnum + 1,
                                 HSSFCell.CELL_TYPE_STRING);
                c.setCellValue(new HSSFRichTextString("TEST"));
                s.setColumnWidth(cellnum + 1, (int)(50 * 8 / 0.05));
                if ((rownum % 2) == 0)
                {
                    c.setCellStyle(cs2);
                }
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
        assertEquals(TextObjectRecord.TEXT_ORIENTATION_NONE, record.getTextOrientation());
        assertEquals("Hello, World!", record.getStr().getString());
    }

    public void testWrite() {
        HSSFRichTextString str = new HSSFRichTextString("Hello, World!");

        TextObjectRecord record = new TextObjectRecord();
        record.setStr(str);
        record.setHorizontalTextAlignment( TextObjectRecord.HORIZONTAL_TEXT_ALIGNMENT_LEFT_ALIGNED );
        record.setVerticalTextAlignment( TextObjectRecord.VERTICAL_TEXT_ALIGNMENT_TOP );
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
    /**
     * Zero {@link ContinueRecord}s follow a {@link TextObjectRecord} if the text is empty
     */
    public void testWriteEmpty() {
        HSSFRichTextString str = new HSSFRichTextString("");

        TextObjectRecord record = new TextObjectRecord();
        record.setStr(str);

        byte [] ser = record.serialize();
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
        for (int i = 0; i < length.length; i++) {
            StringBuffer buff = new StringBuffer(length[i]);
            for (int j = 0; j < length[i]; j++) {
                buff.append("x");
            }
            HSSFRichTextString str = new HSSFRichTextString(buff.toString());

            TextObjectRecord obj = new TextObjectRecord();
            obj.setStr(str);

            byte [] data = obj.serialize();
            RecordInputStream is = new RecordInputStream(new ByteArrayInputStream(data));
            is.nextRecord();
            TextObjectRecord record = new TextObjectRecord(is);
            str = record.getStr();

            assertEquals(buff.length(), str.length());
            assertEquals(buff.toString(), str.getString());
        }

    }
View Full Code Here
132
133
134
135
136
137
138
139
140
141
142
    /**
     * Test cloning
     */
    public void testClone() {
        String text = "Hello, World";
        HSSFRichTextString str = new HSSFRichTextString(text);

        TextObjectRecord obj = new TextObjectRecord();
        obj.setStr( str );


View Full Code Here
314
315
316
317
318
319
320
321
322
323
324
325
326
                if(!_shouldEvaluateFormulas) {
                  text.append(cell.getCellFormula());
                } else {
                  switch(cell.getCachedFormulaResultType()) {
                    case HSSFCell.CELL_TYPE_STRING:
                      HSSFRichTextString str = cell.getRichStringCellValue();
                      if(str != null && str.length() > 0) {
                        text.append(str.toString());
                      }
                      break;
                    case HSSFCell.CELL_TYPE_NUMERIC:
                      text.append(cell.getNumericCellValue());
                      break;
View Full Code Here
TOP

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

  • au.com.cahaya.asasx.poi.PoiUtil
  • bg.smoc.web.servlet.ResultsServlet
  • br.net.woodstock.rockframework.document.spreadsheet.poi.HSSFSpreadsheetDocumentWriter
  • br.net.woodstock.rockframework.office.spreadsheet.poi.HSSFSpreadsheetDocumentWriter
  • cn.baiweigang.qtaf.toolkit.dbunit.data.excel.XlsDataSetWriter
  • com.aaspring.translation.XlsDoor
  • com.aesthete.swingobjects.fw.common.util.ExcelHelper
  • com.commander4j.util.JExcel
  • com.dtrules.compiler.excel.util.ImportRuleSets
  • com.eatle.utils.ExcelUtil
    • 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.