trailing Euro symbol on a format String.

[Princess <he...@googlemail.com>]

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.

Re: trailing Euro symbol on a format String.

[Princess <he...@googlemail.com>]

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 <ma...@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
>
>

Re: trailing Euro symbol on a format String.

[MSB <ma...@tiscali.co.uk>]

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