poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Princess <hepzib...@googlemail.com>
Subject Re: trailing Euro symbol on a format String.
Date Fri, 29 Jan 2010 12:22:23 GMT
thanks for the input ...
I was using Stylesheet  and SAX Content handlers. and in the Handler using
POI for Formatting ..
I changed my POI version today and now it works

Thanks for all your Solutions.It helped a lot
Hepzibah
**Hope can be ignited by a spark of encouragement *****



On Fri, Jan 29, 2010 at 8:35 AM, MSB <markbrdsly@tiscali.co.uk> wrote:

>
> I do not know if you are still searching for a solution and neither do I
> know
> if this will work as it only occurred to me in the middle of the night.
>
> Can I ask, are you creating the workbook from scratch using Excel rather
> than opening and editing a file that someone elase has produced? If the
> former, then it may be possible to do something like the following;
>
> Use Excel to create a new, blank workbook.
> Add a custom data format to the workbook - "##,##0.00€"
> Save the workbook away as a template file (you do not have to create a
> template - .xlt - file, you can save it as an xls).
> When you run your POI application, open the template and use it as the
> basis
> for the file that you create.
> Save the completed file away under a different name so that you do not
> over-write the template and it is there for furute use.
>
> Hopefully, when you try execute the getFormat() method call, POI will now
> identify that a format exists which matches the String you supply as a
> parameter to that method call and will return it for you. This might
> overcome the problem but I cannot promise success because I have not tested
> the idea yet.
>
> Yours
>
> Mark B
>
>
> Princess-4 wrote:
> >
> > Iam using POI 2.5
> >
> > this.styleEuro.setDataFormat(wb.createDataFormat().getFormat("##,##0.00
> > €"));
> > shows a vague symbol in place of Euro ...
> > The same user defined format works in Excel  but the same works for $
> > through POI
> >
> > Also
> >
> this.styleEuro.setDataFormat(wb.createDataFormat().getFormat("0.00\"$\""));
> > works
> > but when i replace $ with € then a vague symbol appears.
> >
> >
>
> --
> View this message in context:
> http://old.nabble.com/trailing-Euro-symbol-on-a-format-String.-tp27312689p27367107.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message