Thousand separator when exporting to Excel

[temakela]

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.

[agcelio]

Have you select the option is detect cell type on options export , for xls exporter?