/** 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;
}
// ZSS-945, ZSS-1018
// @since 3.8.0
// @Internal
public static String getFontHtmlStyle(
SSheet sheet,
SCell cell,
SCellStyle cellStyle,
FormatResult ft,
SCellStyle tbCellStyle) { // ZSS-977
if (!cell.isNull()) {
final StringBuffer sb = new StringBuffer();
// ZSS-977
SFont font = StyleUtil.getFontStyle(sheet.getBook(), cellStyle, tbCellStyle);
;
sb.append(getFontCSSStyle(cell, font));
// condition color
final boolean isRichText = ft.isRichText();
if (!isRichText) {
final SColor color = ft.getColor();
if (color != null) {
final String htmlColor = color.getHtmlColor();
sb.append("color:").append(htmlColor).append(";");
}
}
return sb.toString();
}
return "";
}
/** 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;
}
// ZSS-725: separate inner and font style to avoid the conflict between
// vertical alignment, subscript and superscript.
public String getFontHtmlStyle() {
if (!_cell.isNull()) {
final StringBuffer sb = new StringBuffer();
final SFont font = _cellStyle.getFont();
// sb.append(BookHelper.getFontCSSStyle(_book, font));
sb.append(getFontCSSStyle(_cell, font));
// condition color
final FormatResult ft =
_formatEngine.format(_cell, new FormatContext(ZssContext.getCurrent().getLocale()));
final boolean isRichText = ft.isRichText();
if (!isRichText) {
final SColor color = ft.getColor();
if (color != null) {
final String htmlColor = color.getHtmlColor();
sb.append("color:").append(htmlColor).append(";");
}
}
return sb.toString();
}
return "";
}
// @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 "";
}
public String getInnerHtmlStyle() {
if (!_cell.isNull()) {
final StringBuffer sb = new StringBuffer();
sb.append(getTextCSSStyle(_cell));
// vertical alignment
VerticalAlignment verticalAlignment = _cellStyle.getVerticalAlignment();
sb.append("display: table-cell;");
switch (verticalAlignment) {
case TOP:
sb.append("vertical-align: top;");
break;
case CENTER:
sb.append("vertical-align: middle;");
break;
case BOTTOM:
default:
sb.append("vertical-align: bottom;");
break;
}
// final SFont font = _cellStyle.getFont();
// sb.append(BookHelper.getFontCSSStyle(_book, font));
// sb.append(getFontCSSStyle(_cell, font));
// condition color
// final FormatResult ft = _formatEngine.format(_cell, new
// FormatContext(ZssContext.getCurrent().getLocale()));
// final boolean isRichText = ft.isRichText();
// if (!isRichText) {
// final SColor color = ft.getColor();
// if(color!=null){
// final String htmlColor = color.getHtmlColor();
// sb.append("color:").append(htmlColor).append(";");
// }
// }
return sb.toString();
}
return "";
}
// 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;
}