You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Francesco Vivoli <fv...@futurespace.es> on 2005/03/09 12:55:47 UTC

Euro symbol within text

Hi all,
I'm able to insert a numeric value in a cell
with the U+20AC code attached through

df = format.getFormat(...);
cell.setFormat(df);

Nevertheless after digging the archive for a while
I haven't come up with a solution for displaying this
"€" within a string, i.e
"this is a string with € and some more"

Even creating the sheet with
        HSSFSheet        s    = wb.createSheet();
        wb.setSheetName(0,"title",HSSFWorkbook.ENCODING_UTF_16);

inserting the symbol doesn't work and neither it does
if inserting \u20ac within the text.
I think I have an idea of why it doesn't work, the only issue
here is that i am still missing the solution...All I get is
a negative logic sign.

I really hope that solution is near, and I would really apreciate
if someone here could enlight me.
Thanks,
Francesco




---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


RE: Euro symbol within text

Posted by Francesco Vivoli <fv...@futurespace.es>.
ehehehe,
that missing method...
sorry, I've should have looked digged more in
javadoc.
Thanks anyway,
Francesco

> -----Mensaje original-----
> De: Avik Sengupta [mailto:avik.sengupta@itellix.com]
> Enviado el: miércoles 9 de marzo de 2005 12:58
> Para: fvivoli@futurespace.es
> CC: poi-user@jakarta.apache.org
> Asunto: Re: Euro symbol within text
>
>
> have you tried cell.setCellEncoding()...
>
> On Wed, 2005-03-09 at 12:55 +0100, Francesco Vivoli wrote:
> > Hi all,
> > I'm able to insert a numeric value in a cell
> > with the U+20AC code attached through
> >
> > df = format.getFormat(...);
> > cell.setFormat(df);
> >
> > Nevertheless after digging the archive for a while
> > I haven't come up with a solution for displaying this
> > "€" within a string, i.e
> > "this is a string with € and some more"
> >
> > Even creating the sheet with
> >         HSSFSheet        s    = wb.createSheet();
> >         wb.setSheetName(0,"title",HSSFWorkbook.ENCODING_UTF_16);
> >
> > inserting the symbol doesn't work and neither it does
> > if inserting \u20ac within the text.
> > I think I have an idea of why it doesn't work, the only issue
> > here is that i am still missing the solution...All I get is
> > a negative logic sign.
> >
> > I really hope that solution is near, and I would really apreciate
> > if someone here could enlight me.
> > Thanks,
> > Francesco
> >
> >
> >
> >
> >
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> > The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
> >
> --
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Re: Euro symbol within text

Posted by Avik Sengupta <av...@itellix.com>.
have you tried cell.setCellEncoding()...

On Wed, 2005-03-09 at 12:55 +0100, Francesco Vivoli wrote:
> Hi all,
> I'm able to insert a numeric value in a cell
> with the U+20AC code attached through
> 
> df = format.getFormat(...);
> cell.setFormat(df);
> 
> Nevertheless after digging the archive for a while
> I haven't come up with a solution for displaying this
> "€" within a string, i.e
> "this is a string with € and some more"
> 
> Even creating the sheet with
>         HSSFSheet        s    = wb.createSheet();
>         wb.setSheetName(0,"title",HSSFWorkbook.ENCODING_UTF_16);
> 
> inserting the symbol doesn't work and neither it does
> if inserting \u20ac within the text.
> I think I have an idea of why it doesn't work, the only issue
> here is that i am still missing the solution...All I get is
> a negative logic sign.
> 
> I really hope that solution is near, and I would really apreciate
> if someone here could enlight me.
> Thanks,
> Francesco
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
> 
-- 


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/