Oops, my bad - I should have actually tried before claiming it doesn't work...
POI however seems to loose this information when processing an excel file. (i.e. read .xls file, write back to disk). The Unicode approach to the original problem nontheless works (at least for me and my fonts-configuration). Tobias > -----Ursprüngliche Nachricht----- > Von: Anthony Andrews [mailto:[EMAIL PROTECTED] > Gesendet: Samstag, 3. Dezember 2005 12:17 > An: POI Users List; Christian Gosch > Betreff: Re: 2 Fonts in 1 Cell - ByteArrayInputStream > > > Hello Christian > > Must admit I did not quite believe it myself but you > can indeed set two - or more - fonts on a single > string in one cell. But I think that you face one huge > problem. > > I could be wrong but I think that HSSF uses the > Excel97 format as standard and as you indicate below, > it may only be possible to use two fonts in one cell > in Excel versions 2000 on. > > --- Christian Gosch <[EMAIL PROTECTED]> wrote: > > > Actually it does, depending on the version (should > > be Excel2000 or newer). > > Look on the attachment "multifontexample.xls", if it > > is still there. > > > > Regards > > Christian Gosch > > inovex GmbH > > > > > > On Friday, December 02, 2005 10:45 AM [GMT+1=CET], > > Tobias Meyer <[EMAIL PROTECTED]> wrote: > > > > > AFAIK Excel does not support two fonts in one > > cell. Try doing thin in > > > excel itself... > > > > > > As "workaround" (maybe it's cleaner anyways...) > > try settung your > > > Cell's encoding to UTF-16 and use the Unicode > > character \u2211 (Sum) > > > or maybe the Greek Sigma \u03A3, if the Sum Symbol > > is not in your > > > Font. > > > > > > i.e.: > > > > > > HSSFCell cell = row.createCell(x); > > > cell.setEncoding(HSSFCell.ENCODING_UTF_16); > > > cell.setCellValue("\u2211 "+yourStringHere); // > > Sum sign + your text > > > > > > See: > > > > > > http://www.unicode.org/charts/ for a definition of > > the unicode > > > characters, and > > > http://www.unicode.org/charts/PDF/U2200.pdf for a > > whole bunch of > > > mathematical symbols. > > > > > > A Pitfall with this attempt may be that not all > > fonts support all > > > characters - but it is well worth a try... > > > > > > For a general introduction to Unicode I recommend: > > > > > http://www.joelonsoftware.com/articles/Unicode.html > > > (Do you know the difference between Unicode, UTF-8 > > and UTF-16 ? ;-) > > > > > > Hth, > > > Tobias > > > > > > > > >> -----Ursprüngliche Nachricht----- > > >> Von: smashy [mailto:[EMAIL PROTECTED] > > >> Gesendet: Dienstag, 29. November 2005 09:34 > > >> An: poi-user@jakarta.apache.org > > >> Betreff: 2 Fonts in 1 Cell - ByteArrayInputStream > > >> > > >> > > >> Hi, > > >> > > >> is it possible to use 2 different Font typs > > (Arial , Symbol) > > >> in one Excel cell? > > >> I use a ByteArrayInputStream from Oracle DB to > > create a HSSF > > >> workbook. This > > >> stream contained the whole workbook with cells > > which switch > > >> the Fonts. After > > >> creating the HSSFWorkbook my cells shwoing only > > one Font. > > >> Why? Waht can i do if > > >> i need tow font per cell? I need the "Summ" > > Symbol from the > > >> Symbol FontSet. > > >> > > >> THX! > > >> > > >> IKT - http://kickme.to/smashy > > >> > > >> > > >> > > > --------------------------------------------------------------------- > > >> To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > >> Mailing List: > > http://jakarta.apache.org/site/mail2.html#poi > > >> The Apache Jakarta Poi Project: > > http://jakarta.apache.org/poi/ > > >> > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > > Mailing List: > > http://jakarta.apache.org/site/mail2.html#poi > > > The Apache Jakarta Poi Project: > > http://jakarta.apache.org/poi/ > > > > Gruesse, > > -- > > Dipl.-Inform. Christian Gosch > > Systems Development > > inovex GmbH > > Karlsruher Strasse 71 > > D-75179 Pforzheim > > Tel.: +49 (0)72 31 - 31 91 - 85 > > Fax: +49 (0)72 31 - 31 91 - 91 > > mailto:[EMAIL PROTECTED] > > http://www.inovex.de > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > Mailing List: > > http://jakarta.apache.org/site/mail2.html#poi > > The Apache Jakarta Poi Project: > http://jakarta.apache.org/poi/ > > > > > __________________________________ > Start your day with Yahoo! - Make it your home page! > http://www.yahoo.com/r/hs > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
