Release History

Breadcrumbs

Release History

Team AOP 19-MAY-2020

Version 20.1.4 of APEX Office Print (AOP) is now ready to be downloaded in the download section.
AOP 20.1.4 is compatible with APEX 18.x and higher. (for APEX 5.0 we ship AOP 18.2.3, for APEX 5.1 we ship AOP 19.3.2)

This release contains the following enhancements:

Initial support for charts in sub-templates

PDF to Image will now generate sharper images

Word HTML module enhancements

This release contains the following bug fixes:

PDF internal bookmark when merging fixed

Angular expression bug while calling object methods fixed

AOP Server

Support added again for Oracle Linux 6 (separate download), with following limitations:

AME: only jimp as manipulator, not sharp

PDF2Image feature not available

Team AOP 04-MAY-2020

Version 20.1.3 of APEX Office Print (AOP) is now ready to be downloaded in the download section.
AOP 20.1.3 is compatible with APEX 18.x and higher. (for APEX 5.0 we ship AOP 18.2.3, for APEX 5.1 we ship AOP 19.3.2)

This release contains the following enhancements:

Support (re-)added for Angular Expressions

LOV support for IR/IG

Word HTML tag: individual border support

AOP PL/SQL API will retry to print when failed and use failover URL afterward

This release contains the following bug fixes:

Interactive Report/Grid: grouping meta-data issue handled properly

Interactive Grid: Column setting "Include in export" now taken into account

QRCode generation when URL

Team AOP 16-APR-2020

Version 20.1.2 of APEX Office Print (AOP) is now ready to be downloaded in the download section.
AOP 20.1.2 is compatible with APEX 18.x and higher. (for APEX 5.0 we ship AOP 18.2.3, for APEX 5.1 we ship AOP 19.3.2)

This release contains only bug fixes:

Fix row highlight on Interactive Grid

Fix group by aggregate

Fix issue with AME on Windows

AOP PL/SQL API will retry when Bad Gateway is received

The aop_log_pkg will now also save the JSON

Team AOP 08-APR-2020

Version 20.1.1 of APEX Office Print (AOP) is now ready to be downloaded in the download section.
AOP 20.1.1 is compatible with APEX 18.x and higher. (for APEX 5.0 we ship AOP 18.2.3, for APEX 5.1 we ship AOP 19.3.2)

This release contains only bug fixes:

Excel: fix an issue when big numbers were used

Excel: angular expressions issue fixed

When conditions were used for columns in an APEX IR/IG it's now taken into account correctly

Team AOP 02-APR-2020

Version 20.1 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 20.1 is compatible with APEX 18.x and higher. (for APEX 5.0 we ship AOP 18.2.3, for APEX 5.1 we ship AOP 19.3.2)

AOP integration in APEX 20.1

It's now even easier to use AOP in APEX 20.1. Simply specify APEX Office Print as your print server for your entire APEX Instance in Instance Settings. ORDS and APEX deprecated the native XSL-FO printing, but with APEX 20.1 you can use AOP as a replacement. APEX will use AOP to print native classic and interactive reports.

Note that In case you want to use AOP with your own template, or you want to use the more advanced features AOP provides (like highlights, groupings etc.), you still need to use the AOP Plug-in. In APEX 20.2 more AOP integration is planned.

APEX Media Extension (AME) as part of AOP Gold and Enterprise On-premises Licenses

Our newest product allows you to manipulate images in the Oracle database. With AOP Gold and Enterprise on-premises versions, AME is now included with no additional license or cost, so you can resize, rotate, flip and crop images. Furthermore, you can add one or more watermarks or overlays (images and text), compress and greyscale images, change image formats (jpg, png, ...), get image information (width, height, mime type, ...) and read media metadata (Exif, IPTC and XMP).

To find out more about APEX Media Extension, visit our website and check out an interview from apex.world creator, Juergen Schuster, with our CEO, Dimitri Gielis, here.

Generic Report Tags

Templates for Interactive Grids and Classic Reports just became even more simple! You can now use generic tags in your template instead of the region static ids. This mirrors our existing functionality for Interactive Reports and has been requested by many of you. We are happy to finally bring it to life. Usage: {&grid_1&} {&grid_2&}.. and {&classic_1&} {&classic_2}

Embedded File Attachments

Do you ever need to include an attachment inside a Word or PowerPoint file? Well, now you can! Embedded attachments allow you to open the attached PDF, Word, Excel and PowerPoint documents by double clicking on them in your output (Not all features available on MacOS).

New Data Source Type

When using the AOP PL/SQL API you can now pass an array of SQL statements. This way you don't have to use cursors or JSON syntax in your query. You pass a name, the query, and the bind variables and that is it!

Word enhancements

Ever wanted to include a PDF as an image in your Word document? Now you can!

Excel enhancements

- You can now include dynamic formulas with a new tag {>tag} in your Excel template. You submit A4+B5 in your data, but the tag will make it a real Excel formula.
- Improved Excel cell style support

Powerpoint enhancements

- Support for charts that need to be repeated

PDF enhancements

- When generating multiple files in one call, you can now have the output in a merged PDF instead of a zip file.
- Generated PDF mobile friendly

More cool new and enhanced features

- In addition to Classic Report, Faceted Search, Interactive Report and Interactive Grid, AOP now understands the Column Toggle Report and Reflow Report when you pass the static id. In your template, you can use the same tags as what you do for a Classic Report
- EMF image support
- Improved HTML expression recognition
- Interactive Grid enhancements (recognition of LOV and new chart types)
- Ability to specify page margin, orientation, width, height and format for HTML and Markdown to PDF output
- Additional barcode support and examples
- Markdown raw tag available {@raw}
- New samples in the APEX AOP Sample App for APEX 19.2 and above

We try very hard to make each and every new release of AOP backward compatible with the release that came before it. However, sometimes a new feature leaves us no choice. The following feature will break backward compatibility if it is currently in use:
- Markdown simple replace tag {tag} will now escape markdown characters, use {@raw} tag instead if the content does not need to be escaped. Escaped characters: \`*_{}[]()#+-.!<>&

Team AOP 22-JAN-2020

Version 19.3.2 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 19.3.2 is compatible with APEX 5.1, 18.x and 19.x. (for APEX 5.0 we ship AOP 18.2.3)

General bug fixes and performance improvement

Only the on-premises executable was updated with fixes for QR-codes and some Excel issues.

Team AOP 26-DEC-2019

Version 19.3.1 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 19.3.1 is compatible with APEX 5.1, 18.x and 19.x. (for APEX 5.0 we ship AOP 18.2.3)

Version 19.3 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 19.3 is compatible with APEX 5.1, 18.x and 19.x. (for APEX 5.0 we ship AOP 18.2.3)

APEX 19.2 Faceted Search

Love the new Faceted Search? So do we! Now you can reference a faceted search region as your data source. Filters are automatically applied.

APEX 19.2 Tighter Integration

Tighter integration of Interactive Grid and Classic Report. When you use Native Master-Detail, Websource modules, REST Webservices and post processing, all is taken into account by AOP.

Faster JSON Generation

Harness the power of native database JSON functionality by using it as your AOP data source.

Maps & Directions

Include directions from Google Maps, OpenStreetMap, or the provider of your choice by simply providing a Keyhole Markup Language (KML) URL to AOP.

PL/SQL API

Output a file to the browser without the need to write wpg_docload.download_file

PDF Enhancements

Overlay images in a PDF document. This is useful when you need to sign a document dynamically.

HTML Enhancements

- You can now export a Classic Report or Custom PL/SQL Region to HTML with the {@staticRegionId} tag
- Smart HTML tags: AOP identifies HTML tags in different positions and renders them intelligently.

Word, Excel and PowerPoint Enhancements

- Grouping of records
- Ability to add format mask for numbers and dates by using |sum |format
- Groups of PowerPoint slides can now be repeated by using {+link}
- Ability to set colors of chart series in native Office charts

AOP Server improvements

- More options for Processing commands (merge pre/post, ...) to give most flexibilty to adjust files before or after merge.
- Check the version of the PDF Converter through the URL by going to /soffice or /officetopdf

Overall

- General bug fixes and performance improvement

Team AOP 23-AUG-2019

Version 19.2.3 of APEX Office Print (AOP) is now ready to be downloaded in the download section.
AOP 19.2.3 is compatible with APEX 5.1, 18.x. and 19.x (for APEX 5.0 we ship AOP 18.2.3)

This release contains mostly bug fixes and a few improvements:

Fix issue when large data or template source was passed (PL/SQL API and APEX Plug-in)

Fix IE11 issue in Dynamic Action Plug-in

PDF: ability to add text to all pages and make use of {totalpage} and {currentpage} tag

PDF: ability to add images similar to texts using aop_pdf_images tag

Excel: highlight bug fix, break text will now have column formatting

Powerpoint: ability to add hyperlink into image in pptx excel and word: provide url with _url similar to _height and _width

HTML: HTML -> Word -> PDF bug fixed

HTML: new raw tag available on HTML using {@rawHTML} tag. should be valid HTML

HTML: curly braces in styles will not be replaced when it's valid CSS

Team AOP 23-JUL-2019

Version 19.2.2 of APEX Office Print (AOP) is now ready to be downloaded in the download section.
AOP 19.2.2 is compatible with APEX 5.1, 18.x. and 19.x (for APEX 5.0 we ship AOP 18.2.3)

This release contains mostly bug fixes and a few improvements:

Calendar export enhancements in Word

URL image fetch will retry on fail

Navigating to /version on API shows the AOP version

AOP Report when page size is set to millimeter bug fixed

Excel native format mask support added

Excel date with null bug fixed

Team AOP 11-JUL-2019

Version 19.2 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 19.2 is compatible with APEX 5.1, 18.x and 19.x. (for APEX 5.0 we ship AOP 18.2.3)

AOP Template enhancements

AOP already had the ability to create a starter template based on the available data. With AOP 19.2, the template also contains the interactive or classic report tag(s) when Classic Reports, Interactive Reports or Grids are included. The template was further optimized, so you can create your own, beautiful templates even faster out-of-the-box.

New template type: AOP Report

AOP 19.2 is able to create a document without a template! AOP has a built-in template which will be used when an "AOP Report" is requested. The AOP Report is intelligent and adapts based on the Print Attributes defined in Oracle APEX. By specifying different settings, you can customize the AOP Report exactly as you want.

New data types: JSON & XML

AOP 19.2 includes two new data types. Including JSON and XML has never been easier. If you have a REST web service or you want to generate your own JSON and XML, you can just pass it to the AOP PL/SQL API and APEX Plug-in.

New data source: REST Web Service & GraphQL

The AOP Server now understands a REST Web Service or GraphQL and can do the call for you. You pass the url and some meta-data that the service needs and AOP will do the rest.

Classic Report WYSIWYG

One of the most liked features of AOP is the ability to generate Interactive Reports and Grids exactly as you see on the screen. AOP 19.2 adds the same ability for Classic Reports. Print Attributes are taken into account to customize the look and feel of the Classic Report. In your template, you simply specify {&staticId&}.

New output locations: (S)FTP & Database Directory

You can now tell AOP to send the output to an (S)FTP location or a database directory.

Interactive Grid Master Detail Support

AOP now supports IG Master Detail (Detail...) natively, no need to specify bind variables in order to display the correct detail records. AOP automatically displays the detail records for the selected master row.

PDF enhancements

- If you want a document multiple times, you can now define the number of copies
- Ability to overlay text onto a PDF
- Ability to lock a form in a PDF (lock a fillable PDF)

Other enhancements

- AOP will automatically pick up translated headers and labels
- Percent Graph column support for Classic and Interactive Reports
- The tag {&staticId&} works now for Classic Reports as well as Interactive Grids. This makes it easier to create your templates in case you change from one report type to another.
- Improved JavaScript in the Dynamic Actions Plug-in
- More native chart support and manipulations
- New and enhanced samples in the AOP Sample App
- Image, Barcode and QR-code rotation possible
- New Getting Started section when logged in at apexofficeprint.com
- REF Cursors can now be used as data source by using the AOP PL/SQL API
- Added a function and procedure to check if the AOP Server/Cloud is available
- Database directories are natively supported as the source for your template
- Font APEX support
- Improvements on default width and height of an Excel cell and the ability to customize
- Excel number formatting and date format improvements

AOP Server (backend) enhancements

- Show machine id by using --mid
- Ability to use a proxy for activation

Overall

- General bug fixes and performance improvement

Team AOP 16-APR-2019

Version 19.1.5 of APEX Office Print (AOP) is now ready to be downloaded in the download section.
AOP 19.1.5 is compatible with APEX 5.1, 18.x. and 19.x (for APEX 5.0 we ship AOP 18.2.3)

This release contains mostly bug fixes and a few improvements:

AOP Template: AOP will now look at first 100 records to create the template

Word: Image replacing will now retry downloading image

Word: Fixed issue with the latest version of Office 365 Charts

Word: Font-APEX support

Excel: Fixed highlight issue when the $ tag was used

PDF: Form lock feature added for PDFs: set by g_output_lock_form

PDF: Page numbering: Use {AOPMergePage} instead of {AOPPage}: set by g_output_correct_page_nr(Note this is a change in behavior)

Version 19.1.4 of APEX Office Print (AOP) is now ready to be downloaded in the download section.
AOP 19.1.4 is compatible with APEX 5.1 and 18.x. (for APEX 5.0 we ship AOP 18.2.3)

This release contains mostly bug fixes and a few improvements:

AOP PL/SQL API deals with invalid APEX meta-data for IR

AOP APEX Plug-in can use AOP_MODE application item to determine the mode

General IR and IG improvements

One page PDF: DA action fixed

Text: Template defaults to utf8

Word: HTML Tag improvements: cite, a, var tags..

Word: ToC improvements

Word: ability to specify widths in em, px, pt, cm, in IR

Excel: Ability to hyperlink to other sheets

Excel: Support for xlsm

Server: LibreOffice user profile will now be taken into account

Server: Saving to a directory is improved

Team AOP 04-FEB-2019

Version 19.1.1 of APEX Office Print (AOP) is now ready to be downloaded in the download section.
AOP 19.1.1 is compatible with APEX 5.1 and 18.x. (for APEX 5.0 we ship AOP 18.2.3)

This release contains mostly bug fixes and smaller improvements:

Word: Axis titles now available in charts

Word: TOC link bug in PDF fixed

Word: possibility to add title in different axis in charts

Word: Bug when html img tag would produce to be repaired file fixed

Excel: loop conflict bug fixed

Excel dynamic sheets will now be inserted in tag order

Team AOP 11-JAN-2019

Version 19.1 of APEX Office Print (AOP) is now ready to be downloaded in the download section.
AOP 19.1 is compatible with APEX 5.1 and 18.x. (for APEX 5.0 we ship AOP 18.2.3)

Unlimited Free Development Credits in the AOP Cloud!

- Do unlimited number of requests in the new Development Mode of AOP

Template Enhancements:

- URL as Template; let either the DB or AOP retrieve the document.
The URL can be a custom file, Dropbox or Google Drive and Doc URL or other cloud options.
- Added Macro-Enabled Office Files: Word (docm) and Powerpoint (pptm) can now have macros included
- Added iCal format: ics and ifb format
- CSV template enhancements

Core Features:

- Font Awesome icons support when used in Interactive Report, Interactive Grid and HTML when exporting to Word or PDF.
Now you can show the same icons as you show in your APEX app in your report! Font APEX support coming soon.
- PDF Watermark: specify your own dynamic watermark when the output is PDF
- Better CLOB handling, so even the biggest text in an Interactive Report and Grid is treated well
- Column Groups support added for Interactive Grid
- Native SVG support in HTML
- Native Office Charts enhancements: empty data points are auto created, the ability to add labels and full axis info is available
- New Samples in the APEX AOP Sample App

AOP Server / Cloud:

- AOP HTTPS will now use TLS 1.2 by default
- Number of parallel conversions is equal to the number of cores by default
- Development Mode: Create as many reports in our cloud as you want, unlimited credits in Development mode!
- License AOP even easier: a license request file is now being generated in case there's no internet access to do the automatic licensing.
- Ability to execute your own commands after the merge processing of template and data. For example if you want to send an email from the command line or you want to execute a print job from the server directly.

Overall:

- General bug fixes and performance improvement

Team AOP 16-NOV-2018

Version 18.2.3 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 18.2.3 is compatible with APEX 5.x and 18.x.

This is only a patch release.

Improvements:

Possibility to make output even paged

Possibility to merge making every given document even paged

PDF merge forms support

Improved table of contents. Configuration possible for tab leader, depth of heading and title

IE fixes in the Dynamic Action

General bug fixes and performance improvement

Team AOP 15-OCT-2018

Version 18.2 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 18.2 is compatible with APEX 5.x and 18.x.

Wait, didn’t you just announce 18.1? Yes, we used the flow and wanted to finish items that couldn’t make it into 18.1. Just like APEX, AOP 18.2 is a minor release with smaller improvements and bug fixes.

- Now you can add pages before and after an existing PDF ( add time sheets to your invoice or put a fix cover sheet in front of your outputs )
- Split PDFs ( Print 100 invoices in one PDF and split them to separate invoices )
- Merge PDFs ( Consolidate all bank statements to 1 PDF )
- Endless PDFs ( Using AOP for your cash registers in any format )
- Create a PDF out of an image from every source without templates (PDF Converter)
- Create a PDF out of any document from every source without templates (PDF Converter)
- Secure PDF ( Protect your PDFs with passwords for opening and editing )

ability to specify your own font, size, color for the IR (layout settings) in Word

ability to add initialisation code to set for example global variables (fonts, ...)

format mask support for Dates in Excel

format mask support for Numbers in Word

All new Dynamic Action Plugin of AOP

AOP Template now also available in xlsx format

Updated Sample Application with new examples

General improvements and bug fixes

Team AOP 12-SEP-2016

Version 2.2 of APEX Office Print (both cloud and server) is now ready to be downloaded in the download section.
Following enhancements are done:

Excel improvements and bug fixes

Interactive Report to Excel

Multiple Interactive Report to Word and Excel

Combination of Classic and Interactive Report as data source

Interactive Report enhancements:

Ability to set filters and highlights section on top of the IR

Break enhancements

Group By support

Pivot support

Chart support

Area and Radar added to supported chart types

More template and data types

Code optimisation

Complete rewritten AOP and PL/SQL API

Improved documentation

Updated Sample Application with new examples

100+ automated tests

Team AOP 23-MAY-2016

Version 2.1 of APEX Office Print (both cloud and server) is now ready to be downloaded in the download section.
Following enhancements are done:

Performance improvements

Improved error handling

Rich Text Editor (HTML) to Word

Excel formulas improvements

Interactive Report aggregation on computed columns

Stacked column and bar added to supported chart types

Additional PL/SQL API

Documentation now available in HTML

Team AOP 23-MAR-2016

Version 2.0 of APEX Office Print (both cloud and server) is now ready to be downloaded in the download section.
This is a major release!

We support Interactive Report with highlights, filters, computations etc. to Word and PDF. The only thing you do in your Word template is to add {&interactive} and it will be replaced by what you see on the screen.

We have bar, column, line and pie chart support.

There's a remote debugging option which makes it easier for us to help you.

Furthermore there are some bug fixes and code improvements.

Team AOP 09-DEC-2015

Version 1.6 of APEX Office Print (both cloud and server) is now ready to be downloaded in the download section.
This release includes:

Under the hood improvements

More examples in the sample app: scheduled printing, print in batch, sending documents by email and more.

We fixed an issue running AOP as a service in Windows.

In your own data you can now use \n to add an empty line.

In Excel you can define multiple tags within the same cell.

Team AOP 09-NOV-2015

Version 1.5 of APEX Office Print (both cloud and server) is now ready to be downloaded in the download section.
This release includes:

Fixes some bugs and has improved error handling.

Contains the option to select a different tool to do the conversion to PDF. By default LibreOffice is still used, but you can now overwrite it with another converter.

The APEX plugin allows to use an Interactive or Classic report as source for your data. Filters will automatically be taken into account too.

There's an option to call a procedure before the file is downloaded, which makes it very easy to store the result in a table first.

More examples that showcase the power of AOP.

Team AOP 19-OCT-2015

Version 1.4 of APEX Office Print (both cloud and server) is now ready to be downloaded in the download section.
Following improvements were done:

The plugin is now compatible with Oracle XE.

The sample application includes more examples: there's a document with chart and an automated test section.

Introduction of the AOP PL/SQL API, which allows to produce a print straight from PL/SQL and for example save the result to a table or email the document to somebody.

Team AOP 03-OCT-2015

Version 1.3 of APEX Office Print (both cloud and server) is now ready to be downloaded in the download section.
This release contains bug fixes and the introduction of new features in the server part of AOP.
The APEX plugin works with APEX 5 and the Oracle database 11gR2 or higher.

Team AOP 03-SEP-2015

We updated the cloud version to v1.2 which includes stability improvements and bug fixes.

Team AOP 05-JUL-2015

Public beta is now open.

Team AOP 01-JUN-2015

We added this section to keep you informed about changes in APEX Office Print.