Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Future consideration
Workspace Jedox Platform
Created by Guest
Created on Aug 31, 2021

Extend report XLSX export to activate DynaRanges on all sheets

When exporting reports to Excel from the ribbon (or via a macro), only the DynaRanges on the first sheet of the report will be activated / calculated. When using Batch XLSX Snapshot, however, all DynaRanges on all sheets will be calculated.

Macro function activeworkbook->export() only calculates DynaRanges of the first sheet (like XLSX Snapshot when triggered by button/menu).

Most users are not aware of this limitation and expect a "complete" export of their report.
Using Batch XLSX Snapshot is not always an option, e.g. due to custom variables a customer can set whilst using the report or due to very restricted user environments where the complete application runs only in a standalone mode with no access to navigation bar.