Is there a way to insert page number in xls export file?
I've tried to use "net.sf.jasperreports.export.xls.sheet.header.left" property to insert &[Page] but it does not work properly.
It's inserted as a text instead of a number.
However, I've found that if I open the header from Excel, Excel converts the text to page numbers.
Is there a way so I don't have to open header on each Excel sheet to print page number in a header.