Unable to sum cells in generated Excel report

[errol]

Hi guys,

after the report is designed in iReport 3.7.4 and generated in Excel, i'm unable to sum the cells which contain numerical values. Any ideas on why this cannot be done? Has this got anything to do with the cell format which seems to be in General? Is there any setting for it to be generated as Number format in Excel?

Thanks for your replies.

[szaharia]

Hi,

In iReport: Tools --> Options --> Export Options --> Excel --> check 'Detect Cell Type' option --> Ok

HTH,

sanda

[errol]

Hi sanda,

thanks for your help, as that will only work in iReport itself, how do i ensure that the same outcome will happen from outside of iReport? Is there any property to set in the jrxml file itself to preserve this setting so that it will continue to work outside of iReport as well?

Thanks for your replies.

[szaharia]

Hi,

It is strongly recommended to consult the documentation prior to create reports.

There are some builtin export parameters and/or properties to customize such kind of settings. This one is exactly what you need.

To find other useful configuration properties, schema definitions, tutorials, sample documentation, etc, please take a look at this page.

Thanks,

sanda

[errol]

Hi sanda,

i have set this property "net.sf.jasperreports.export.xls.detect.cell.type" to "true" from the documentation that you gave in the jrxml file but it does not work when i generate in iReport or outside of it. This property is supposed to work like the iReport Excel export option "Detect Cell Type" right? Is there anything else that i might have missed out in the setting? The way i have set it is shown below:

<property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>

Thanks for your replies.