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: [email protected]
For additional commands, e-mail: [email protected]
