POI set print quality (to 600dpi) for page setup

Hi , Could you please help me in setting the print quality (to 600dpi) for page setup for an xls file using POI. Thanks Rakesh -- View this message in context: http://apache-poi.1045710.n5.nabble.com/POI-set-print-quality-to-600dpi-for-page-setup-tp4258244p4258244.html Sent from the POI - User

Re: Round to one Decimal place not happenning using " style.setDataFormat(format.getFormat("0.0")); "

Hi Mark, Thank you very much for support have changed the format in JExcelAPI and getting one decimal formatting done. Thanks Rakesh -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Round-to-one-Decimal-place-not-happenning-using-style-setDataFormat-format-getFormat-0-0-

Re: Round to one Decimal place not happenning using " style.setDataFormat(format.getFormat("0.0")); "

Hi Mark, We have actually created xls file using jxl API since it doesn't have some options for formatting we have reused the xls in POI API to get the formatting done. Thanks Rakesh -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Round-to-one-Decimal-place-not-happenni

Re: Round to one Decimal place not happenning using " style.setDataFormat(format.getFormat("0.0")); "

Hi, somehow the cell type is still General even after setting the type to numeric as shownin code below. here i am setting decimal zero for some columns and one for some which is stored in string array. HSSFCellStyle stylezero = wb.createCellStyle(); HSSFDataFormat dfzero = wb.createDat

Re: Round to one Decimal place not happenning using " style.setDataFormat(format.getFormat("0.0")); "

Thanks for the reply Mark. You suggestion on this works. Do we have any method in POI which works exactly as Decrease decimal functionality in excel. The cell should show value with decimal point reduced but if we click on the cell the formula bar should show the actual value. Thanks Rakesh -- Vi

Re: Round to one Decimal place not happenning using " style.setDataFormat(format.getFormat("0.0")); "

Hi Mark, Thanks for the reply. I used the code for my excel but not getting reduced to one decimal place as given in the code. I am lost for options now. Thanks Rakesh -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Round-to-one-Decimal-place-not-happenning-using-styl

Re: Round to one Decimal place not happenning using " style.setDataFormat(format.getFormat("0.0")); "

Hi Mark, Thank you for the response. Will remove the multiple set styles from the loop. I am looking for normal rounding behaviour as specified by you . Will attach the excel file for your reference where i am trying to convert column "S1" elements to one decimal place. http://apache-poi.1045710.n

Re: Round to one Decimal place not happenning using " style.setDataFormat(format.getFormat("0.0")); "

Hi Nick , please find the code i have written to convert the data in cells to one decimal place. for (int i=14;ihttp://apache-poi.1045710.n5.nabble.com/Round-to-one-Decimal-place-not-happenning-using-style-setDataFormat-format-getFormat-0-0-tp3404980p3406162.html Sent from the POI - User mailing

Round to one Decimal place not happenning using " style.setDataFormat(format.getFormat("0.0")); "

Hi, I have been working on rounding data to one Decimal place not happenning using " style.setDataFormat(format.getFormat("0.0")); ". It is not working. It would be great if someone could suggest me an alternative. Thanks Rakesh -- View this message in context: http://apache-poi.1045710.n5