Götz, I'm not sure if I fully understand the nature of your problem... however, see if the following approach helps you:
1. Create an excel file using MS Excel, add a cell havig data formatted as you desire (with the euro symbol and all that). 2. Save the file and open it using POI-HSSF in Java and get the DataFormat. Following API calls should be helpful: HSSFCell.getDataFormat() HSSFDataFormat.getFormat(short index) This should give you the string that you can use in your java code to contruct the DataFormat. HTH, ~ amol > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 21, 2005 4:57 PM > To: [email protected] > Subject: Euro Symbol in HSSFDataFormat > > > I'm a newbie to mailing list how do I search for specific > topic. To get > the Mails > to this topic. Even if there are old. > > Excuse, there was an discussion on the mailing list. > But I haven't found them again. > All suggestions which were made, doesn't work. > So how to format Currency that won't use $ . > Is there an known format descripition to get the Euro Currency Smbol > 1 .HSSFDataFormat.getFormat("#.00\u20AC). won't work symbol > for 00AC occurs > 2. HSSFDataFormat.getFormat("#.00\u0080) won't work (0080 > Euro Symbol in > OEM) > 3 . HSSFDataFormat.getFormat("#.##0 [$-2] ) not tested yet (in Exel > 2000 will produce the euro symbol in userdefined format) > To 3. > that's real edge brackets and the dollar Symbol then the Euro Symbol > minus 2. > that's what my Excel Version 2000 Professional German makes if i will > format > the cell as userdefined format for Euro. > To 3 I think poi will have the same problem which it has with > number one. > Some times the syntax of Excel seems to be strange, because > [] this is normally conditional formatting. > > Any suggestions about this topic are welcome. > > I' ve also tried to get into the poi source but there I need > more time > to understand > the source and it nuts and bolts. In ExtendedRecordSet seems > to be the > formatting field and > there are some conversions with LittelEndian. But why some of this > conversions happens I haven't > understand. because there are bigger fields and then arrays would be > generate and converted into smaller values. The details at this point > are littel bit confusing. I' think I have to less information to > understand this, at this point of working into the source. > > Thx Götz > > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
