Jasper Reports 3.0 with Advanced Excel Formula Handling
Version 3.0.0 of Jasper Reports, a free Java report generating library with advanced export functionality has just been released.
New properties, which can be defined for each element in the generated report, add more flexibility. Element properties can also be specified as expressions that are evaluated on generating the documents.
The major innovations relate to exporting to Microsoft's Excel format, XLS: developers can specify cell formulas in the "net.sf.jasperreports.export.xls.formula" property; the formulas can either be evaluated or inserted into the Excel document as is. The program now has more elegant page break handling thanks to the new "net.sf.jasperreports.export.xls.break.before.row" and "net.sf.jasperreports.export.xls.break.after.row" properties.
On top of this, there is an experimental export feature to Microsoft's Excel XMLSS format, which can output large documents as a stream. More changes are listed in the Changelog.
Jasper Reports is licensed under the LGPL. The current 3.0.0 version is available for downloading as a source code or Jar archive on the project website.
Comments
comments powered by Disqus
Issue 252/2021
Buy this issue as a PDF
News
-
GNOME 41 Has Arrived
The latest version of the GNOME desktop environment has been released with new functionality and plenty of improvements.
-
System76 Updates the 15" Pangolin with Ryzen
System76 announced they’re updating the Ryzen-powered Pangolin laptop to meet today’s need for more power.
-
KDE Plasma 5.23 Promises Plenty of Subtle Improvements
The next release of the KDE Plasma desktop includes new features, numerous improvements, and plenty of bug fixes.
-
GNOME 41 Beta is Now Available
The most popular open-source desktop environment is on the cusp of yet another new release, but don’t expect the massive changes found in the previous iteration.
-
Debian 11 “Bullseye” Now Available
The developers of Debian have released the latest version of the operating system so many distributions depend on.
-
Elementary OS 6 Odin Now Available
The developers of elementary OS have released their latest iteration which is all-in on Flatpaks and all about the user experience.
-
Kubuntu Focus Team Announces High-Performance Focus XE
The team behind the KDE-powered Linux laptops is now offering an ultra-portable laptop that doesn't skimp on performance.
-
Solus 4.3 Available for Download and Installation
The latest iteration from the Solus developers is out with kernel 5.13 and plenty of new features, bug fixes, and new hardware support.
-
Steam Deck Linux-Powered Gaming System Set to Take Over the Handheld World
A Linux and KDE-powered portable gaming platform is set to be released by Valve.
-
Linux Mint 20.2 Available and Better Than Ever
The developers of Linux Mint have gone a long way to perfecting the desktop experience.
Exporting reports from JasperReports in Excel, Word and PowerPoint formats