Пример #1
0
 private Font cloneFont(CellStyle cellstyle) {
   Font newFont = spreadsheet.getWorkbook().createFont();
   Font originalFont = spreadsheet.getWorkbook().getFontAt(cellstyle.getFontIndex());
   if (originalFont != null) {
     newFont.setBold(originalFont.getBold());
     newFont.setItalic(originalFont.getItalic());
     newFont.setFontHeight(originalFont.getFontHeight());
     newFont.setUnderline(originalFont.getUnderline());
     newFont.setStrikeout(originalFont.getStrikeout());
     // This cast an only be done when using .xlsx files
     XSSFFont originalXFont = (XSSFFont) originalFont;
     XSSFFont newXFont = (XSSFFont) newFont;
     newXFont.setColor(originalXFont.getXSSFColor());
   }
   return newFont;
 }
Пример #2
0
  private void updateSelectedCellsBold() {
    if (spreadsheet != null) {
      List<Cell> cellsToRefresh = new ArrayList<Cell>();
      for (CellReference cellRef : spreadsheet.getSelectedCellReferences()) {
        // Obtain Cell using CellReference
        Cell cell = getOrCreateCell(cellRef);
        // Clone Cell CellStyle
        CellStyle style = cloneStyle(cell);
        // Clone CellStyle Font
        Font font = cloneFont(style);
        // Toggle current bold state
        font.setBold(!font.getBold());
        style.setFont(font);
        cell.setCellStyle(style);

        cellsToRefresh.add(cell);
      }
      // Update all edited cells
      spreadsheet.refreshCells(cellsToRefresh);
    }
  }