/** * Sets the font of the entire string. * @param font The font to use. */ public void applyFont(Font font) { String text = getString(); applyFont(0, text.length(), font); }
/** * Applies the specified font to the entire string. * * @param fontIndex the font to apply. */ public void applyFont(short fontIndex) { XSSFFont font; if(styles == null) { font = new XSSFFont(); font.setFontName("#" + fontIndex); } else { font = styles.getFontAt(fontIndex); } String text = getString(); applyFont(0, text.length(), font); }
/** * Applies a font to the specified characters of a string. * * @param startIndex The start index to apply the font to (inclusive) * @param endIndex The end index to apply the font to (exclusive) * @param fontIndex The font to use. */ public void applyFont(int startIndex, int endIndex, short fontIndex) { XSSFFont font; if(styles == null) { //style table is not set, remember fontIndex and set the run properties later, //when setStylesTableReference is called font = new XSSFFont(); font.setFontName("#" + fontIndex); } else { font = styles.getFontAt(fontIndex); } applyFont(startIndex, endIndex, font); }
/** * Applies a font to the specified characters of a string. * * @param startIndex The start index to apply the font to (inclusive) * @param endIndex The end index to apply to font to (exclusive) * @param font The index of the font to use. */ public void applyFont(int startIndex, int endIndex, Font font) { if (startIndex > endIndex) throw new IllegalArgumentException("Start index must be less than end index, but had " + startIndex + " and " + endIndex); if (startIndex < 0 || endIndex > length()) throw new IllegalArgumentException("Start and end index not in range, but had " + startIndex + " and " + endIndex); if (startIndex == endIndex) return; if(st.sizeOfRArray() == 0 && st.isSetT()) { //convert <t>string</t> into a text run: <r><t>string</t></r> st.addNewR().setT(st.getT()); st.unsetT(); } String text = getString(); XSSFFont xssfFont = (XSSFFont)font; TreeMap<Integer, CTRPrElt> formats = getFormatMap(st); CTRPrElt fmt = CTRPrElt.Factory.newInstance(); setRunAttributes(xssfFont.getCTFont(), fmt); applyFont(formats, startIndex, endIndex, fmt); CTRst newSt = buildCTRst(text, formats); st.set(newSt); }
/** * Sets the font of the entire string. * @param font The font to use. */ public void applyFont(Font font) { String text = getString(); applyFont(0, text.length(), font); }
/** * Sets the font of the entire string. * @param font The font to use. */ public void applyFont(Font font) { String text = getString(); applyFont(0, text.length(), font); }
/** * Applies the specified font to the entire string. * * @param fontIndex the font to apply. */ public void applyFont(short fontIndex) { XSSFFont font; if(styles == null) { font = new XSSFFont(); font.setFontName("#" + fontIndex); } else { font = styles.getFontAt(fontIndex); } String text = getString(); applyFont(0, text.length(), font); }
/** * Applies the specified font to the entire string. * * @param fontIndex the font to apply. */ public void applyFont(short fontIndex) { XSSFFont font; if(styles == null) { font = new XSSFFont(); font.setFontName("#" + fontIndex); } else { font = styles.getFontAt(fontIndex); } String text = getString(); applyFont(0, text.length(), font); }
/** * Applies a font to the specified characters of a string. * * @param startIndex The start index to apply the font to (inclusive) * @param endIndex The end index to apply the font to (exclusive) * @param fontIndex The font to use. */ public void applyFont(int startIndex, int endIndex, short fontIndex) { XSSFFont font; if(styles == null) { //style table is not set, remember fontIndex and set the run properties later, //when setStylesTableReference is called font = new XSSFFont(); font.setFontName("#" + fontIndex); } else { font = styles.getFontAt(fontIndex); } applyFont(startIndex, endIndex, font); }
/** * Applies a font to the specified characters of a string. * * @param startIndex The start index to apply the font to (inclusive) * @param endIndex The end index to apply the font to (exclusive) * @param fontIndex The font to use. */ public void applyFont(int startIndex, int endIndex, short fontIndex) { XSSFFont font; if(styles == null) { //style table is not set, remember fontIndex and set the run properties later, //when setStylesTableReference is called font = new XSSFFont(); font.setFontName("#" + fontIndex); } else { font = styles.getFontAt(fontIndex); } applyFont(startIndex, endIndex, font); }
HSSFCell hssfCell = row.createCell(idx); //rich text consists of two runs HSSFRichTextString richString = new HSSFRichTextString( "Hello, World!" ); richString.applyFont( 0, 6, font1 ); richString.applyFont( 6, 13, font2 ); hssfCell.setCellValue( richString ); XSSFRichTextString s1 = new XSSFRichTextString("Apache POI"); s1.applyFont(boldArial); cell1.setCellValue(s1);
font1.setBold(true); font1.setColor(new XSSFColor(new java.awt.Color(255, 0, 0), wb.getStylesSource().getIndexedColors())); rt.applyFont(0, 10, font1); font2.setUnderline(XSSFFont.U_DOUBLE); font2.setColor(new XSSFColor(new java.awt.Color(0, 255, 0), wb.getStylesSource().getIndexedColors())); rt.applyFont(10, 19, font2);
/** * Applies a font to the specified characters of a string. * * @param startIndex The start index to apply the font to (inclusive) * @param endIndex The end index to apply to font to (exclusive) * @param font The index of the font to use. */ public void applyFont(int startIndex, int endIndex, Font font) { if (startIndex > endIndex) throw new IllegalArgumentException("Start index must be less than end index, but had " + startIndex + " and " + endIndex); if (startIndex < 0 || endIndex > length()) throw new IllegalArgumentException("Start and end index not in range, but had " + startIndex + " and " + endIndex); if (startIndex == endIndex) return; if(st.sizeOfRArray() == 0 && st.isSetT()) { //convert <t>string</t> into a text run: <r><t>string</t></r> st.addNewR().setT(st.getT()); st.unsetT(); } String text = getString(); XSSFFont xssfFont = (XSSFFont)font; TreeMap<Integer, CTRPrElt> formats = getFormatMap(st); CTRPrElt fmt = CTRPrElt.Factory.newInstance(); setRunAttributes(xssfFont.getCTFont(), fmt); applyFont(formats, startIndex, endIndex, fmt); CTRst newSt = buildCTRst(text, formats); st.set(newSt); }
/** * Applies a font to the specified characters of a string. * * @param startIndex The start index to apply the font to (inclusive) * @param endIndex The end index to apply to font to (exclusive) * @param font The index of the font to use. */ public void applyFont(int startIndex, int endIndex, Font font) { if (startIndex > endIndex) throw new IllegalArgumentException("Start index must be less than end index."); if (startIndex < 0 || endIndex > length()) throw new IllegalArgumentException("Start and end index not in range."); if (startIndex == endIndex) return; if(st.sizeOfRArray() == 0 && st.isSetT()) { //convert <t>string</t> into a text run: <r><t>string</t></r> st.addNewR().setT(st.getT()); st.unsetT(); } String text = getString(); XSSFFont xssfFont = (XSSFFont)font; TreeMap<Integer, CTRPrElt> formats = getFormatMap(st); CTRPrElt fmt = CTRPrElt.Factory.newInstance(); setRunAttributes(xssfFont.getCTFont(), fmt); applyFont(formats, startIndex, endIndex, fmt); CTRst newSt = buildCTRst(text, formats); st.set(newSt); }
property.getComment()); Font commentFormatter = workbook.createFont(); xssfRichTextString.applyFont(commentFormatter); cellComment.setString(xssfRichTextString); cell.setCellComment(cellComment);