Examples of org.apache.poi.hssf.record.common.UnicodeString$PhRun

Package org.apache.poi.hssf.record.common

Examples of org.apache.poi.hssf.record.common.UnicodeString$PhRun

org.apache.poi.hssf.record.common.UnicodeString
Title: Unicode String
Description: Unicode String - just standard fields that are in several records. It is considered more desirable then repeating it in all of them.
This is often called a XLUnicodeRichExtendedString in MS documentation.
REFERENCE: PG 264 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
REFERENCE: PG 951 Excel Binary File Format (.xls) Structure Specification v20091214

                 LabelRecord oldrec = ( LabelRecord ) rec;


                 records.remove(k);
                 LabelSSTRecord newrec   = new LabelSSTRecord();
                 int            stringid =
                     workbook.addSSTString(new UnicodeString(oldrec.getValue()));


                 newrec.setRow(oldrec.getRow());
                 newrec.setColumn(oldrec.getColumn());
                 newrec.setXFIndex(oldrec.getXFIndex());
                 newrec.setSSTIndex(stringid);

View Full Code Here

    /** @deprecated Do not call this method from your applications. Use the methods
     *  available in the HSSFRow to add string HSSFCells
     */
    public int addSSTString(String string)
    {
        return workbook.addSSTString(new UnicodeString(string));
    }

View Full Code Here

   */
  private static UnicodeString resolveTitleText(String str) {
    if (str == null || str.length() < 1) {
      return NULL_TEXT_STRING;
    }
    return new UnicodeString(str);
  }

View Full Code Here

    }
    return new UnicodeString(str);
  }
  
  private static UnicodeString readUnicodeString(RecordInputStream in) {
    return new UnicodeString(in);
  }

View Full Code Here

      HSSFSheet s = workbook.getSheetAt(sheetNum);
      for (Row row : s) {
         for (Cell cell : row) {
          if(cell.getCellType() == Cell.CELL_TYPE_STRING) {
            HSSFRichTextString rtr = (HSSFRichTextString)cell.getRichStringCellValue();
            UnicodeString u = rtr.getRawUnicodeString();
            
            // Have we done this string already?
            if(! doneUnicodeStrings.contains(u)) {
              // Update for each new position
              for(short i=5; i<newPos.length; i++) {
                if(i != newPos[i]) {
                  u.swapFontUse(i, newPos[i]);
                }
              }
              
              // Mark as done
              doneUnicodeStrings.add(u);

View Full Code Here


    public UnicodeString getSSTString(int str) {
        if (sst == null) {
            insertSST();
        }
        UnicodeString retval = sst.getString(str);


        if (log.check( POILogger.DEBUG ))
            log.log(DEBUG, "Returning SST for index=", Integer.valueOf(str),
                " String= ", retval);
        return retval;

View Full Code Here

                    lrec.setRow(row);
                    lrec.setXFIndex(styleIndex);
                }
                if (setValue) {
                    String str = convertCellValueToString();
                    int sstIndex = _book.getWorkbook().addSSTString(new UnicodeString(str));
                    lrec.setSSTIndex(sstIndex);
                    UnicodeString us = _book.getWorkbook().getSSTString(sstIndex);
                    _stringValue = new HSSFRichTextString();
                    _stringValue.setUnicodeString(us);
                }
                _record = lrec;
                break;

View Full Code Here

        if (_cellType != CELL_TYPE_STRING) {
            setCellType(CELL_TYPE_STRING, false, row, col, styleIndex);
        }
        int index = 0;


        UnicodeString str = hvalue.getUnicodeString();
        index = _book.getWorkbook().addSSTString(str);
        (( LabelSSTRecord ) _record).setSSTIndex(index);
        _stringValue = hvalue;
        _stringValue.setWorkbookReferences(_book.getWorkbook(), (( LabelSSTRecord ) _record));
        _stringValue.setUnicodeString(_book.getWorkbook().getSSTString(index));

View Full Code Here


    public UnicodeString getSSTString(int str) {
        if (sst == null) {
            insertSST();
        }
        UnicodeString retval = sst.getString(str);


        if (log.check( POILogger.DEBUG ))
            log.log(DEBUG, "Returning SST for index=", Integer.valueOf(str),
                " String= ", retval);
        return retval;

View Full Code Here

    public void bug47847() throws Exception {
       HSSFWorkbook wb = openSample("47847.xls");
       assertEquals(3, wb.getNumberOfSheets());
       
       // Find the SST record
       UnicodeString withExt = wb.getWorkbook().getSSTString(0);
       UnicodeString withoutExt = wb.getWorkbook().getSSTString(31);
       
       assertEquals("O:Alloc:Qty", withExt.getString());
       assertTrue((withExt.getOptionFlags() & 0x0004) == 0x0004);
       
       assertEquals("RT", withoutExt.getString());
       assertTrue((withoutExt.getOptionFlags() & 0x0004) == 0x0000);
       
       // Something about continues...


       
       // Write out and re-read
       wb = writeOutAndReadBack(wb);
       assertEquals(3, wb.getNumberOfSheets());
       
       // Check it's the same now
       withExt = wb.getWorkbook().getSSTString(0);
       withoutExt = wb.getWorkbook().getSSTString(31);
       
       assertEquals("O:Alloc:Qty", withExt.getString());
       assertTrue((withExt.getOptionFlags() & 0x0004) == 0x0004);
       
       assertEquals("RT", withoutExt.getString());
       assertTrue((withoutExt.getOptionFlags() & 0x0004) == 0x0000);
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.poi.hssf.record.common.UnicodeString$PhRun

org.apache.poi.hssf.model.InternalWorkbook

org.apache.poi.hssf.record.cont.ContinuableRecordInput

org.apache.poi.hssf.record.DVRecord

org.apache.poi.hssf.record.SSTDeserializer

org.apache.poi.hssf.record.SSTRecord

org.apache.poi.hssf.record.SSTSerializer

org.apache.poi.hssf.record.TestExtSSTRecord

org.apache.poi.hssf.record.TestSSTRecord

org.apache.poi.hssf.record.TestSSTRecordSizeCalculator

org.apache.poi.hssf.usermodel.HSSFCell

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.