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