示例#1
0
  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;
  }
示例#2
0
  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;
  }
示例#3
0
  // 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;
  }
示例#4
0
  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;
  }