Excel export and cell formatting issue

[lknueve]

 Hello. I have a report that I am exporting to Excel and for the most part it's working great now. There is one issue however that I can't seem to figure out. I have a few columns that are exporting excel formulas (using net.sf.jasperreports.export.xls.formula) and they are working, but one of the columns is not formatted properly? I have the expression class set to java.math.BigDecimal, with a field of the same type in the Text field expression, and the formula is doing a subtraction of date/times to find how long something took. However, when exporting the report, this field keeps returning 0 for all records. Since none of the records should be greater than 1, this may be valid, but we need to see the decimal points to find out the actual length of time.

Is there any way to force excel to format a cell to Number with 6 decimal places? 

[lknueve]

Oh! I forgot to mention that I do have the net.sf.jasperreports.export.xls.detect.cell.type set to true

[lknueve]

 for anyone who may come across this same issue, here's how I did it: 

it was a modification to the excel formula. Here's what I had originally for example in the Excel formula: 

"=IF(\$A$1=\$A2, \$B2, 0)"

I modified it to do the following: 

"=TEXT(IF(\$A$1=\$A2, \$B2, 0), \"#,##0.000000\")"