[#4128] - Support adding Excel's Page Header when exporting in xls format

Posted by hozawa on February 25, 2015 - 9:20pm
Category:
Enhancement request
 Priority:
Normal
 Status:
Resolved
Project:
JasperReports® Library
 Severity:
Minor
 Resolution:
Fixed
Component: Reproducibility:
N/A
 Assigned to:
hozawa
Subscribe

Currently, only text string can be set to excel page header/footer using properties such as
net.sf.jasperreports.export.xls.sheet.header.right

If I set the value to "&[Page]", it is exported as a string and is not evaluated until the Header/Footer is opened from Excel.
It would be nice to have &[Page], &[Date], &[Time],&[Pages],&[File],&[Tab] supported.

hozawa's picture
hozawa
177961
Joined: Apr 24 2010 - 4:31pm
Last seen: 4 years 12 hours ago

4 Comments:

#1Posted by hozawa on February 26, 2015 - 11:38am
  • Assigned:nobody»

Attached is a source code fix to support exporting &[Page], &[Date], &[Time],&[Pages],&[File],&[Tab] in Excel headers. Just replace the code in JasperReports JExcelApiExporter.java and rebuild.

AttachmentSize
Plain text icon jexcelapiexporter.txt5.26 KB
#2Posted by rick.kruyf on March 5, 2015 - 8:12am
  • Reproducibility:Always» N/A
  • Status:New» Feedback Requested
  • Assigned:» hozawa

Is the JExcelApiExporter.java file part of the Jaspersoft Studio Professional 5.6.1? I have scanned both the server and studio libraries and have not found the file.

#3Posted by hozawa on March 5, 2015 - 6:08pm

It's part of JasperReports jar. jasperreports-x.x.x-project.zip contains the source files.
http://sourceforge.net/projects/jasperreports/files/jasperreports/

#4Posted by hozawa on March 19, 2015 - 3:02pm
  • Resolution:Open» Fixed
  • Status:Feedback Requested» Resolved
Feedback