Thanks for the solution...it worked..
Similarly i wanted € sign along with the values...it shows vague characters
..These are my tries
**this.styleEuro.setDataFormat(wb.createDataFormat().getFormat("##,##0.00€"));
**this.styleEuro.setDataFormat(wb.createDataFormat().getFormat("##,##0.00\"€\""));
**
this.styleEuro.setDataFormat(wb.createDataFormat().getFormat("##,##0.00\"\u20AC\""));
**this.styleEuro.setDataFormat(wb.createDataFormat().getFormat("##,##0.00\'\u20AC\'"));
**this.styleEuro.setDataFormat(wb.createDataFormat().getFormat("##,##0.00\u20AC"));
all these renders me the same output and the without currency symbol .
Where am i going wrong ...
**Hope can be ignited by a spark of encouragement *****
On Sat, Jan 23, 2010 at 10:25 AM, MSB <[email protected]> wrote:
>
> Turns out it was the single inverted comma that you used to surround the kg
> symbol with; it should have been speach marks or quotation marks. Try this;
>
> public static final void kgFormat(String filename) {
> File file = null;
> FileOutputStream fos = null;
> HSSFWorkbook workbook = null;
> HSSFSheet sheet = null;
> HSSFRow row = null;
> HSSFCell cell = null;
> HSSFCellStyle numberStyle = null;
> try {
> file = new File(filename);
> workbook = new HSSFWorkbook();
> numberStyle = workbook.createCellStyle();
>
> numberStyle.setDataFormat(workbook.createDataFormat().getFormat("0.00\"
> kg\""));
> sheet = workbook.createSheet();
> row = sheet.createRow(0);
> cell = row.createCell(0);
> cell.setCellValue(10.023);
> cell.setCellStyle(numberStyle);
>
> fos = new FileOutputStream(file);
> workbook.write(fos);
> }
> catch(IOException ioEx) {
> System.out.println("Caught an: " + ioEx.getClass().getName());
> System.out.println("Message: " + ioEx.getMessage());
> System.out.println("Stacktrace follows:............");
> ioEx.printStackTrace(System.out);
> }
> finally {
> try {
> if(fos != null) {
> fos.close();
> }
> }
> catch(IOException ioEx) {
>
> }
> }
> }
>
> It works for me using POI version 3.6 and Office 2007. If you do not want
> the space between the final digit and the kg symbol, simply change this
> line;
>
> numberStyle.setDataFormat(workbook.createDataFormat().getFormat("0.00\"
> kg\""));
>
> to this;
>
>
> numberStyle.setDataFormat(workbook.createDataFormat().getFormat("0.00\"kg\""));
>
> Yours
>
> Mark B
>
> PS This goes without saying of course, I only made this into a static
> method
> so that I could plug the test code into a junk class I use to
> prototype/test
> this type of thing. You will want to do something different for your code I
> am sure.
>
>
> Princess-4 wrote:
> >
> > I have already tried all these combinations.I get error ehen i open the
> > file
> > Hepzibah
> > **Hope can be ignited by a spark of encouragement *****
> >
> >
> >
> > On Fri, Jan 22, 2010 at 3:19 PM, MSB <[email protected]> wrote:
> >
> >>
> >> Have you tried
> >>
> >> this.styleKg.setDataFormat(wb.createDataFormat().getFormat("#,##000
> >> \'kg\'"));
> >>
> >> or
> >>
> >> this.styleKg.setDataFormat(wb.createDataFormat().getFormat("#,##000
> >> kg"));
> >>
> >> or even
> >>
> >>
> this.styleKg.setDataFormat(wb.createDataFormat().getFormat("#,##000kg"));
> >>
> >> just to see if the problem has to do with the single inverted commas
> >> surrounding the units symbol? Have no idea if this will help at all,
> >> sorry.
> >>
> >> Yours
> >>
> >> Mark B
> >>
> >>
> >> Princess-4 wrote:
> >> >
> >> > this.styleKg.setDataFormat(wb.createDataFormat().getFormat("#,##000
> >> > 'kg'"));
> >> >
> >> >
> >> > is not setting the format in the cell with POI 2.5 .basically i want
> >> 1000
> >> > Kg
> >> > to be written in the cell
> >> > along with the unit.
> >> >
> >> > The same user defined format works in Excel..
> >> >
> >> > But to display %
> >> > this.stylePer.setDataFormat(wb.createDataFormat().getFormat("0.00%"));
> >> is
> >> > working
> >> >
> >> > thanks
> >> >
> >> >
> >>
> >> --
> >> View this message in context:
> >>
> http://old.nabble.com/Units-to-be-set-through-getFormat%28%29-tp27271302p27273826.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]
> >>
> >>
> >
> >
>
> --
> View this message in context:
> http://old.nabble.com/Units-to-be-set-through-getFormat%28%29-tp27271302p27284589.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]
>
>
