Jump to content
Changes to the Jaspersoft community edition download ×

Thousand separator when exporting to Excel


temakela

Recommended Posts

In my JRXML I've used thousand separator. In PDF the result is fine and the XLS also looks fine.

 

However, when I try to calculate something in the XLS those values that are bigger than 999 (there is a thousand separator) are NOT numbers anymore but strings. Thus any calculation has become impossible. Using Excel it is impossible to convert values back to numbers because there is space character. I should manually delete the scape from every field.

 

Is there any way to change the thousand separator in such a way that all fields would be intepreted as numbers in Excel? Now the Excel export is pretty much useless.

Link to comment
Share on other sites

  • Replies 1
  • 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...