Jasper exporting to spreadsheet with numbers formatted as text

If you're using Jaspersoft Studio then click at the report name, then on the properties tab click "Advanced" and expand "Misc" there you will find properties. Attaching the screenshot with white page background property set to false for XLS export, verified to work in iDempiere as well.

@hahmed i have maked the changes on my report, i know how make this, but idempiere don't take this changes, why ? or how exactly you are doing that ?

Almost everyone using Jasper I know is creating a template report with all the parameters set and using it to create their reports. These changes can be applied per report basis or per server basis (using plugin) without any difficulty and since we are not changing jasper properties in code for anything else, IMO it would be better to keep it as a report developer configurable option. In any case, creation of a jasper report is not an end-user task but a report developer task, who should be familiar with jasper properties and be able to set them per report. It would be more sensible if the reports act in iDempiere exactly the same way they act in Jaspersoft Studio, which will not be the case if we change jasper properties defaults in iDempiere.

hi, you think somebody need a excel file with a white page background ? i think a good practice would be make configurable, but a excel file without this parameters is unusable

net.sf.jasperreports.export.xls.remove.empty.space.between.rows=true
net.sf.jasperreports.export.xls.remove.empty.space.between.columns=true
net.sf.jasperreports.export.xls.detect.cell.type=true
net.sf.jasperreports.export.xls.ignore.cell.background=true
net.sf.jasperreports.export.xls.ignore.graphics=true
net.sf.jasperreports.export.xls.collapse.row.span=true
net.sf.jasperreports.export.xls.white.page.background=false

If you read the comments above, you can see that the recommended strategy for customizing Jasper properties would be to use jasperreports.properties. The file can be deployed using the same process used to deploy jasper fonts (check the org.adempiere.report.jasper.fonts plugin in source)