Ejemplo n.º 1
0
 private String getIndentCSSStyle(SCell cell) {
   final int indention = _cell.getCellStyle().getIndention();
   final boolean wrap = _cell.getCellStyle().isWrapText();
   if (indention > 0) {
     if (wrap) {
       // ZSS-1016
       return "float:right; width: "
           + (_sheet.getColumn(_cell.getColumnIndex()).getWidth()
               - (indention * 8.5)
               - RESERVE_CELL_MARGIN)
           + "px;";
     } else return "text-indent:" + (indention * 8.5) + "px;";
   }
   return "";
 }
Ejemplo n.º 2
0
  /** Gets Cell text by given row and column, it handling */
  public static String getRichCellHtmlText(SSheet sheet, int row, int column) {
    final SCell cell = sheet.getCell(row, column);
    String text = "";
    if (!cell.isNull()) {
      final SCellStyle style = cell.getCellStyle();
      boolean wrap = style.isWrapText();
      boolean vtxt = style.getRotation() == 255; // ZSS-918

      final FormatResult ft =
          EngineFactory.getInstance()
              .createFormatEngine()
              .format(cell, new FormatContext(ZssContext.getCurrent().getLocale()));
      if (ft.isRichText()) {
        final SRichText rstr = ft.getRichText();
        text = vtxt ? getVRichTextHtml(rstr, wrap) : getRichTextHtml(rstr, wrap); // ZSS-918
      } else {
        text =
            vtxt
                ? escapeVText(ft.getText(), wrap)
                : escapeText(ft.getText(), wrap, true); // ZSS-918
      }
      final SHyperlink hlink = cell.getHyperlink();
      if (hlink != null) {
        text = getHyperlinkHtml(text, hlink, sheet, cell, style, ft, null); // ZSS-1018
      }
    }
    return text;
  }
Ejemplo n.º 3
0
  /** Gets Cell text by given row and column, it handling */
  public static String getRichCellHtmlText(
      SSheet sheet, int row, int column, FormatResult ft, SCellStyle tbStyle) { // ZSS-1018
    final SCell cell = sheet.getCell(row, column);
    String text = "";
    if (!cell.isNull()) {
      final SCellStyle style = cell.getCellStyle();
      boolean wrap = style.isWrapText();
      boolean vtxt = style.getRotation() == 255; // ZSS-918

      if (ft.isRichText()) {
        final SRichText rstr = ft.getRichText();
        text = vtxt ? getVRichTextHtml(rstr, wrap) : getRichTextHtml(rstr, wrap); // ZSS-918
      } else {
        text =
            vtxt
                ? escapeVText(ft.getText(), wrap)
                : escapeText(ft.getText(), wrap, true); // ZSS-918
      }
      final SHyperlink hlink = cell.getHyperlink();
      if (hlink != null) {
        text = getHyperlinkHtml(text, hlink, sheet, cell, style, ft, tbStyle); // ZSS-1018
      }
    }
    return text;
  }
Ejemplo n.º 4
0
  public static String getTextCSSStyle(SCell cell) {
    final SCellStyle style = cell.getCellStyle();

    final StringBuffer sb = new StringBuffer();
    Alignment textHAlign = getRealAlignment(cell);

    switch (textHAlign) {
      case RIGHT:
        sb.append("text-align:").append("right").append(";");
        break;
      case CENTER:
      case CENTER_SELECTION:
        sb.append("text-align:").append("center").append(";");
        break;
      default:
        break;
    }
    // ZSS-944: when rotate 90 degree, wrap must be false
    final int rotate90 = style.getRotation();
    boolean textWrap = style.isWrapText() && rotate90 != 90 && rotate90 != -90; // ZSS-1020
    if (textWrap) {
      sb.append("white-space:").append("pre-wrap").append(";"); // ZSS-1118
    } /*else{ sb.append("white-space:").append("nowrap").append(";"); }*/

    return sb.toString();
  }
Ejemplo n.º 5
0
  // Halignment determined by style alignment, text format and value type
  public static Alignment getRealAlignment(SCell cell) {
    final SCellStyle style = cell.getCellStyle();
    CellType type = cell.getType();
    Alignment align = style.getAlignment();
    if (align == Alignment.GENERAL) {
      // ZSS-918: vertical text default to horizontal center; no matter the type
      final boolean vtxt = style.getRotation() == 255;
      if (vtxt) return Alignment.CENTER;

      // ZSS-1020: 90 degree text default to horizontal right; no matter the type
      final boolean deg90 = style.getRotation() == 90;
      if (deg90) return Alignment.RIGHT;

      final String format = style.getDataFormat();
      if (format != null && format.startsWith("@")) // a text format
      type = CellType.STRING;
      else if (type == CellType.FORMULA) type = cell.getFormulaResultType();
      switch (type) {
        case BLANK:
          return align;
        case BOOLEAN:
          return Alignment.CENTER;
        case ERROR:
          return Alignment.CENTER;
        case NUMBER:
          return Alignment.RIGHT;
        case STRING:
        default:
          return Alignment.LEFT;
      }
    }
    return align;
  }
Ejemplo n.º 6
0
 public CellFormatHelper(SSheet sheet, int row, int col, MergeMatrixHelper mmhelper) {
   _sheet = sheet;
   _row = row;
   _col = col;
   _cell = sheet.getCell(row, col);
   _cellStyle = _cell.getCellStyle();
   _mmHelper = mmhelper;
   _formatEngine = EngineFactory.getInstance().createFormatEngine();
 }
Ejemplo n.º 7
0
  // @since 3.8.0
  public String getRealHtmlStyle(FormatResult ft, SCellStyle tbCellStyle) { // ZSS-977
    if (!_cell.isNull()) {
      final StringBuffer sb = new StringBuffer();
      sb.append(
          getFontHtmlStyle(
              _sheet, _cell, _cell.getCellStyle(), ft, tbCellStyle)); // ZSS-977, ZSS-1018
      sb.append(getIndentCSSStyle(_cell));
      return sb.toString();
    }

    return "";
  }
Ejemplo n.º 8
0
  // ZSS-725
  public static String getRichTextEditCellHtml(SSheet sheet, int row, int column) {
    final SCell cell = sheet.getCell(row, column);
    String text = "";
    if (!cell.isNull()) {
      boolean wrap = cell.getCellStyle().isWrapText();

      final FormatResult ft =
          EngineFactory.getInstance()
              .createFormatEngine()
              .format(cell, new FormatContext(ZssContext.getCurrent().getLocale()));
      if (ft.isRichText()) {
        final SRichText rstr = ft.getRichText();
        text = RichTextHelper.getCellRichTextHtml(rstr, wrap);

      } else {
        text =
            RichTextHelper.getFontTextHtml(
                escapeText(ft.getText(), wrap, true), cell.getCellStyle().getFont());
      }
    }
    return text;
  }
Ejemplo n.º 9
0
  /** Gets Cell text by given row and column */
  public static String getCellHtmlText(
      SSheet sheet, int row, int column, FormatResult ft, SCellStyle tbStyle) { // ZSS-1018
    final SCell cell = sheet.getCell(row, column);
    String text = "";
    if (cell != null) {
      boolean wrap = cell.getCellStyle().isWrapText();

      if (ft.isRichText()) {
        final SRichText rstr = ft.getRichText();
        text = rstr.getText();
      } else {
        text = ft.getText();
      }
      text = escapeText(text, wrap, true);
    }
    return text;
  }
Ejemplo n.º 10
0
  /** Gets Cell text by given row and column */
  public static String getCellHtmlText(SSheet sheet, int row, int column) {
    final SCell cell = sheet.getCell(row, column);
    String text = "";
    if (cell != null) {
      boolean wrap = cell.getCellStyle().isWrapText();

      final FormatResult ft =
          EngineFactory.getInstance()
              .createFormatEngine()
              .format(cell, new FormatContext(ZssContext.getCurrent().getLocale()));
      if (ft.isRichText()) {
        final SRichText rstr = ft.getRichText();
        text = rstr.getText();
      } else {
        text = ft.getText();
      }
      text = escapeText(text, wrap, true);
    }
    return text;
  }