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 248/2021
Buy this issue as a PDF
News
-
Slimbook Goes All in with a Linux Laptop that Focuses on the Display and the Power
Slimbook is now offering a Linux laptop geared for professionals, with the launch of a new lightweight ultrabook with plenty of power to spare.
-
KDE Plasma 5.22 Released with Better Stability and Usability Across the Board
The KDE Plasma desktop development has kicked into high gear and the latest release reflects newfound popularity and drive behind the open-source environment.
-
Nvidia and Valve Collaborate to Bring DLSS to Linux
Both powerhouses in the gaming industry are trying to make the experience on Linux much improved, by way of DLSS.
-
Kali Linux 2021.2 Official Release Now Available
The latest iteration of security fan-favorite Kali Linux has been released with new tools, themes, and plenty of improvements.
-
Entroware Unleashes a Beast of a Linux Laptop
If you're looking for a portable workhorse, look no further than the Entroware Proteus laptop.
-
System76 Unveils its “Launch” Keyboard
The open-source darling, System76, is about to launch the Launch keyboard and you can pre-order yours now.
-
Armbian 21.05 Now Available
The Armbian developers have released the latest update to the Debian-based Linux distribution geared for ARM and embedded devices.
-
StarLabs has Released Another Linux Laptop
A new 14" Linux laptop has been released by the company that created the 11" Star Lite and can be purchased with your choice of Linux distribution.
-
Ubuntu 21.04 Adds Support for Active Directory and Other Major Changes
In a bid to help make Linux more viable for the business desktop, Canonical adds support for Active Directory and a few other notable changes.
-
GNOME 40 Available on openSUSE
The rolling release edition of openSUSE, Tumbleweed, now offers the latest version of the GNOME desktop.
Exporting reports from JasperReports in Excel, Word and PowerPoint formats