private boolean processLeftBorder( StringBuffer sb, StringBuffer db, SCellStyle fillStyle, SCellStyle tbStyle) { // ZSS-977 boolean hitLeft = false; MergedRect rect = null; boolean hitMerge = false; // find left border of target cell rect = _mmHelper.getMergeRange(_row, _col); int left = _col; if (rect != null) { hitMerge = true; left = rect.getColumn(); } SCellStyle nextStyle = StyleUtil.getLeftStyle(_sheet.getCell(_row, left).getCellStyle(), tbStyle); // ZSS-977 if (nextStyle != null) { BorderType bb = nextStyle.getBorderLeft(); if (bb == BorderType.DOUBLE) { String color = nextStyle.getBorderLeftColor().getHtmlColor(); hitLeft = appendBorderStyle(sb, "left", bb, color); } else if (bb != BorderType.NONE) { // ZSS-919: check if my left is a merged cell left = hitMerge ? rect.getColumn() - 1 : _col - 1; if (left >= 0) { final MergedRect rectT = _mmHelper.getMergeRange(_row, left); // my left merged more than 2 rows if (rectT != null && rectT.getRow() < rectT.getLastRow()) { String color = nextStyle.getBorderLeftColor().getHtmlColor(); // support only solid line but position correctly return appendMergedBorder(sb, "left", color); // //offset 1px to right but support more line styles // return hitLeft = appendBorderStyle(sb, "left", bb, color); } } } } // if no border for target cell,then check if this cell is in a merge range // if(true) then try to get next cell after this merge range // else get next cell of this cell if (!hitLeft) { left = hitMerge ? rect.getColumn() - 1 : _col - 1; if (left >= 0) { nextStyle = _sheet.getCell(_row, left).getCellStyle(); // ZSS-977 if (nextStyle.getBorderRight() == BorderType.NONE) { final STable table0 = ((AbstractSheetAdv) _sheet).getTableByRowCol(_row, left); final SCellStyle tbStyle0 = table0 == null ? null : ((AbstractTableAdv) table0).getCellStyle(_row, left); nextStyle = StyleUtil.getRightStyle(nextStyle, tbStyle0); } if (nextStyle != null) { BorderType bb = nextStyle.getBorderRight(); // get right here // String color = BookHelper.indexToRGB(_book, style.getLeftBorderColor()); // ZSS-34 cell background color does not show in excel if (bb == BorderType.DOUBLE) { String color = nextStyle.getBorderRightColor().getHtmlColor(); hitLeft = appendBorderStyle(sb, "left", bb, color); } } } } db.append(hitLeft ? "l" : "_"); return hitLeft; }
private boolean processRightBorder( StringBuffer sb, StringBuffer db, SCellStyle fillStyle, SCellStyle tbStyle) { // ZSS-977 boolean hitRight = false; MergedRect rect = null; boolean hitMerge = false; // find right border of target cell rect = _mmHelper.getMergeRange(_row, _col); int right = _col; if (rect != null) { hitMerge = true; right = rect.getLastColumn(); } BorderType bb = null; SCellStyle nextStyle = StyleUtil.getRightStyle(_sheet.getCell(_row, right).getCellStyle(), tbStyle); // ZSS-977 if (nextStyle != null) { bb = nextStyle.getBorderRight(); String color = nextStyle.getBorderRightColor().getHtmlColor(); hitRight = appendBorderStyle(sb, "right", bb, color); } // if no border for target cell,then check is this cell in a merge range // if(true) then try to get next cell after this merge range // else get next cell of this cell SCellStyle nextFillStyle = null; // ZSS-977 if (!hitRight) { right = hitMerge ? rect.getLastColumn() + 1 : _col + 1; // ZSS-919: merge more than 2 rows; must use left border of right cell if (!hitMerge || rect.getRow() == rect.getLastRow()) { nextFillStyle = nextStyle = _sheet.getCell(_row, right).getCellStyle(); // ZSS-977 SCellStyle nextTbStyle = null; if (nextStyle.getBorderLeft() == BorderType.NONE) { final STable table0 = ((AbstractSheetAdv) _sheet).getTableByRowCol(_row, right); nextTbStyle = table0 == null ? null : ((AbstractTableAdv) table0).getCellStyle(_row, right); nextStyle = StyleUtil.getLeftStyle(nextStyle, nextTbStyle); } if (nextStyle != null) { bb = nextStyle.getBorderLeft(); // get left here // String color = BookHelper.indexToRGB(_book, style.getLeftBorderColor()); // ZSS-34 cell background color does not show in excel String color = nextStyle.getBorderLeftColor().getHtmlColor(); hitRight = appendBorderStyle(sb, "right", bb, color); } // ZSS-977 if (!hitRight) { nextFillStyle = StyleUtil.getFillStyle(nextFillStyle, nextTbStyle); } } } // border depends on next cell's background color (why? dennis, 20131118) if (!hitRight && nextFillStyle != null) { // String bgColor = BookHelper.indexToRGB(_book, style.getFillForegroundColor()); // ZSS-34 cell background color does not show in excel String bgColor = nextFillStyle.getFillPattern() == FillPattern.SOLID ? nextFillStyle.getBackColor().getHtmlColor() : null; if (bgColor != null) { hitRight = appendBorderStyle(sb, "right", BorderType.THIN, bgColor); } else if (nextFillStyle.getFillPattern() != FillPattern.NONE) { // ZSS-841 sb.append("border-right:none;"); // no grid line either hitRight = true; } } // border depends on current cell's background color if (!hitRight && fillStyle != null) { // String bgColor = BookHelper.indexToRGB(_book, style.getFillForegroundColor()); // ZSS-34 cell background color does not show in excel String bgColor = fillStyle.getFillPattern() == FillPattern.SOLID ? fillStyle.getBackColor().getHtmlColor() : null; if (bgColor != null) { hitRight = appendBorderStyle(sb, "right", BorderType.THIN, bgColor); } else if (fillStyle.getFillPattern() != FillPattern.NONE) { // ZSS-841 sb.append("border-right:none;"); // no grid line either hitRight = true; } } db.append(hitRight && bb == BorderType.DOUBLE ? "r" : "_"); return hitRight; }
// ZSS-568 private boolean processTopBorder( StringBuffer sb, StringBuffer db, SCellStyle fillStyle, SCellStyle tbStyle) { // ZSS-977 boolean hitTop = false; MergedRect rect = null; boolean hitMerge = false; // ZSS-259: should apply the top border from the cell of merged range's top // as processRightBorder() does. rect = _mmHelper.getMergeRange(_row, _col); int top = _row; if (rect != null) { hitMerge = true; top = rect.getRow(); } SCellStyle nextStyle = StyleUtil.getTopStyle(_sheet.getCell(top, _col).getCellStyle(), tbStyle); // ZSS-977 if (nextStyle != null) { BorderType bb = nextStyle.getBorderTop(); if (bb == BorderType.DOUBLE) { String color = nextStyle.getBorderTopColor().getHtmlColor(); hitTop = appendBorderStyle(sb, "top", bb, color); } else if (bb != BorderType.NONE) { // ZSS-919: check if my top is a merged cell top = hitMerge ? rect.getRow() - 1 : _row - 1; if (top >= 0) { final MergedRect rectT = _mmHelper.getMergeRange(top, _col); // my top merge more than 2 columns if (rectT != null && rectT.getColumn() < rectT.getLastColumn()) { String color = nextStyle.getBorderTopColor().getHtmlColor(); // support only solid line but position correctly return appendMergedBorder(sb, "top", color); // //offset 1px to bottom but support more line styles // return hitTop = appendBorderStyle(sb, "top", bb, color); } } } } // ZSS-259: should check and apply the bottom border from the top cell // of merged range's top as processRightBorder() does. if (!hitTop) { top = hitMerge ? rect.getRow() - 1 : _row - 1; if (top >= 0) { nextStyle = _sheet.getCell(top, _col).getCellStyle(); // ZSS-977 if (nextStyle.getBorderBottom() == BorderType.NONE) { final STable table0 = ((AbstractSheetAdv) _sheet).getTableByRowCol(top, _col); final SCellStyle tbStyle0 = table0 == null ? null : ((AbstractTableAdv) table0).getCellStyle(top, _col); nextStyle = StyleUtil.getBottomStyle(nextStyle, tbStyle0); } if (nextStyle != null) { BorderType bb = nextStyle.getBorderBottom(); // get bottom border of if (bb == BorderType.DOUBLE) { String color = nextStyle.getBorderBottomColor().getHtmlColor(); // set next row top border as cell's top border; hitTop = appendBorderStyle(sb, "top", bb, color); } } } } db.append(hitTop ? "t" : "_"); return hitTop; }
private boolean processBottomBorder( StringBuffer sb, StringBuffer db, SCellStyle fillStyle, SCellStyle tbStyle) { // ZSS-977 boolean hitBottom = false; MergedRect rect = null; boolean hitMerge = false; // ZSS-259: should apply the bottom border from the cell of merged range's bottom // as processRightBorder() does. rect = _mmHelper.getMergeRange(_row, _col); int bottom = _row; if (rect != null) { hitMerge = true; bottom = rect.getLastRow(); } SCellStyle nextStyle = StyleUtil.getBottomStyle(_sheet.getCell(bottom, _col).getCellStyle(), tbStyle); // ZSS-977 BorderType bb = null; if (nextStyle != null) { bb = nextStyle.getBorderBottom(); String color = nextStyle.getBorderBottomColor().getHtmlColor(); hitBottom = appendBorderStyle(sb, "bottom", bb, color); } // ZSS-259: should check and apply the top border from the bottom cell // of merged range's bottom as processRightBorder() does. SCellStyle nextFillStyle = null; // ZSS-977 if (!hitBottom) { bottom = hitMerge ? rect.getLastRow() + 1 : _row + 1; /*if(next == null){ // don't search into merge ranges //check is _row+1,_col in merge range MergedRect rect = _mmHelper.getMergeRange(_row+1, _col); if(rect !=null){ next = _sheet.getCell(rect.getTop(),rect.getLeft()); } }*/ // ZSS-919: merge more than 2 columns; must use top border of bottom cell if (!hitMerge || rect.getColumn() == rect.getLastColumn()) { nextFillStyle = nextStyle = _sheet.getCell(bottom, _col).getCellStyle(); // ZSS-977 SCellStyle nextTbStyle = null; if (nextStyle.getBorderTop() == BorderType.NONE) { final STable table0 = ((AbstractSheetAdv) _sheet).getTableByRowCol(bottom, _col); nextTbStyle = table0 == null ? null : ((AbstractTableAdv) table0).getCellStyle(bottom, _col); nextStyle = StyleUtil.getTopStyle(nextStyle, nextTbStyle); } if (nextStyle != null) { bb = nextStyle.getBorderTop(); // get top border of String color = nextStyle.getBorderTopColor().getHtmlColor(); // set next row top border as cell's bottom border; hitBottom = appendBorderStyle(sb, "bottom", bb, color); } // ZSS-977 if (!hitBottom) { nextFillStyle = StyleUtil.getFillStyle(nextFillStyle, nextTbStyle); } } } // border depends on next cell's fill color if solid pattern if (!hitBottom && nextFillStyle != null) { // String bgColor = BookHelper.indexToRGB(_book, style.getFillForegroundColor()); // ZSS-34 cell background color does not show in excel String bgColor = nextFillStyle.getFillPattern() == FillPattern.SOLID ? nextFillStyle.getBackColor().getHtmlColor() : null; // ZSS-857 if (bgColor != null) { hitBottom = appendBorderStyle(sb, "bottom", BorderType.THIN, bgColor); } else if (nextFillStyle.getFillPattern() != FillPattern.NONE) { // ZSS-841 sb.append("border-bottom:none;"); // no grid line either hitBottom = true; } } // border depends on current cell's background color if (!hitBottom && fillStyle != null) { // String bgColor = BookHelper.indexToRGB(_book, style.getFillForegroundColor()); // ZSS-34 cell background color does not show in excel String bgColor = fillStyle.getFillPattern() == FillPattern.SOLID ? fillStyle.getBackColor().getHtmlColor() : null; if (bgColor != null) { hitBottom = appendBorderStyle(sb, "bottom", BorderType.THIN, bgColor); } else if (fillStyle.getFillPattern() != FillPattern.NONE) { // ZSS-841 sb.append("border-bottom:none;"); // no grid line either hitBottom = true; } } db.append(hitBottom && bb == BorderType.DOUBLE ? "b" : "_"); return hitBottom; }