Hi, You should try to set the format you want in Excel and then read it with POI to see how it looks like.
Pierre Cordialement, Pierre Lavignotte Ingénieur Conception & Développement http://pierre.lavignotte.googlepages.com On Tue, Jan 27, 2009 at 8:10 PM, [email protected] < [email protected]> wrote: > Hi all, > > I'm using 3.2 version and I'm doing that: > > cell.setCellValue(Double.parseDouble(sharePercent)/100); (this set a value > like this 00,00) > > but I don't know how to fix the percent format I want. > > I've tried with style.setDataFormat((short)0xa); but it sets the coma one > digit to the left, for example 1,667% instead of 16,67% > I also have tried with style.setDataFormat(format.getFormat("00,00%")); and > others > > Any idea? > > Thanks and regards > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
