private HSSFFont matchFont( Font matchFont ) { HSSFColor hssfColor = workbook.getCustomPalette() .findColor((byte)foreground.getRed(), (byte)foreground.getGreen(), (byte)foreground.getBlue()); if (hssfColor == null) hssfColor = workbook.getCustomPalette().findSimilarColor((byte)foreground.getRed(), (byte)foreground.getGreen(), (byte)foreground.getBlue()); boolean bold = (matchFont.getStyle() & Font.BOLD) != 0; boolean italic = (matchFont.getStyle() & Font.ITALIC) != 0; HSSFFont hssfFont = workbook.findFont(bold, hssfColor.getIndex(), (short)(matchFont.getSize() * 20), matchFont.getName(), italic, false, (short)0, (byte)0); if (hssfFont == null) { hssfFont = workbook.createFont(); hssfFont.setBold(bold); hssfFont.setColor(hssfColor.getIndex()); hssfFont.setFontHeight((short)(matchFont.getSize() * 20)); hssfFont.setFontName(matchFont.getName()); hssfFont.setItalic(italic); hssfFont.setStrikeout(false); hssfFont.setTypeOffset((short) 0); hssfFont.setUnderline((byte) 0); } return hssfFont; }
newFont.setColor(cellFont.getColor()); newFont.setUnderline(cellFont.getUnderline()); newFont.setFontHeight(cellFont.getFontHeight()); newFont.setFontHeightInPoints(cellFont.getFontHeightInPoints()); fontCache.addCachedFont(cellFont, newFont);
private HSSFFont matchFont( Font font ) { HSSFColor hssfColor = workbook.getCustomPalette() .findColor((byte)foreground.getRed(), (byte)foreground.getGreen(), (byte)foreground.getBlue()); if (hssfColor == null) hssfColor = workbook.getCustomPalette().findSimilarColor((byte)foreground.getRed(), (byte)foreground.getGreen(), (byte)foreground.getBlue()); boolean bold = (font.getStyle() & Font.BOLD) != 0; boolean italic = (font.getStyle() & Font.ITALIC) != 0; HSSFFont hssfFont = workbook.findFont(bold ? HSSFFont.BOLDWEIGHT_BOLD : 0, hssfColor.getIndex(), (short)(font.getSize() * 20), font.getName(), italic, false, (short)0, (byte)0); if (hssfFont == null) { hssfFont = workbook.createFont(); hssfFont.setBoldweight(bold ? HSSFFont.BOLDWEIGHT_BOLD : 0); hssfFont.setColor(hssfColor.getIndex()); hssfFont.setFontHeight((short)(font.getSize() * 20)); hssfFont.setFontName(font.getName()); hssfFont.setItalic(italic); hssfFont.setStrikeout(false); hssfFont.setTypeOffset((short) 0); hssfFont.setUnderline((byte) 0); } return hssfFont; }
newFont.setColor(cellFont.getColor()); newFont.setUnderline(cellFont.getUnderline()); newFont.setFontHeight(cellFont.getFontHeight()); newFont.setFontHeightInPoints(cellFont.getFontHeightInPoints()); fontCache.addCachedFont(cellFont, newFont);
private HSSFFont matchFont( Font matchFont ) { HSSFColor hssfColor = workbook.getCustomPalette() .findColor((byte)foreground.getRed(), (byte)foreground.getGreen(), (byte)foreground.getBlue()); if (hssfColor == null) hssfColor = workbook.getCustomPalette().findSimilarColor((byte)foreground.getRed(), (byte)foreground.getGreen(), (byte)foreground.getBlue()); boolean bold = (matchFont.getStyle() & Font.BOLD) != 0; boolean italic = (matchFont.getStyle() & Font.ITALIC) != 0; HSSFFont hssfFont = workbook.findFont(bold, hssfColor.getIndex(), (short)(matchFont.getSize() * 20), matchFont.getName(), italic, false, (short)0, (byte)0); if (hssfFont == null) { hssfFont = workbook.createFont(); hssfFont.setBold(bold); hssfFont.setColor(hssfColor.getIndex()); hssfFont.setFontHeight((short)(matchFont.getSize() * 20)); hssfFont.setFontName(matchFont.getName()); hssfFont.setItalic(italic); hssfFont.setStrikeout(false); hssfFont.setTypeOffset((short) 0); hssfFont.setUnderline((byte) 0); } return hssfFont; }
private HSSFFont matchFont( Font font ) { HSSFColor hssfColor = workbook.getCustomPalette() .findColor((byte)foreground.getRed(), (byte)foreground.getGreen(), (byte)foreground.getBlue()); if (hssfColor == null) hssfColor = workbook.getCustomPalette().findSimilarColor((byte)foreground.getRed(), (byte)foreground.getGreen(), (byte)foreground.getBlue()); boolean bold = (font.getStyle() & Font.BOLD) != 0; boolean italic = (font.getStyle() & Font.ITALIC) != 0; HSSFFont hssfFont = workbook.findFont(bold ? HSSFFont.BOLDWEIGHT_BOLD : 0, hssfColor.getIndex(), (short)(font.getSize() * 20), font.getName(), italic, false, (short)0, (byte)0); if (hssfFont == null) { hssfFont = workbook.createFont(); hssfFont.setBoldweight(bold ? HSSFFont.BOLDWEIGHT_BOLD : 0); hssfFont.setColor(hssfColor.getIndex()); hssfFont.setFontHeight((short)(font.getSize() * 20)); hssfFont.setFontName(font.getName()); hssfFont.setItalic(italic); hssfFont.setStrikeout(false); hssfFont.setTypeOffset((short) 0); hssfFont.setUnderline((byte) 0); } return hssfFont; }
font.setFontHeight((short)(cellStyle.getFontSize()*20)); Boolean bold=cellStyle.getBold(); if(customStyle!=null && customStyle.getBold()!=null){
fontDefault.setFontHeight((short) (font_size / 0.05)); fontDefault.setFontName("Tahoma"); HSSFFont fontRed = wb.createFont(); fontRed.setColor((short) HSSFColor.WHITE.index); fontRed.setFontHeight((short) (font_size / 0.05)); fontRed.setFontName("Tahoma"); styleRed.setFont(fontRed); HSSFFont fontYellow = wb.createFont(); fontYellow.setColor((short) HSSFColor.BLACK.index); fontYellow.setFontHeight((short) (font_size / 0.05)); fontYellow.setFontName("Tahoma"); styleYellow.setFont(fontYellow); HSSFFont fontGreen = wb.createFont(); fontGreen.setColor((short) HSSFColor.WHITE.index); fontGreen.setFontHeight((short) (font_size / 0.05)); fontGreen.setFontName("Tahoma"); styleGreen.setFont(fontGreen); cellFont.setFontHeight((short) (font_size/0.05)); } catch(NumberFormatException e){ cellFont.setFontHeight((short) (font_size / 0.05));//10 cellFont.setFontHeight((short) (font_size / 0.05)); cellStyle.setFont(cellFont); cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
styleName.setDataFormat((short)0); HSSFFont font = wb.createFont(); font.setFontHeight((short) (font_size / 0.05)); font.setFontName("Tahoma"); font.setColor(HSSFColor.BLACK.index); fontDefault.setFontHeight((short) (font_size / 0.05)); fontDefault.setFontName("Tahoma"); fontDefault.setItalic(true); fontDescr.setFontHeight((short) (font_size / 0.05)); //14 fontDescr.setFontName("Tahoma"); fontDescr.setColor(HSSFColor.BLACK.index);
fontNew.setColor(fontOld.getColor()); fontNew.setFontName(fontOld.getFontName()); fontNew.setFontHeight(fontOld.getFontHeight()); fontNew.setItalic(fontOld.getItalic()); fontNew.setStrikeout(fontOld.getStrikeout());
styleDataHeader.setBorderLeft(HSSFCellStyle.BORDER_THIN); HSSFFont font = wb.createFont(); font.setFontHeight((short) (font_size / 0.05)); font.setFontName("Tahoma"); font.setColor(HSSFColor.BLACK.index); fontDefault.setFontHeight((short) (font_size / 0.05)); fontDefault.setFontName("Tahoma"); fontBold.setFontHeight((short) (font_size / 0.05)); fontBold.setFontName("Tahoma"); fontBold.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
styleHeader.setAlignment(HSSFCellStyle.ALIGN_CENTER); HSSFFont font = wb.createFont(); font.setFontHeight((short) (font_header_title_size / 0.05)); //14 font.setFontName("Tahoma"); font.setColor(HSSFColor.BLACK.index); styleDescription.setAlignment(HSSFCellStyle.ALIGN_CENTER); HSSFFont fontDescr = wb.createFont(); fontDescr.setFontHeight((short) font_header_descr_size); fontDescr.setFontName("Tahoma"); fontDescr.setColor(HSSFColor.BLACK.index); styleDescription.setAlignment(HSSFCellStyle.ALIGN_CENTER); HSSFFont fontDescr = wb.createFont(); fontDescr.setFontHeight((short) (font_size / 0.05)); //14 fontDescr.setFontName("Tahoma"); fontDescr.setColor(HSSFColor.BLACK.index);
font.setFontHeight((short)(cellStyle.getFontSize()*20)); Boolean bold=cellStyle.getBold(); if(customStyle!=null && customStyle.getBold()!=null){