Jump to content
Changes to the Jaspersoft community edition download ×

Recommended Posts

By: Wolfgang - javabreak

JRXlsExporter

2003-04-14 07:00

Hi,

 

when exporting a report to XLS we get the following problem.

 

Numbers are always exported as String (see Line 622 JRXlsExporter.java). In Excel we must manually convert the columns to numbers to use the columns in forumulas.

In POI you can use setCellValue(double) to tell excel that this is a number.

My proposal know is the following:

Try to convert the text to Double, if this is ok then call

setCellValue(Double.doubleValue())

otherwise use the original method.

 

Am I on the right way?

 

Thank you

 

Wolfgang

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...