6.2.0 version export to excel - problem with xlsx

[piotr.filu]

Hello,

I have different problem. I added to raport band 'page footer' and there I deifned two things

"Date: "+ DATEFORMAT(NOW(),"yyyy-MM-dd HH:mm:ss")+ "               Total rows: "+ ($V{Report_count}==null?0:$V{Report_count})

"Page " + $V{PAGE_NUMBER}  " of " + $V{PAGE_NUMBER}

looks like at the picture

And

Exported report - xls or xlsx format has unordered columns. I tried added this two things also under report in Detail section but problem is the same. In next step I deleted page footer band (with 2 things) and again export report and everything was good, columns was ordered. Where is problem ? Someone has solution this problem ?

 

 

[hozawa]

JasperReports creates a column on all x coordinates of fields. As such, you need to set the start x position and width of the fields in your footer to align with those in your detail bands.