Ok. I looked into it a bit. I do not see where I would do it different. So it seems to be not working with fomulas. But I do not know why.... Maybe try it this way: - Do it in Excel. - Read the file with poi and look what it is supposed to be.
What happens if you reread the wrong generated content from the excel with POI? Is the same returned that you put in? Maybe there have to be some characters escaped or something... If this does not give you new insights, you should submit a bug report, because I do not know what else can be done. bye Björn > -----Ursprüngliche Nachricht----- > Von: KHZ (SAW) [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 23. Juni 2004 12:06 > An: 'POI Users List'; [EMAIL PROTECTED] > Betreff: AW: currency formatting: Euro > > > Hi Björn. > > Like expected it also doesn't run using POI 2.5. > > As it's an evaluation I just want to state it as it is. In practical > cases Excel itself could correct such things when opening the file the > next time. > > Regards, Karl-Heinz. > > > -----Ursprüngliche Nachricht----- > Von: KHZ (SAW) [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 23. Juni 2004 11:42 > An: [EMAIL PROTECTED] > Betreff: AW: currency formatting: Euro > > Hi Björn. > > So I'll also test it with POI 2.5 but because of your answer > I think the > result will be the same. > > In the attachment is a small example class generating a small > file using > an empty Excel file as template. > > Regards, Karl-Heinz. > > > -----Ursprüngliche Nachricht----- > Von: Mehner, Björn [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 23. Juni 2004 11:15 > An: [EMAIL PROTECTED] > Betreff: AW: currency formatting: Euro > > I am using POI 2.5 without any problem here. And it is quite a big > project with a lot of reports generated in Excel. > The bugs I found are in both 2.0 and 2.5 and are not related to your > problem :-) > As I told you before I never used it with formats and number cells. I > always used it with String cells. I fetch a format String from a > property file, fill in the data via MessageFormat and the resulting > String is written in the Workbook. Works even with a "€" instead of > "\u20ac" although I feel more comfortable with it. If it does not work > it might be considered a bug. > > Did you already post a piece of code? I think this is always very > helpful. > > bye Björn > > > -----Ursprüngliche Nachricht----- > > Von: KHZ (SAW) [mailto:[EMAIL PROTECTED] > > Gesendet: Mittwoch, 23. Juni 2004 11:03 > > An: Mehner, Björn > > Betreff: AW: currency formatting: Euro > > > > > > Hi Björn. > > > > I'm using POI 2.0. setEncoding() alone and plus replacing "€" be > > "\u20ac" didn't work. The result is still the same. > > > > What POI version do you use? For this small project just needed for > > comparisons I could use any POI version where it just runs. > > > > Version 2.0 is the version which we always used not having > > big problems. > > > > Thanks and regards, > > > > Karl-Heinz. > > > > > > -----Ursprüngliche Nachricht----- > > Von: Mehner, Bj?rn [mailto:[EMAIL PROTECTED] > > Gesendet: Mittwoch, 23. Juni 2004 09:19 > > An: POI Users List; [EMAIL PROTECTED] > > Betreff: AW: currency formatting: Euro > > > > Did you try the unicode representation of the €? it is > > "\u20ac". But be > > aware! If I recall right it is a 16bit Unicode character and > > Excel uses > > only 8bit on default. So you have to set the encoding via > > cell.setEncoding(HSSFCell.ENCODING_UTF_16). Maybe the last > > step already > > does the trick without using "\u20ac" > > > > But I do not know if this solves your problem with > formulas/formats. I > > only tried this with normal cell content. > > > > ciao Bodo > > > > PS: Feedback if it worked will be welcome. > > > > > -----Ursprüngliche Nachricht----- > > > Von: KHZ (SAW) [mailto:[EMAIL PROTECTED] > > > Gesendet: Dienstag, 22. Juni 2004 16:52 > > > An: 'POI Users List'; [EMAIL PROTECTED] > > > Betreff: AW: currency formatting: Euro > > > > > > > > > Hi world. > > > > > > It's possible to select various Euro currency formatting > symbols (or > > > however it's named. > > > > > > I've tested it with several variants, e.g. "#,##0 [$€-1]" > > or also with > > > -407 instead of -1 or even just $ without all that > bracketing. It's > > > always the same. I see the negation symbol of formal logic > > (a > turned > > > 45° to the left). > > > > > > What's going wrong? Isn't the Euro symbol supported by POI? All > > > notations lead to the same result. But these format strings > > are shown > > > when recording Excel macros and don't lead to errors if > > > they're applied > > > in POI. > > > > > > Regards, Karl-Heinz. > > > > > > > > > -----Ursprüngliche Nachricht----- > > > Von: KHZ (SAW) [mailto:[EMAIL PROTECTED] > > > Gesendet: Dienstag, 22. Juni 2004 15:09 > > > An: [EMAIL PROTECTED] > > > Betreff: currency formatting: Euro > > > > > > Hi world. > > > > > > How do I obtain the Euro symbol? > > > > > > The first trial was > > > oCS.setDataFormat(oFmt.getFormat("#,##0 $")); > > > > > > That format string is the string written in the Excel > macros when I > > > record them. I wondered why there is “$” when I see “€”. > > > > > > So the next trial was "#,##0 €". But that brings the > > negation sign of > > > formal logic (similar to –i; but just one digit). > > > > > > So how will I be successful to see € (Euro). > > > > > > Regards, Karl-Heinz. > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > >
smime.p7s
Description: S/MIME cryptographic signature
