Package org.zkoss.poi.ss.usermodel

Examples of org.zkoss.poi.ss.usermodel.RichTextString

1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
  //Return simple String form of the cell
  public static String getCellText(Cell cell) {
    final FormatTextImpl ft = getFormatText(cell);
    if (ft != null) {
      if (ft.isRichTextString()) {
        final RichTextString rstr = ft.getRichTextString();
        return rstr == null ? "" : rstr.getString();
      } else if (ft.isCellFormatResult()) {
        return ft.getCellFormatResult().text;     
      }
    }
    return "";
View Full Code Here
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
    case Cell.CELL_TYPE_FORMULA:
      return cell.getCellFormula();
    case Cell.CELL_TYPE_NUMERIC:
      return new Double(cell.getNumericCellValue());
    case Cell.CELL_TYPE_STRING:
      final RichTextString rtstr = cell.getRichStringCellValue();
      return rtstr;
    default:
      throw new UiException("Unknown cell type:"+cellType);
    }
  }
View Full Code Here
919
920
921
922
923
924
925
926
927
928
929
    CellStyle style = (cell == null) ? null : cell.getCellStyle();
    boolean wrap = style != null && style.getWrapText();
    Hyperlink hlink = cell == null ? null : Utils.getHyperlink(cell);
    final FormatText ft = (cell == null) ? null : Utils.getFormatText(cell);
   
    final RichTextString rstr = ft != null && ft.isRichTextString() ? ft.getRichTextString() : null;
    String text = rstr != null ? Utils.formatRichTextString(sheet, rstr, wrap) : ft != null ? Utils.escapeCellText(ft.getCellFormatResult().text, wrap, true) : "";
    if (hlink != null) {
      text = Utils.formatHyperlink(sheet, hlink, text, wrap);
    }
    return text;
View Full Code Here
932
933
934
935
936
937
938
939
   * Returns the text for editing on the specified cell.
   * @param cell the cell
   * @return the text for editing on the specified cell.
   */
  public static String getEditText(Cell cell) {
    final RichTextString rstr = cell == null ? null : getRichEditText(cell);
    return rstr != null ? rstr.getString() : "";
  }
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
97
      if (bgColor != null) {
        sb.append("background-color:").append(bgColor).append(";");
      }
      final FormatText ft = Utils.getFormatText(_cell);
      final boolean isRichText = ft.isRichTextString();
      final RichTextString rstr = isRichText ? ft.getRichTextString() : null;
      final String txt = rstr != null ? rstr.getString() : ft.getCellFormatResult().text;
     
      if(_cell.getCellType() == Cell.CELL_TYPE_BLANK) {
        sb.append("z-index:-1;"); //For IE6/IE7's overflow
      }
    }
View Full Code Here
96
97
98
99
100
101
102
103
    final Cell cell = row4.getCell(0);
    CellValue value = _evaluator.evaluate(cell);
    assertEquals(0, value.getNumberValue(), 0.0000000000000001);
   
    Cell cellA1 = row.getCell(0);
    RichTextString rstr = _workbook.getCreationHelper().createRichTextString("10");
    new RangeImpl(0, 0, sheet1, sheet1).setRichEditText(rstr);
  }
View Full Code Here
89
90
91
92
93
94
95
96
    final Cell cell = row4.getCell(0);
    CellValue value = _evaluator.evaluate(cell);
    assertEquals(0, value.getNumberValue(), 0.0000000000000001);
   
    Cell cellA1 = row.getCell(0);
    RichTextString rstr = _workbook.getCreationHelper().createRichTextString("10");
    new RangeImpl(0, 0, sheet1, sheet1).setRichEditText(rstr);
  }
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
    if (cell != null) {
      boolean wrap = cell.getCellStyle().getWrapText();
      final FormatText ft = Utils.getFormatText(cell);
      if (ft != null) {
        if (ft.isRichTextString()) {
          final RichTextString rstr = ft.getRichTextString();
          text = rstr == null ? "" : Utils.formatRichTextString(sheet, rstr, wrap);
        } else if (ft.isCellFormatResult()) {
          text = Utils.escapeCellText(ft.getCellFormatResult().text, wrap, true);
        }
      }
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
108
    String text = "";
    if (cell != null) {
      final FormatText ft = Utils.getFormatText(cell);
      if (ft != null) {
        if (ft.isRichTextString()) {
          final RichTextString rstr = ft.getRichTextString();
          text = rstr == null ? "" : rstr.toString();
        } else if (ft.isCellFormatResult()) {
          text = ft.getCellFormatResult().text;
        }
      }
    }
View Full Code Here
TOP

Related Classes of org.zkoss.poi.ss.usermodel.RichTextString

  • org.zkoss.zss.model.impl.Book03XlsFormulaEvaluatorTest
  • org.zkoss.zss.model.impl.Book03XlsxFormulaEvaluatorTest
  • org.zkoss.zss.model.impl.BookHelper
  • org.zkoss.zss.ui.fn.UtilFns
  • org.zkoss.zss.ui.impl.CellFormatHelper
  • org.zkoss.zss.ui.impl.Utils
    • 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.