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

    

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

    

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

    

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

    

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)
• Text: templating will now go with UTF-8 instead of ASCII, inline text replacing encoding issue fixed
• AOP Server: Get request /marco will now respond with "polo" 
• Other minor bug fixes

    

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

    

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

    

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

    

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

    

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. 

But first let us introduce our new, much faster Cloud-Server: https://api.apexofficeprint.com or http://api.apexofficeprint.com  where you can now choose to convert your PDFs with LibreOffice or MS Office.

Improvements:

• Better CSV Support (csv -> csv, csv -> xlsx, csv -> pdf, xlsx -> csv) 
• Improved export for Interactive Grid and Interactive Report to Excel
• Better support for translated applications
• Now you can specify the exported width of columns in an Interactive Report. It’s simple like that: <span data-aop-width-weight="50">Your Column Heading</span>
• Ability to see the function that is being done by the AOP APEX Plug-in
• Improved Logging
• Brand new AOP Sample App with APEX 18

If you have our AOP-Server on premises - here is what we've got for you:

• Much easier activation of your license, just enter your email
• Create a configuration file to be sure that all AOP versions are installed with the same parameters in all your environments
• Performance Improvements
• Now you can use a "memory folder" to speed up your PDF conversions

Let us know what you think, we like to hear from you :-)

    

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

This release fixes some issues with :

• SVG screenshot at on-premises
• Pivot in Interactive Report
• Updated AOP Sample Application

    

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

Free AOP Cloud Tier! 

- 30 reports a month up to 100 (with affiliation). No strings attached, legit for business use! Available September 20th.

APEX 18.1 Features: 

- Getting the Data from REST Remote Databases
- Getting the Data from APEX 18.1. Web Sources ( REST Web Service )
- Improvements for Interactive Grid and Interactive Reports
- Print now all Calendar Views ( Daily, Weekly, Monthly, Yearly )
- Lossless screenshots of SVG charts and images

PDF Enhancements: 

- 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 )

Word Template Enhancements:

- Generate a Table of Contents
- Generate dynamic page numbers
- Word Table improvements and Pivoting 
- Translate HTML Tags in real Word formatting ( Use HTML in your Word Template )
- ...

Excel Template Enhancements:

- Pivoting
- Dynamic Cell Styles ( Decide the cell style not in the Template but on the fly )
- …

Markdown Template Enhancements:

- Supporting 95% of all tags
- HMTL Integration ( Use HTML code in your Markdown Document )

Other Key Features:

- Brand new AOP Sample App ( just copy all possible use cases from our Sample App into your Application )
- Native D3 support ( https://github.com/d3/d3/wiki/Gallery )
- Word Sub Templates ( Modularize and reuse your Templates )
- Replace an image in your Template ( Live QR-Code replacements )
- Save your AOP Output directly to any Cloud Provider ( Dropbox, Amazon S3, One Drive, Google Drive )
- New Web Editor to create Templates, Debugging and JSON tests

New pricing structure:

- Simplified and reduced pricing model
- Pay only what you really use ( Pay as you Go )
- New Enterprise Licenses ( also available on Cloud )

    

Version 3.5 of APEX Office Print is now ready to be downloaded in the download section.
Following enhancements are done:

• AOP Template available in Text
• A new template engine is added: Text (.txt)
• HTML expression improvements
• Support for more label printers
• New examples in the AOP Sample App
• More IPP Printer support
• Sharper screenshots (new version of HTML2Canvas)
• Possibility to add your own logging function, so you can monitor AOP from the database
• HTTP/2 support
• New parameter to support IP whitelist on the AOP server; setting this will only allow requests from certain IPs
• Ability to run AOP in HTTP and HTTPS together (using --https_port)
• Bug fixing and general improvements
• Documentation now available in Spanish (next to English)

    

Version 3.4 of APEX Office Print is now ready to be downloaded in the download section.
Following enhancements are done:

• AOP Template available in HTML and Markdown, next to Word and Excel
• Performance optimization, especially when using links and images
• Use HTML to create Word (docx) template (page 114 in our AOP sample app)
• New examples in the AOP Sample App
• PDF and Postscript file are now sent to IPP printer. Dependency: XpdfReader
• Bug fixing and general improvements

    

Version 3.3 of APEX Office Print is now ready to be downloaded in the download section.
Following enhancements are done:

• Generation of Excel sheets by using {!tag}
• Fix for calling a saved Interactive Grid
• Ability to specify a failover AOP url (when AOP is down, it will try to use the failover url)
• Ability to specify a custom failover procedure when AOP is using the failover url
• Conditionally hide a column in an Interactive Report by specifying a condition Request != Value (AOP)
• Feature added for saving files on the server
• Support for additional native Office charts: Scatter, Bubble, Stock, 3D Pie, Combined charts (line with bar etc.)
• Charts support multiple axes
• Right-to-Left language improvements
• Improved error handling; returns exact error on tag or document with errors
• Support for custom labels
• Ability to add footnotes with {+tag}
• Hyperlink support by tag {*link}
• Word HTML tag now supports table border style color and size
• HTML to Word improvements and HTML parsing
• AOP Trial will be prepended on trial word documents (watermark was not always shown)
• IP printer options added to return PDF output
• High performance PDF generation for Enterprise Edition
• Bug fixing and general improvements

    

Version 3.2 of APEX Office Print is now ready to be downloaded in the download section.
Following enhancements are done:

• Excel improvements: conditions added
• HTML improvements: border styling (border size, color, type), paragraph (break)
• Right-to-Left language support e.g. Arabic
• Bug fixing and general improvements

    

Version 3.1.1 of APEX Office Print is now ready to be downloaded in the download section.
This release is mainly to fix a couple of bugs that were introduced in AOP 3.1.

    

Version 3.1 of APEX Office Print is now ready to be downloaded in the download section.
Following enhancements are done:

• IP Printer support
• HTML to Word enhancements
• Native barcode support instead of relying on external program (ImageMagick/GraphicsMagick)
• Queuing system for PDF generation
• Performance enhancements
• Improved Interactive Grid support
• Ability to add sum, avg, min and max in the template instead of data
• Improved server logging. Changed default logging to set log by adding --enable_printlog
• Ability to set time-out for PDF generation (--idle_timeout)
• Docker support; Docker image available for Gold and Enterprise license
• Improved APEX plugin and PL/SQL API
• Improved debugging possibilities on every level
• Ability to specify the content new line as paragraphs ({#TEXT |paragraph}{.} {/TEXT |paragraph})
• Ability to run AOP in HTTPS (--https_key, --https_cert)
• Possibility to add your own debugging procedure in the APEX plugin and PL/SQL API
• Improved mime type recognition. AOP understands now application/octet-stream
• Documentation update
• AOP Sample App update (APEX 5.0 & APEX 5.1)
• Bug fixing and general improvements

    

Version 3.0 of APEX Office Print (on-premise) is now ready to be downloaded in the download section.
Release notes are the same as for the AOP 3.0 cloud release notes a week ago (see below).

    

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

• New Web Editor which allows to quickly test and use AOP 
  (drag-drop template, data or write your template or data in the editors)
• 2 new template types (next to Word, Excel and Powerpoint): HTML and Markdown
  • HTML as template => output to HTML (PDF, Docx coming later)
  • Markdown as template => output to Markdown (HTML, PDF, Docx coming later)
• Interactive Grid support in Word and Excel (highlights, filters, aggregates…)
• Improved AOP Dynamic Action
  • Show spinner while downloading
  • JET chart, HighChart and others (ability to screenshot a div by defining the id)
  • Custom events (progress, start, finish)
• Output to Inline Region: inline PDF, HTML, Markdown
• Logging ability (--logging): JSON file which stores the logging, accessible through AOP front-end
• Tag count on Word and HTML
• Image tag support from URL
• HTML to Word improvements
• Ability to set background of table cell in Word
• Support for tags in Header and Footer in Word and Excel (new context)
• Excel improvements
  • Styling of cells (background, font, border etc.)
  • Header and footer parsing
  • Significant performance improvement
• Run AOP executable in Cluster mode (—-instance)
• Table merged column support in Powerpoint
• Documentation update
• AOP Sample App updated (APEX 5.0) & New (!) for APEX 5.1
• Bug fixing and general improvements

    

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

• Support for Interactive Grid (basic functionality)
• More date and timestamp formats supported in Word and Excel
• Support for currency format FML999G999G999G999G990PR e.g. $9,999,999
• Ability to specify an image max_width and max_height next to width and height
• New layout of generated AOP Template in Excel
• Performance increase for parsing Excel templates
• Unicode (Japanese etc.) characters support in AOP Cloud
• Improved error messages
• APEX 5.0 and 5.1 packages and examples
• Updated Sample Application with new examples
• Improved apexofficeprint.com site when logging in: better overview, ability to order AOP online and view your invoices.
• General improvements and bug fixes

    

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

• Support for Tabular Form
• Ability to use HTML in your columns
• Date format support in Word
• Number format support in Excel
• Table and special characters support in Rich Text Editor
• Enterprise license support
• Improved error messages
• Updated Sample Application with new examples
• Ability to overwrite the proxy and time-out by request
• Option to do Local debug (downloads JSON that is sent)
• General improvements and bug fixes
• AOP Cloud is running in a cluster

    

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

• ability to specify reports on the global page(s)
• ability to call a specific saved interactive report (ir1|my_saved_report)
• ability to specify you want the headers in Excel as filters
• ability to debug the AOP_API2_PKG calls from PL/SQL
• 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

    

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

    

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

    

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.

    

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.

    

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.

    

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.

    

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.    

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

Public beta is now open.    

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

Private beta is now open.