Tuesday, 18 August 2015

How to resolve can't add a cell error - While Exporting to excel in Jasperserver

This is an error which you get while exporting the data from the Jasperserver in the Excel Format.

Something of this sort

For resolving this you should check some of these errors:

1. Number to string cast exception:
This means that a number is wrongly appended to a string in which wrongly cast number into string.
In order to fix this, you will have to use the command as

new DecimalFormat("##,#0.00").format(number).toString()
This will cast your number into two decimal places with the thousand separator.

2. Another error that can be checked is of any other cast errors, or formatting of the data in the report.


1 comment:

  1. Hey Ankur,

    Can I edit(customize) cell size in table in jaspersoft ireport designer?


Please post your queries or suggestions here!!