Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1702
  • Last Modified:

Jasper Report


Hello there,

i am trying to save a jasperviewer as excel file.but i get this error.i have no problem printing.
i also added the poi-3.5-beta4-20081128 jar file to my application

Exception in thread "AWT-EventQueue-0" java.lang.NoSuchMethodError: org.apache.poi.hssf.usermodel.HSSFSheet.addMergedRegion(Lorg/apache/poi/hssf/util/Region;)I
      at net.sf.jasperreports.engine.export.JRXlsExporter.createMergeRegion(JRXlsExporter.java:558)
      at net.sf.jasperreports.engine.export.JRXlsExporter.initCreateCell(JRXlsExporter.java:530)
      at net.sf.jasperreports.engine.export.JRXlsExporter.createTextCell(JRXlsExporter.java:520)
      at net.sf.jasperreports.engine.export.JRXlsExporter.exportText(JRXlsExporter.java:391)
      at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:561)
      at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:434)
      at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:218)
      at net.sf.jasperreports.view.save.JRSingleSheetXlsSaveContributor.save(JRSingleSheetXlsSaveContributor.java:112)
      at net.sf.jasperreports.view.JRViewer.btnSaveActionPerformed(JRViewer.java:1128)
      at net.sf.jasperreports.view.JRViewer$3.actionPerformed(JRViewer.java:668)
      at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
      at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
      at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
0
zolf
Asked:
zolf
  • 6
  • 6
1 Solution
 
objectsCommented:
you're using an incompatible version of poi

0
 
zolfAuthor Commented:

do i use an older version poi
this one poi-3.2-FINAL-20081019 or can you give me the link to theversion i need to download
0
 
objectsCommented:
yes u need an older version
what version of jasper?

0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
zolfAuthor Commented:

what version of jasper?
jasperreports-3.0.0
0
 
objectsCommented:
try 2.0 while I ask around


0
 
zolfAuthor Commented:

cheers mate
0
 
objectsCommented:
0
 
zolfAuthor Commented:

what is the way out
0
 
objectsCommented:
how did 2.0 go?  It should still work

0
 
zolfAuthor Commented:

is that jasper 2.0 or poi
0
 
zolfAuthor Commented:

i downlaaded this poi-3.0.1-FINAL.jar adn when i try to save i dont get that exception.but i dont see the values in the cells
1.jpg
0
 
objectsCommented:
others having problems as well

http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=50185

perhaps file a report with jasper

0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 6
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now