Version 24.2 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.

Compatibility

APEX:

• AOP 24.2 is compatible with APEX 19.2 and higher (for APEX 18.1-19.1, we ship AOP 22.2.6).

On-premises: 

• The AOP Server is available for Windows and Linux (Red Hat / Oracle 8 and higher and Ubuntu 18.04 and higher).
• Java 8 or higher is now required to install the AOP Server.

Breaking change

• Make sure to update all the AOP Plug-ins in all applications when installing the latest AOP PL/SQL API (aop_db_pkg.sql).
  The screenshot mechanism was updated, which requires both the new APEX plug-in and PL/SQL API. Before, we were backward compatible with both. With this release, both have to be updated.

APEX Features (AOP DA)

• Improved screenshot mechanism: before, only 15 regions could be included, but with this release, this limitation is removed, and unlimited regions can be added
• The screenshot will also remove the shaded grey part that, depending on the APEX region, was added
• Improvements on charts: the ability to specify the width and height of the chart in custom attributes
• Improvements on charts: support for the decimal places for Decimal, Percentage and Currency Format Type
• Improvements on charts: combinational chart type support for stacked items
• Improvements on charts: ability to provide formatCode for x and y axis in chart options
• Interactive Report and Classic Report: HTML Expression and Computation bug fixed 
• Interactive Report and Grid: fix for count rows in pivot table

AOP Server

• Improvements on security: You can now enable the hsts header using—-enable_hsts or the enable_hsts key in aop_config.jsonc.
• New, faster parser for documents generated from an Excel template.  Up to a 30% performance gain!
• Bug Fix: Service systemd startup permission issue fix
• Bug Fix: Post Process Commands fix

Word

• Improvements on the HTML Module: better handling of rowspan of a table for HTML content tag

Excel

• Pivot table improvements

PDF 

• AOP can now make your PDF accessible and more easily readable by screenreaders! You only need to specify that you want your output to be PDF/UA compliant.
• Ability to specify custom text in digital PDF signatures
   

Version 24.1.1 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.

Compatibility

APEX:

• AOP 24.1.1 is compatible with APEX 19.2 and higher (for APEX 18.1-19.1, we ship AOP 22.2.6).

On-premises: 

• The AOP Server is available for Windows and Linux (Red Hat / Oracle 8 and higher and Ubuntu 18.04 and higher).
• Java 8 or higher is now required to install the AOP Server.

AOP Server

• Fix for Hyperlink
• Fix for HTML Expression

AOP Sample App

• Added some missing templates for charts in the APEX 23.2 app

 

Version 24.1 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.

Compatibility

APEX:

• AOP 24.1 is compatible with APEX 19.2 and higher (for APEX 18.1-19.1, we ship AOP 22.2.6).

On-premises: 

• The AOP Server is available for Windows and Linux (Red Hat / Oracle 8 and higher and Ubuntu 18.04 and higher).
• Java 8 or higher is now required to install the AOP Server.

Breaking change

• The chart type region will now be exported and interpreted as a native Office chart instead of a screenshot. 
  If a screenshot is desired wrap the chart region in a static content region with as template Blank with Attributes and provide the static id of this region.

AOP Server

• officeconverter temp files are removed instantly after the conversion is completed
• HTML to PDF falls back to backupTempDir if an error is thrown while writing a file on pdf_temp_folder
• Logs for server_uncaught_exception and server_error are now organized in a dedicated folder, with daily log files being generated
• Bug fix where HTML to PDF was not taking the backup temp folder into account when the main temp folder was full
• Ability to detect mime type of template if not provided
• Append and Prepend PDFs with passwords are now accepted, given the password is provided
• More robust temp file cleaner
• The images will be resized automatically for faster PDF conversion and minimal size

WebEditor

• Visualization of requests per day, hour, minute, or second in a chart
• Bug fix for unexpected WebEditor crash on JSON drop
• Ability to drag and drop HEIC and HEIF files in append and prepend files region
• Ability to edit configuration files through the WebEditor

Word

• Image will be resized by AOP for faster PDF conversion when the provided width and height are larger than the image's default width and height
• Bug on character escaping in Interactive Grid export fixed
• Bug fix for specific cases where bold tags were not being rendered correctly
• Bug fix for specific sub-templates where styling was not being copied to the original document

Excel

• Excel Pivot support
• Bug fix: Excel would ask to repair the file when tags were used in the column of an Excel table
• Bug fix: Excel would ask to repair the file when it contained different table parts

PowerPoint

• _preserve_tag_style option now available for hyperlink and auto-link tags

PDF 

• Support for new lines in PDF text insertion and watermark
• Rotation parameter available for PDF watermark

HTML

• Bug fix: If the image size is greater than the height width of the page, it resizes to the page's dimension
• Bug fix: In case of undefined headers in the template, the HTML content header tag will take the AOP default header font size  

Prepend/Append Files

• Images that have rotation in EXIF metadata will now be automatically rotated

AOP DA

• Native Chart Support - Provide the static ID of a chart region, and AOP will transform your chart into a native Office Chart automatically!
• Template Directive Support - If used in your HTML Expressions, AOP will recognize template directives and render them accordingly
• New Output Type: AOE Template Builder.  Automatically output your template to APEX Office Edit for further editing and customization using the built-in Template Builder introduced in AOE v23.2

PL/SQL API

• Improved error handling
• Added a PL/SQL-only solution that uses UTL_HTTP instead of APEX_WEB_SERVICE behind the scenes, so even when Oracle APEX is not installed, AOP will work with that package.

APEX Sample Applications

• Sample applications were updated and split into five separate applications to make it easier to import
• Getting started: Connecting to the AOP Server using the APEX Plug-ins and PL/SQL API.
• Integration with APEX Components: Showcasing AOP with native APEX Components, such as Classic Reports, Interactive Reports, Interactive Grids, and more (use the 232 version for the latest version of APEX, or 192 for any previous version of APEX).
• AOP Modal Plug-in: Download & Subscription Manager application showing how to use the AOP Modal plug-in, managing custom templates, and reporting scheduling.
• AOP Features: Look at all the fantastic things AOP can do.  Various Word, Excel, PowerPoint, HTML, Text examples, batch printing, PL/SQL API samples, and interfacing with external data sources.
• PDF Features: Examples of creating, editing, annotating, splitting, and merging PDFs. Plus, filling and reading forms, security, signature capability, and more!
   

 

Version 23.1.1 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.

Compatibility

APEX:

• AOP 23.1.1 is compatible with Database 12.1 and higher and APEX 19.2 and higher (for APEX 18.1-19.1, we ship AOP 22.2.6).

On-premises:

• The AOP Server is available for Windows and Linux (Red Hat / Oracle 8 and higher and Ubuntu 18.04 and higher).
• Java 8 or higher is now required to install the AOP Server.

AOP Server

• Minor Bug fixes
• Response time for getting printjob info increased to 15 secs from 10 secs.
• Better error handling for signature.
• AOP will now throw an error if the password for the signature is incorrect. Previously it would ignore and not insert the signature.
• Bug fix for width of columns in HTML table in Word
• Ability to add only row or column or both row and column in Word
• Freeze row only(`data-aop-freeze-row`), column only(`data-aop-freeze-column`) or both row and column (`data-aop-freeze`) using HTML expression.
• Ability to ignore check for QRCode Image repacement usinng `ignore_qrcode_replacement`

PL/SQL API

• Added ability to force creating an Oracle APEX session by specifying the global variable g_force_create_apex_session
• Fix name column identification for append and prepend files

 

Version 22.2.6 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 22.2.6 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 Server

• Fix backwards compatibility on convert plug-in

 

Version 22.2.5 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 22.2.5 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)

Word

• Sub-templates will now use the specified start and end delimiters
• Sub-templates issue with comments and images resolved
• Style bug fix in Word HTML rendering

Excel

• Fix for invalid xlsx output when pageBreak tag is used in development mode
• Horizontal looping will remove the cell when false (matches previous behaviour)

PL/SQL API

• Support for sub-templates in AOP_PLSQL_PKG

APEX Plug-in

• Support for Page items in Region Static Ids

AOP Server

• Check configuration available through /checkconfiguration
• Service files for AOP updated for Windows OS
• Updated dependencies / Security Updates

 

Version 22.2.4 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 22.2.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)

Excel

• Bug fix for sheet loops when Excel tables were used.
• Added support for Excel Units (eu) as width of cell in HTML expressions.
• Added support for link attributes in Interactive Report.

PowerPoint

• Bug fix for SVG image.

HTML

• HTML attribute rendering is possible, for instance, `<a href={link}>{link}</a>` would work.

AOP Server

• Added executed pre and post commands into logs.
• Support for static methods like `parseInt`, `parseFloat`, `isNaN`, `isFinite` and other methods for number manipulation.
• Bug fix while print logs were disabled
• Added ability to specify exact TLS ciphers.
• Ability to provide timeout for PDF operations as pdfbox_timeout in aop_config.jsonc.

AOP Webeditor

• Ability to select/drag and drop multiple files in prepend, append, sub-templates and file cache. 
• Ability to load debug-JSON directly from support portal using json_source in URL parameter.
• Fix on base64 decode.
• Units conversion for size (mb/kb) and time (seconds/milliseconds) has been added in Logging Section.

 

Version 22.2.3 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 22.2.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)

APEX Plug-in

• Added the ability to specify the PDF producer meta-tag of a PDF

AOP Server

• Added the ability to specify the PDF producer meta-tag of a PDF
• Bug fix on table of content
• Ability to hide current sheet

Version 22.2.2 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 22.2.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)

Word

• Ability to generate output with `doc` extension.
• Bug fix: When the sub-template was using custom numbering and the other numberings where not used, the style was getting mixed.
• Html Content ( `{_htmlContent}` ): bug fix for empty html table with no rows.
• Bug fix for table of content tag
  • preserving content before and after the tag is available.
  • consider combination of both dynamic and static heading of word while generating table of contents.

Excel

• Ability to generate output with `xls` extension.
• Added a new feature to hide sheets in excel using hide tag as (`{hide condition}`).
• Barcodes/Image insertion optimised.
• Cell level highlight have now priority over row level highlight in IR.

PowerPoint

• Ability to generate output with `ppt` extension.
• Added a new feature to hide slides in pptx using hide tag as (`{hide condition}`).

APEX Plug-in

• Added quick picks for output type.
• Ability to select doc, xls and ppt as output type.

AOP Server

• Optimisation on |break filter.

Version 22.2.1 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 22.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)

APEX Plug-in

• Fixed the screenshot mechanism 

Version 22.1.10 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 22.1.10 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)

Word

• Better HTML conversion to native styling
• HTML case insensitive <br> tag
• HTML new options for styling ordered list
• HTML table will now use the indentation from tag when _use_tag_style option is enabled

Excel

• New feature: ability to protect sheets with {protect tag}

APEX Plug-in

• Added support for the Cards Region
• Combination of global variables with IR/IG print settings possible

Backend

• When the points in charts have null or undefined value, the value will now be treated as missing value instead of 0
• Better SVG to PNG conversion
• IP white listing now works when the ipv4 is provided with ipv6 format (by adding ::ffff:)
• Logging page will show the error log for async post requests too
• Updated documentation

 

Version 22.1.9 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 22.1.9 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 Server

• Fix for content type detection

Version 22.1.8 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 22.1.8 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)
 

APEX Plug-in

• Improve performance of initial load of the AOP dynamic action plug-in (cache cursor fix)
• Added AOP Mode (Dev / Prod) to Modal plug-in
• Added extra check that start date can't be in the past when scheduling through the AOP Modal plug-in 

Word

• Hyperlink from sub-templates now working
• Ability to update table of contents (aop_api_pkg.g_update_toc := true;)

Excel

• Ability to specify option to repeat the header on Interactive Grid break
• Ability to define the font and background color of a break in IR/IG
• Fix highlight bug on date columns in Interactive Report

AOP Server

• Ability to specify libreoffice-marco as converter which will update the table of contents and converts to PDF
• Ability to specify CSV files in prepend and append type
• Fix for prepend and append of JPEG images
• Filetype detection for prepend and append files

 

Version 22.1.7 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 22.1.7 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 mainly fixes some issues in the AOP Server.

Word

• Bug fix for style tag when no font color was specified, the font color would default to red.

Excel

• IR ability to hide from the export (for example when you have checkboxes in the page and would like to hide this in export). Use data-aop-exclude-column="true" in HTML expression.
• IR column width bug fixed, this would resize all the columns if they were changed from default.
• Bug fix on HTML IR/IG export when HTML_EXPRESSION was used and no text was given for some html entities.
• Fixed that some template with non chronological relationship id was creating a corrupted file.

PDF

• AOP will fallback to preprovided font when the given characters in form value have no gylph in the specified font.

 

Version 22.1.6 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 22.1.6 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 mainly fixes some issues in the AOP Server.

Word

• Bug fix when an extra empty page would be added when there were multiple sections in the document.

APEX Dynamic Action Plug-in

• Added APEX Office Edit as output type and improved integration.

PL/SQL API

• Function added to get the icon of a mime-type.
• Improved error message and proposed solution already in error message.
• Updated documentation.

AOP Server

• Ability to specify typeof filter which will return the typeof the data (string, boolean, number).

Version 22.1.5 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 22.1.5 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 mainly fixes some issues in the AOP Server.

Word

• Sub-templates modules can now call other sub-templates (max number of sub-templates depth is 10).
• Breaking Visual Change: Word sub-templates used to leave extra paragraph before and after. This is now not the case. If you require extra paragraph please introduce this in the template.
• HTTPS compilation issue fixed.
• Bug fix for when loops where not inside the fist and last column.

Excel

• Ability to specify max lines in IR export.

 

Version 22.1.2 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 22.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 mainly fixes some issues in the AOP Server.

AOP Server Bug fixes:

• Fix on form filling, when specific forms were not getting rendered while opening.
• Fix of margin change on multiple sections when no header and footer was provided.

APEX DA Plug-in:

• Fix of no-data-found when multiple screenshots of regions were requested without specifying max-width and height.

PL/SQL:

• Fix for regression on ≥32K SQL support due to invalid debug statement.

Version 22.0.5 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 22.0.5 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 is a minor release and mainly fixes some issues in the AOP Server.
The PL/SQL API is still on version 21.2.2.

AOP Server enhancements

Performance boost for excel templates while exporting big set of records. (50k+ rows)

Compatibility with Cloud Office Print

Bug fixes:

• Excel styling bug when using {cell_marktup_style$} tag
• AOP image caching bug, qr code/barcode with same data would always return same type of qr code/barcode
• AOPChart will now handle array chart data (necessary while performing select statement in APEX)
• Bug on cloning repeating rows/columns while using sheet repeat tag.
• Ability to override HTML expression with - in Excel IR
• Ability to specify wrap text and width for a column in Excel IR

Version 22.0.1 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 22.0.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 is a minor release and mainly fixes some issues in the AOP Server.
The PL/SQL API is still on version 21.2.2.

AOP Server

• AOP hooks bug where a .json file was required fixed
• pageHeight and pageWidth can be specified in pdf text insertion
• ability to specify word wrap and width for IR columns in Excel
• Performance enhancement for Excel export

AOP Modal plug-in

• AOP Modal plug-in will send HTML email instead of text email

 

Version 21.2.2 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 21.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)

Word Template

• HTML content will handle transparent, inherit and initial as background, instead of blacking out the cells

HTML Template

• bug on spaces being replaced by nbsp fixed

AOP Server

• output_page_width and output_page_height will now be accepted on top of page_width and page_height option
• do not show again text in the WebEditor is now clickable

PL/SQL API

• output watermark bug fixed

 

Version 21.2.1 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 21.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)

Word

• {_html} tag now supports "start" attribute for ol.
• Section info bug while inside loop fixed.

Excel

• {_html} tag will now support input element with radio and checkbox type.
• html ol now supports "start" attribute.
• Bug fix on IR highlight when the column was > Z.
• Ability to specify simple tags in file properties like author/summary fields.
• Ability to just simple tags in sheet name itself.

CSV

• Encoding issue on non-ascii characters fixed.

AOP Server/ Global

• Walkthrough added for web editor.
• Web editor Drag and drop fix for firefox.
• Web editor will now properly decode non ascii characters.
• PDF forms will now retain the number formats.

PL/SQL API

• No changes

APEX Plug-in

• No changes in DA, Process and Convert plug-in
• Fixed issue in the AOP Modal Dialog plug-in with Classic Reports in APEX 21.2

APEX Sample App

• No changes

APEX Media Extension

• Uptake of AME 21.2 in AOP Gold

Version 21.2 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 21.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)

Word

• New link and target tag added to link from one place to another within the same document.
• IR average pivot will now be rounded to 3 numbers after decimal separator.
• Looping over floating items, such as, text boxes, is now supported.
• Bug fix on calendar report export: Invalid characters are now removed or escaped.
• Bug fix on aopchart module: An invalid document is no longer generated when nested loops are present.
• Bug fix for label merging: All labels should now be merged without being skipped.
• Bug fix on sections: Section info will now be retained when another section is removed due to a condition.

Excel

• IR average pivot will now be rounded to 3 numbers after the decimal separator.
• Cell size is adjusted on classic reports, interactive reports and interactive grids on insertion of images.
• New Tag: {freeze true} Ability to freeze x number of top rows and y number of left columns.
• Bug fix on interactive grid export - when using between filter on dates, the date range will be inclusive.

Native Charts Tag {$chart}

• Bug fix: Native office charts will now remove the border when border is set to false.
• Bug fix: {$chart} tag will now take the document theme into account. If no theme is present, random colors will be assigned.

AOP Server/ Global

• Ability to change start and end delimiters of tags to { } (default), {{ }}, << >>, < >.
• Ability to cache your template, AOP will return a hash to use next time as template_hash in the header.
• Ability to specify opacity, color, font and size for PDF watermark.
• Ability to test ipp printer using --ippurl , --ippversion and --ipp_test
• Ability to specify pfx file and password for pdf signing.
• Ability to check ipp printer through /ippcheck endpoint. e.g: http://localhost:8010/ippcheck?ipp_url=http://localhost:3000&version=1.1
• Ability to send EML files as prepended and appended files.
• Ability to prepend and append a file after each page of the output of a template. Useful for terms and conditions on duplex printing.
• Ability to remove the last page. This can be useful when using page break where last page might be empty.
• On-prem AOP server will no longer check for MAC address
• AOP Server will now regularly clean up files left by previous instances.
• Comments have been added to the AOP configuration file.
• Format mask support has been added for PT (similar to PR).
• Ability to provide a mathematical expression for summation, average, min or max inside a loop. For example:
  {orders|sum:"unit_price*quantity")
• More timing info will be logged (conversion, appending, prepending, inserting pdf images, and so on.)
• Count tags function now available for docx, pptx, xlsx, md, csv, text and html.
• Bug fix: During multi-level breaking, elements with one item are no longer ignored.
• Bug fix: Date formatting will now take the case of month into account.

PL/SQL API

• Ability to specify a watermark with opacity, width, height, and rotation.
• Ability to specify RTF as output.
• Ability to specify JSON as output.

APEX Plug-in

• Native support for APEX Maps
• The AOP Modal Dialog plug-in supporting objects are now available in a file without the need to install the supporting application

APEX Sample App

• Updated with new examples.

Breaking Change/ Change in default behavior

• Server will by default disable the status page. This can be enabled by either giving the --enablestatuspage argument or changing the configuration to enablestatuspage to true.

Version 21.1.2 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 21.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)

PL/SQL API

• added global variables for output_text_delimiter, output_field_separator, output_character_set
• fix so spaces in IG saved reports can also be taken
• ability to specify substitution strings in the format mask

APEX Process Plug-in

• fix ability to debug

AOP Modal

• ability to include the email form in a custom tile
• information is now added to the AOP_OUTPUTTO collection, which can be used in a custom procedure
• improved timezone support
• fixed default template issue

AOP Sample Apps

• fixed 11g and 12.1 database compatibility issue
• added EMAIL_FROM to the AOP CONFIG table
• PDF Tools has a new example how to print different regions and merge them together

Excel - CSV

• added parameters for output_text_delimiter, output_field_separator, output_character_set
• width and height calculator will now take new lines into account

AOP Server

• ability to specify an access token when fetching the logs
• ability to specify text delimiter, field separator, and character set encoding while converting from Excel to CSV
• fixed visibility of inserted chart data sheet, now all chart data sheets are hidden
• offset bug in barcode/image when same barcode/image was repeated
• fixed CSV escape bug
• AOP AME will now handle empty crop object
• fixed HTML bug while querying existing style

Documentation

• fixed some typos

Version 21.1.1 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 21.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

PL/SQL API

• removed 32K limit on SQL statements.
• added g_https_host for the hostname to be matched against the common name (CN) of the remote server's certificate for an HTTPS request
• fix IG sorting and column groups
• fix translated app
• added some extra debugging
• get_binds is now publicly available
• APEX 21.1 compatibility
• g_output_page_margin increased
• added append and prepend files as parameter
• fix compatibility DB 11.2

AOP Modal

• page items are saved which are submitted to the parameter table.
• fix email from

AOP Sample Apps

• removed dependency on APEX Database Sample App. AOP uses now its own table for the samples.
• added AOP_CONFIG table for the AOP URL and AOP API key, so it doesn't need to change in every app.
• fixed some typos.

Word

• {_html} Word Tag:

  • Ability to specify _use_tag_style so that the tag style is taken as default for the <p> tag used to be Normal style defined in Word.
  • The paragraph tag in the HTML content can now contain ata-aop-word-style attribute to specify the style by name.

• {cell_markup_tag$} Word:

  • You can now merge rows for a specific column if the next row has the same value for the given column.

{%image}

• Exif information provided in the image is taken into account while processing the image.
• Ability to specify remote debug on on-prem versions, if the API key is filled you can send the JSON to AOP Support.
• Ability to specify the max number of outgoing connections to a host for fetching resources like images.

AOP Server

• Ability to disable static ciphers when starting within HTTPS mode.
• Unicode character issue in PDF forms fixed.
• AME upgraded to 21.1 (HEIC input support/ rotation info taken from EXIF resource fetching for overlay optimized.);

Version 21.1 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 21.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

New APEX Plug-in: APEX Office Print (AOP) Modal

• The AOP Modal is the fastest way to present a dialog in which end-users can select the output they want.
• Fully integrated with Classic Report, Interactive Report, and Interactive Grid.
• End-users can select custom templates based on the report they are exporting.
• Output to many different locations (browser, table, filesystem, email, Oracle Cloud, custom)
• End-users have the ability to schedule reports.
• Reports can be run in the background.
• You can further integrate the AOP Modal with the Plug-ins Pro Progress Bar Plug-in for an enhanced user experience.

New AOP Download and Subscription Application

• This application supports the new AOP Modal Plug-in
• Upload custom templates for your reports that will be available to your users via the AOP Modal.
• Use the built-in Quick Template Changer to build and enhance your templates faster quickly and easily.
• Monitor the usage of the AOP Modal plug-in, its schedules, and background jobs.

APEX Plug-in

• You can now export multiple regions (IR/IG/Classic report) in a single AOP Report.

AOP Report

• You can now export multiple regions (IR/IG/Classic report) in a single AOP Report.
• Bugfix: Filter text will now display correctly when based on a LOV column.
• Support had been added for the 'sum' display text in classic reports.
• {&interactive} and {&interactive_1} tags are now both accepted.

QR Codes

• QR codes can now contain a logo in the center of the QR code, background images, and have more color options.
• You can now create QR Codes of the following types: WIFI, Telephone Number, E-mail, SMS, URL, vCard, MeCard, GeoLocation, and Events

{%image}

• You can now specify the opacity/transparency of an image using key_image_transparancy.

{$chart}

• Bugfix: Invalid characters will now be escaped in the title and name of a chart.

Mathematical Operations

• |sum, |max, |min, and |avg: You can now use these operations in multiple depths.

Word

• BREAKING/Enhancement: Mail merge/ Label merging will now remove empty lines.
• {_html} tag:
  • You can now specify the style of a (un)ordered list.
  • AOP will now try to determine the heading styles for h2 - h7 when no style is found in the template.
• Bug fixes:
  • AOP Trial watermark will no longer generate a corrupted Word document.
  • The table of contents will now display the appropriate level of headings.
  • Using {aopchart ...} after a loop will no longer create a corrupted Word document.
• {_mdtag_} will now merge the styles of the tag.

Excel

• AOP will now auto-detect date data and convert it to native Excel when the template cell contains date formatting.
• {_html} tag has been added for Excel. You will now be able to export HTML contents into Excel.
• HTML elements in IR/IG/CR export will now be rendered instead of being displayed as text.
• IR/IG/CR pivot/aggregates are now styled accordingly.
• You can now specify an offset from an image and barcode tag.
• Bugfix: Image tags will now work properly when using the sheet loop tag.
• You now have the ability to export larger amounts of data.

PL/SQL API

• BREAKING Change - By default, AOP will no longer perform a STOP APEX Engine after processing has completed.  This will affect any call to AOP in page processing, after submit, with an output type of 'Browser'  (using the AOP Process plug-in or in your own custom process).  These types of processes are not recommended on page submit and should be switched, instead, to run as a Before Header Process.  If necessary, the default can be changed by setting aop_api_pkg.g_stop_apex_engine := 'Y' in your process or changing the value in the aop_api21_pkg (g_stop_apex_engine  varchar2(1)   := c_y; ).
• Support has been added for the new APEX 21.1 pjson syntax
• We've enhanced our error messaging to provide a more descriptive error and fixes for known errors.
• You can now use the static id or region id of APEX reports as a region source.
• Your template source can now be a base64 clob.
• Files from Oracle Cloud (Object Storage) can now be used as a template source.
• Report Highlights and filters are now passed in the JSON to AOP and can now be referenced in the template.
• We've added the ability to ignore invalid media through a global variable.
• AOP will now grab all page items in the specified source regions automatically so that they can be referenced in the template without the need to use the g_apex_items global variable.
• You can now show a PDF inline and call a procedure.
• Improved support for translated applications.
• Fixes on Interactive Grid rendering.

Server

• The server will now log the requests on a per-day basis. The maximum number of days the log will save is now configurable.
• PDF conversion has been optimized. The server will identify duplicate pdf conversion requests and combine them into one.
• You now have the ability to disable idle LibreOffice converters.
• A network log has been added and all of the incoming HTTP requests are now logged. One log entry is created when a request is received, another when the received request ends.
• Curly quotes are now accepted in Word and PowerPoint tags.
• The AOP server will now add User-Agent in its outgoing request. (eg: apexofficeprint/20.1)
• You now have the ability to specify a max preconversion size for better resource management.

Version 20.3.1 of APEX Office Print (AOP) is now ready to be downloaded in the download section.
AOP 20.3.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 the following changes:

• HTTPS certificate issue fixed
• Interactive Grid alternative label support: set in aop_api_pkg the global variable g_ig_use_alternative_label to 'Y' to tell AOP to use the alternative label if defined for a column in the Interactive Grid

Version 20.3 of APEX Office Print (AOP) is now ready to be downloaded in the downloads section.
AOP 20.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

APEX 20.2

• Support for APEX 20.2
• Introduction of APEX Report, which will use the native functionality of APEX 20.2 to generate an Excel and PDF. Note that only 1 report at a time can be generated with this. Behind the scenes AOP uses the new APEX_DATA_EXPORT API. An alternative is to use AOP Report, AOP's own implementation, which also supports HTML expressions, which has existed for APEX 5.1 and above.

SDK for Python environment

• Use AOP easily from Python! Click the link for the SDK and the Docs.

New Sample Applications

• Added new samples to the AOP Sample App.
• The new Report Scheduler APEX app allows end users to schedule reports and receive them at specific times and intervals.
• The new PDF Tools sample app showcases all features revolving around the creating and manipulating PDFs in AOP.

Word

• {_htmltag} :
  • support added for more elements (blockquote, q, dfn)
  • thead and tfoot inside table are now taken into account
• {_mdcontent_}: Support for markdown content added similar to html tag, (starts and ends with underscore).
• New style tag for dynamic font change and styling: {style key}
• Support for ODT output added.
• Bug fixed in the subtemplate module: Bookmarks in the subtemplate will now be rendered.

Excel

• Template Generation: The reports will now be below the loop tags. This enables the generated template to be fed to AOP without modification.
• Relative Formula: The output document would need to be repaired when the relative formula was used inside a loop. Since AOP 20.3 this is not necessary anymore.
• Sheet name: The sheet names are now checked for validity. Max 31 characters and invalid characters are removed.
• Sheet loop: When the sheet loop tag was used, all sheets were selected. To modify, a single sheet needed to be selected first. Now only one sheet is selected.
• Excel files generated with Numbers: the styling for background, font color, border colors, etc. were getting ignored by LibreOffice. AOP now changes these styles to one that LibreOffice understands. This is necessary for PDF conversion.
• Support for ODS output added.
• Print Area if specified will now auto expand to include the last column and row.
• Performance enhancements for large Interactive Grid exports.
• Bug fixed for the sheet loop tags in sheets that have Excel tables in them.
• New tag {##static_condition} added. Similar to data loop but the content of the cursor has a fixed area to fill. The rows below the loop won't be pushed up or down when the condition fails or the size of the data does not fill the compelete area.

PowerPoint

• New style tag for dynamic font change and styling: {style key}
• Support for ODT output added.
• Template Generation enhancements

PDF

• New PDF engine to add signature
• Create fillable form fields with the new {?form_tag}. Create text boxes, radio buttons, radio lists, and checkboxes by providing the appropriate options for the type of item you wish to create.
• Identify the form fields of an existing PDF. AOP will output the PDF with the names it has used to identify the field written on the document.
• Advanced PDF features (PDF form creation, PDF form filling, reading & querying PDF forms, signing PDFs, and locking/flattening PDFs) are only available with On-premises Gold & Enterprise Licenses or any Cloud subscription.

CSV, MD, TXT

• Bug Fix: Large numbers were getting replaced as empty text.

AOP Template

• Template generation improved for Word, PowerPoint, and Excel files. The templates will now contain more explanation.

{aopchart} Tag

• You can provide a chart in the template and mark it with a preceding {aopchart chartData}. AOP will use the data passed in via chartData to populate the data in the chart.

{$chart} Chart Enhancements

• Additional styling options added: backgroundColor, roundedCorners, titleStyles, title rotation ... see documentation for all the new features.
• Line Chart:
  • Ability to specify colors for individual lines
  • Ability to specify line style
• Pie / Doughnut / Radar / Area Chart:
  • Ability to specify color per slice / series.

{%image_tag} Enhancements

• The width and height information can now be provided in px (default), in, cm, pt, and em.
• Optimization done for Word, PowerPoint and Excel when the same image is used in multiple places, resulting in a smaller file.

APEX Region Reference

• Use the P#StaticID syntax to reference regions (classic report, interactive report, interactive grid, etc.) from other pages. E.g. to reference a classic report with static id c1 on page 100, use P100#c1

Prepend and Append files

• Support added for pre 2007 formats (doc, ppt, and xls)
• Support added for OpenDocument formats (ods, odp and odt)

Interactive Report

• Ability to specify the report id, instead of alias, so private reports can be referenced too.

Interactive Grid

• Fixed display sequence
• Fix an issue in finding the correct report with translated apps

APEX Plug-in

• As template type and data type you can specify None at times when you just want to do PDF manipulation or convert files. This is an alternative to the convert APEX plug-in.
• Added output to procedure and inline combination.

Server

• 10x faster PDF conversions for smaller files.
• Restarting instances: Previously the instance would keep getting restarted if there was an error on startup. AOP will now check if the restart happens within a given time interval.
• --reactivate option added: This option will look for an existing license file and reactivate reading the email from this file.
• --activate option: Previously this would have been ignored even if the existing license file was invalid. Now this option is ignored only when there is a valid license file.
• AOP Trial watermark now appears on every page if running the on-prem version in trial mode.
• Endpoint added to query supported MIME types and supported output type for given MIME type.
• Server will now exit gracefully if it cannot detect the machine id.
• New output type added: meta_data, this will return the meta data info about the template. Currently supports Word/PowerPoint and Excel templates.

Web Editor

• Now gives an error message when the dropped JSON is invalid.
• Default MD sample was producing an error when handling a barcode. The barcode data has been fixed.
• The output file was not getting downloaded in iOS browsers and IE, now fixed.
• A Meta-data export button has been added. This provides simple meta-data info for Word, PowerPoint and Excel.

Breaking changes

• When exporting numbers with an accuracy of > 15 characters, previous versions of AOP would guarantee the accuracy until 15 characters. However, you could perform mathematical operations on them (like {n1 + n2}). From AOP 20.3 onwards these numbers will retain their full accuracy and will be treated as strings. Performing addition on these numbers will concatenate the numbers together. The workaround is to explicitly cast to a number by subtracting 0 from it or rounding the number before passing it to AOP.

Version 20.2.1 of APEX Office Print (AOP) is now ready to be downloaded in the download section.
AOP 20.2.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 mostly bug fixes:

• Word/Excel: Group By (IR) bug fixed:
  when the first row was missing data for a column, the column was not being shown
• Word/Excel: Filter & Highlight bug fixed:
  floating point number allowed now and highlight and column styling will be merged
• Powerpoint: Fixed slides looping on group filter
• PDF Signature: AOP will automatically add a signature field 

 

APEX Office Print (AOP) version 20.2 is now ready to be downloaded in the downloads section. AOP 20.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) PDF Form Filling Do you currently spend too much time filling in forms in PDF documents?  Now, AOP can do that for you!  Simply provide your existing PDF form to AOP along with your data and we'll handle the rest.  No more tedious, repetitive typing!  As an added bonus, when you pass a PDF from to AOP, it can even tell you what fillable fields exist within the document.  PDF Signing Initial support for PDF signature. It is now possible to sign a PDF that contains a signature field. Signatures are cryptographically bound and secure. Column Breaks No need to organize your data by a specific column through your query, AOP can do that for you! You can now create column breaks in your output by simply setting up the desired format in your template using the break filter, for example, {#products|break:“CATEGORY”} Additional features & enhancements: Ability to enter region id instead of static id of report (makes AOP work with the Data Reporter Packaged App) Support for alt text for images Charts can now be used in sub-templates Word HTML tag now supports different types of lists (a., A., I., and so on) Native Office Charts will now handle null values as null instead of 0 Word: {background$} tag will also take the width of a cell into account, which allows you to create complete dynamic tables Loop filter: you can now repeat the contents between loop tags for x times e.g. write x: tag, 5 times: {#5|loop} x: {tag} {/5|loop} This release contains the following bug fixes: Doughnut chart, area chart, and pie chart save issue fixed Excel issue: duplicates of an angular expression were not getting removed Word HTML tag: style was being ignored Report export is now compatible with numbers > 15 characters Barcode in PDF are now shown sharper when the height are small Note: reactivation of license is necessary for all licenses older than AOP 20.1

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

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 

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

 

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

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

AOP Server

- AOP Server will now write information to the logs whenever the AOP server is stopped
- --deactivate option added to create a deactivation request file
- Redhat 6 is no longer supported (latest AOP release that runs on Redhat 6 is AOP 19.3.2)

Overall
- General bug fixes and performance improvements

Non-backwards Compatibility Issue

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: \`*_{}[]()#+-.!<>&

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.

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)

General bug fixes and performance improvement

- Word: Hyperlink will open in new window
- Word: Invalid character in calendar fixed
- Excel: Merge cells issue fixed
- Excel: Angular expression bug when starting and closing tags were in the same cell
- Excel: Ability to specify how many rows and columns you want to span
- Markdown/HTML: Support for ledger, letter and legal
- Markdown/HTML: Possibility to specify page format, width and height when going to PDF
- PL/SQL API: Global variables take priority over print attributes
- PL/SQL API: Page Id is now set automatically when creating a session in APEX 18.1 
- PL/SQL API: Inline HTML support
- APEX DA Plug-in: SQL with JSON syntax bug fixed
- APEX Convert Plugin: fix bug with data source and debug mode
- Pre- and Post-conversion command bug fixed
 

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.