New in this release:

• Updated links to the new documentation.
• Added links to the app survey.

Fixed in this release:

• Resolved the issue with the Table Excerpt macro export to PDF.
• Improved display of cogwheel icons in Confluence 7.

New in this release:

• Updated links to the new documentation.
• Added links to the app survey.

Fixed in this release:

• Resolved the issue with the Table Excerpt macro export to PDF.
• Improved display of cogwheel icons in Confluence 7.

New in this release:

• Added FORMATTIME SQL function to the Table Transformer macro.

Fixed in this release:

• Resolved the issue with displaying Radar chart legend at the bottom of the chart.

New in this release:

• Added FORMATTIME SQL function to the Table Transformer macro.

Fixed in this release:

• Resolved the issue with displaying Radar chart legend at the bottom of the chart.

Fixed in this release:

• Resolved the issue with multiplication of values in the total row and total column.
• Resolved the issue with using the app with the Scroll Word Exporter app version 4.x and the Excerpt Include macro.
• Resolved the issue with formatting of calculated dates to "hh:mm:ss" format in the Table Transformer macro.

Fixed in this release:

• Resolved the issue with multiplication of values in the total row and total column.
• Resolved the issue with using the app with the Scroll Word Exporter app version 4.x and the Excerpt Include macro.
• Resolved the issue with formatting of calculated dates to "hh:mm:ss" format in the Table Transformer macro.

New in this release:

• Added a new chart type to the Chart From Table macro - Radar chart.
• Added compatibility with the Scroll Viewport app.
• Improved displaying of a table merged with the help of the Table Transformer macro.
• Added support for dates outputted with the help of the Page Info for ScriptRunner app.
• Added compatibility with icons and images when using the Totals for columns: Count not empty option type.
• Added responsiveness of table columns when hiding columns with the help of the Table Filter macro.
• Added the ability to set the date and time format when calculating periods of time with the help of the Table Transformer macro.
• Added preserving of the default values formatting when calculating Total row/column.
• Added the ability to display values with postfix and prefix in the Pivot Table and Chart from Table macros.
• Added preserving of the default formatting when using the Literal operation type and the Cell value delimiter option in the Pivot Table macro.

Read more

New in this release:

• Added a new chart type to the Chart From Table macro - Radar chart.
• Added compatibility with the Scroll Viewport app.
• Improved displaying of a table merged with the help of the Table Transformer macro.
• Added support for dates outputted with the help of the Page Info for ScriptRunner app.
• Added compatibility with icons and images when using the Totals for columns: Count not empty option type.
• Added responsiveness of table columns when hiding columns with the help of the Table Filter macro.
• Added the ability to set the date and time format when calculating periods of time with the help of the Table Transformer macro.
• Added preserving of the default values formatting when calculating Total row/column.
• Added the ability to display values with postfix and prefix in the Pivot Table and Chart from Table macros.
• Added preserving of the default formatting when using the Literal operation type and the Cell value delimiter option in the Pivot Table macro.

Read more

New in this release:

• Added support for tables with multiple header rows with horizontally merged cells only.
• Improved the Table Transformer macro dialog view.

Fixed in this release:

• Resolved the issue with not working Chart from Table macro nesting Table Filter macro with a table with multiple headers.

New in this release:

• Added support for tables with multiple header rows with horizontally merged cells only.
• Improved the Table Transformer macro dialog view.

Fixed in this release:

• Resolved the issue with not working Chart from Table macro nesting Table Filter macro with a table with multiple headers.

Fixed in this release:

• Resolved the issue with not working Chart from Table macro nesting Table Filter macro with a table with multiple headers.
• Resolved the performance issue Jira Filter gadget in Confluence 7.0.
• Resolved the issue with PDF export and Adobe Reader.

Fixed in this release:

• Resolved the issue with not working Chart from Table macro nesting Table Filter macro with a table with multiple headers.
• Resolved the performance issue Jira Filter gadget in Confluence 7.0.
• Resolved the issue with PDF export and Adobe Reader.

Fixed in this release:

• Resolved the issue with charts within hidden content.
• Resolved the issue with copying tables with merged cells.
• Resolved the issue with "Transpose tables" option in the Table Transformer macro.

Fixed in this release:

• Resolved the issue with charts within hidden content.
• Resolved the issue with copying tables with merged cells.
• Resolved the issue with "Transpose tables" option in the Table Transformer macro.

New in this release:

• Gantt chart bars have the same color by default.
• Added a capability to switch between single and multi-color bars in the Gantt chart.
• Event labels are centered in the Gantt chart.

Fixed in this release:

• Resolved the issue with empty values in renamed columns in the Table Transformer macro.

New in this release:

• Gantt chart bars have the same color by default.
• Added a capability to switch between single and multi-color bars in the Gantt chart.
• Event labels are centered in the Gantt chart.

Fixed in this release:

• Resolved the issue with empty values in renamed columns in the Table Transformer macro.

New in this release:

• Added a capability to transpose tables in the Table Transformer macro.

Fixed in this release:

• Resolved the issue with SQL empty string variables in the Table Transformer macro.
• Resolved the issue with merged cells in header rows.
• Resolved the issue with setting width of columns of a table with merged cells in header rows wrapped with the Table Filter macro.

New in this release:

• Added a capability to transpose tables in the Table Transformer macro.

Fixed in this release:

• Resolved the issue with SQL empty string variables in the Table Transformer macro.
• Resolved the issue with merged cells in header rows.
• Resolved the issue with setting width of columns of a table with merged cells in header rows wrapped with the Table Filter macro.

New in this release:

• Added Jira Issues macro date format.

Fixed in this release:

• Resolved the issue with applying Total Column feature to a table with multiple header rows.
• Resolved the issue with editing and filtering tables with merged cells in page edit mode.
• Resolved the issue with nested Table Filter macros and table with merged cells in page edit mode.
• Resolved the issue with highlighting Bubble Pie chart slices in Confluence 7.0.

New in this release:

• Added Jira Issues macro date format.

Fixed in this release:

• Resolved the issue with applying Total Column feature to a table with multiple header rows.
• Resolved the issue with editing and filtering tables with merged cells in page edit mode.
• Resolved the issue with nested Table Filter macros and table with merged cells in page edit mode.
• Resolved the issue with highlighting Bubble Pie chart slices in Confluence 7.0.

New in this release:

• Added support for multi-row table header.

Fixed in this release:

• Resolved the issue with cursor positioning within an empty cell of a table with frozen rows in Firefox.
• Resolved the issue with duplicated values in total column when copying the Table Filter macro.
• Resolved the issue with "Table height" parameter display in the Table Filter macro dialog.

New in this release:

• Added support for multi-row table header.

Fixed in this release:

• Resolved the issue with cursor positioning within an empty cell of a table with frozen rows in Firefox.
• Resolved the issue with duplicated values in total column when copying the Table Filter macro.
• Resolved the issue with "Table height" parameter display in the Table Filter macro dialog.

New in this release:

• Bubble Pie chart shows full range of axis even when there are no relevant values.
• Pivot Table macro formats "today" variable from the source table as a date when aggregating against day period.

Fixed in this release:

• Resolved the issue with blank event labels when building a Gantt chart on the basis of a single table.
• Resolved the issue with changing colors in the Gantt chart when filtering source tables.
• Resolved the issue with impossibility to update some old Chart from Table and Table Excerpt Include macros.
• Resolved the issue with not showing Table Excerpt Include macro preview wrapped with Table Excerpt macro with the same name.
• Resolved the issue with date picker in macro editor in Confluence 7.0.

New in this release:

• Bubble Pie chart shows full range of axis even when there are no relevant values.
• Pivot Table macro formats "today" variable from the source table as a date when aggregating against day period.

Fixed in this release:

• Resolved the issue with blank event labels when building a Gantt chart on the basis of a single table.
• Resolved the issue with changing colors in the Gantt chart when filtering source tables.
• Resolved the issue with impossibility to update some old Chart from Table and Table Excerpt Include macros.
• Resolved the issue with not showing Table Excerpt Include macro preview wrapped with Table Excerpt macro with the same name.
• Resolved the issue with date picker in macro editor in Confluence 7.0.

New in this release:

• Added compatibility with Confluence 7.0.

Fixed in this release:

• Resolved the issue with blank values in the resulting table of Table Transformer macro.
• Resolved the issue with values of a column with mixed content type (numerical, text) in the resulting table of Table Transformer macro.
• Resolved the issue with not working Table Transformer macro preview in Firefox browser.
• Resolved the issue with showing zero values as pies and slices in the Bubble Pie chart.

New in this release:

• Added compatibility with Confluence 7.0.

Fixed in this release:

• Resolved the issue with blank values in the resulting table of Table Transformer macro.
• Resolved the issue with values of a column with mixed content type (numerical, text) in the resulting table of Table Transformer macro.
• Resolved the issue with not working Table Transformer macro preview in Firefox browser.
• Resolved the issue with showing zero values as pies and slices in the Bubble Pie chart.

New in this release:

• Added a new chart type to the Chart From Table macro - Bubble Pie chart. The chart combines bubble and pie chart types and allows you to compare your data ranges relative to each other in different size bubbles and at the same time visualize date ranges within themselves in pie slices.
• Added an option to filter table rows when selecting one or several of chart sectors or columns.
• Added SQL syntax highlighting and autocomplete to the Table Transformer macro.

• Added support for week numbers (w or ww) in a range of available date formats.
• Added an option to specify the height of a table when freezing first N rows.
• Added right alignment of data in total columns/rows.
• Added an option to hide the source table after adding the Pivot Table macro in the page view mode.
• Improved compatibility with Content Formatting Macros for Confluence app.
• Resolved the issue with copying a table with merged cells from Table Filter macro.

Read more

New in this release:

• Added a new chart type to the Chart From Table macro - Bubble Pie chart. The chart combines bubble and pie chart types and allows you to compare your data ranges relative to each other in different size bubbles and at the same time visualize date ranges within themselves in pie slices.
• Added an option to filter table rows when selecting one or several of chart sectors or columns.
• Added SQL syntax highlighting and autocomplete to the Table Transformer macro.

• Added support for week numbers (w or ww) in a range of available date formats.
• Added an option to specify the height of a table when freezing first N rows.
• Added right alignment of data in total columns/rows.
• Added an option to hide the source table after adding the Pivot Table macro in the page view mode.
• Improved compatibility with Content Formatting Macros for Confluence app.
• Resolved the issue with copying a table with merged cells from Table Filter macro.

Read more

New in this release:

• Total values are aligned to the right in the Table Filter macro.

Fixed in this release:

• Resolved the issue with not working "Hide filtration pane" option when "Hide control buttons" option is set in the Table Filter macro.
• Resolved the issue with not showing today's events in the Gantt chart.
• Resolved issues with nested Table Filter macros when calculating total row and column.

New in this release:

• Total values are aligned to the right in the Table Filter macro.

Fixed in this release:

• Resolved the issue with not working "Hide filtration pane" option when "Hide control buttons" option is set in the Table Filter macro.
• Resolved the issue with not showing today's events in the Gantt chart.
• Resolved issues with nested Table Filter macros when calculating total row and column.

New in this release:

• Added a capability to include the same macros multiple times into a page.
• Added a compatibility with Task Manager for Confluence app.

Fixed in this release:

• Resolved the issue with table export to PDF with merged cells.
• Resolved the issue with skipping the Table Filter total row when building a chart on the basis of a horizontal table layout.
• Resolved the issue with duplicated total column label when the first row is frozen and the total row is outputted in the Table Filter macro.
• Resolved the issue with Scroll PDF export of a table in an unfiltered state.

New in this release:

• Added a capability to include the same macros multiple times into a page.
• Added a compatibility with Task Manager for Confluence app.

Fixed in this release:

• Resolved the issue with table export to PDF with merged cells.
• Resolved the issue with skipping the Table Filter total row when building a chart on the basis of a horizontal table layout.
• Resolved the issue with duplicated total column label when the first row is frozen and the total row is outputted in the Table Filter macro.
• Resolved the issue with Scroll PDF export of a table in an unfiltered state.

Fixed in this release:

• Resolved the issue with filtration of the multidimensional Pivot Table macro.

Fixed in this release:

• Resolved the issue with filtration of the multidimensional Pivot Table macro.

New in this release:

• Added a capability to output the Table Filter macro total column to the Pivot Table macro.

Fixed in this release:

• Resolved the issue with not showing export to PDF and CSV buttons if the export to Word is not enabled in the Table Transformer macro.
• Resolved the minor issue with the Table Filter macro UI when hovering over the "=" and "≠" signs.
• Resolved the issue with the colors setting in the Chart from Table macro settings.
• Resolved the issue with inline macro insertion when using multiple Advanced Tables - JSON Table that output tables with nested tables.

New in this release:

• Added a capability to output the Table Filter macro total column to the Pivot Table macro.

Fixed in this release:

• Resolved the issue with not showing export to PDF and CSV buttons if the export to Word is not enabled in the Table Transformer macro.
• Resolved the minor issue with the Table Filter macro UI when hovering over the "=" and "≠" signs.
• Resolved the issue with the colors setting in the Chart from Table macro settings.
• Resolved the issue with inline macro insertion when using multiple Advanced Tables - JSON Table that output tables with nested tables.

Fixed in this release:

• Resolved the issue with PDF export when table cells contain tables with merged cells.
• Resolved the issue with the Table Transformer macro when using special characters in column labels or in constants.
• Resolved the issue with the error when displaying the macros in the Confluence Page Gadget.
• Resolved the issue with duplicating a row of column labels when exporting to CSV the Jira Issues macro.

Fixed in this release:

• Resolved the issue with PDF export when table cells contain tables with merged cells.
• Resolved the issue with the Table Transformer macro when using special characters in column labels or in constants.
• Resolved the issue with the error when displaying the macros in the Confluence Page Gadget.
• Resolved the issue with duplicating a row of column labels when exporting to CSV the Jira Issues macro.

Fixed in this release:

• Resolved the issue with calculating average values in the Table Filter macro when the result is zero.
• Resolved the issue with Japanese date format.
• Resolved the issue with Table Excerpt macro within nested Pivot Table and Table Transformer macros.

Fixed in this release:

• Resolved the issue with calculating average values in the Table Filter macro when the result is zero.
• Resolved the issue with Japanese date format.
• Resolved the issue with Table Excerpt macro within nested Pivot Table and Table Transformer macros.

New in this release:

• Table Transformer macro ignores hidden columns.

Fixed in this release:

• Resolved the compatibility issue with Confluence 5.7 and older.
• Resolved the issue with filtration of a table with merged cells within Table Transformer macro.
• Resolved the issue with not working macros' preview in some cases.

New in this release:

• Table Transformer macro ignores hidden columns.

Fixed in this release:

• Resolved the compatibility issue with Confluence 5.7 and older.
• Resolved the issue with filtration of a table with merged cells within Table Transformer macro.
• Resolved the issue with not working macros' preview in some cases.

New in this release:

• Improved the compatibility with PlaySQL macros.
• Added a capability to hide the message next to table pagination.

Fixed in this release:

• Resolved the issue with redundant updating of chart caches for space export to PDF and mobile app.
• Resolved the issue with not working Expand macro within Table Transformer resulting table.
• Resolved the issue with global filter label in page edit mode.

New in this release:

• Improved the compatibility with PlaySQL macros.
• Added a capability to hide the message next to table pagination.

Fixed in this release:

• Resolved the issue with redundant updating of chart caches for space export to PDF and mobile app.
• Resolved the issue with not working Expand macro within Table Transformer resulting table.
• Resolved the issue with global filter label in page edit mode.

Fixed in this release:

• Resolved the issue with displaying not filtered table within Table Filter macro on mobile devices.
• Resolved the issue with default sorting and the total row in the Pivot Table macro.

Fixed in this release:

• Resolved the issue with displaying not filtered table within Table Filter macro on mobile devices.
• Resolved the issue with default sorting and the total row in the Pivot Table macro.

Fixed in this release:

• Resolved the issue with dates formatting in the Table Transformer macro.
• Resolved the issue with blinking hidden totals in the Pivot Table macro.

ixed in this release:

• Resolved the issue with dates formatting in the Table Transformer macro.
• Resolved the issue with blinking hidden totals in the Pivot Table macro.

Fixed in this release:

• Resolved the issue with Elements Spreadsheet for Confluence app dates processing.

Fixed in this release:

• Resolved the issue with Elements Spreadsheet for Confluence app dates processing.

Fixed in this release:

• Resolved the issue with the "Today" event in the Gantt chart.
• Resolved the issue with app settings page when the macro inline insertion is restricted to certain users or groups.

Fixed in this release:

• Resolved the issue with the "Today" event in the Gantt chart.
• Resolved the issue with app settings page when the macro inline insertion is restricted to certain users or groups.

New in this release:

• Milestones' and events' dates are taken in account when forming the dates axis in the Gantt chart.

Fixed in this release:

• Resolved the issue with inline macro insertion in Confluence 5.7.
• Resolved the minor issue with Table Transformer macro editor.

New in this release:

• Milestones' and events' dates are taken in account when forming the dates axis in the Gantt chart.

Fixed in this release:

• Resolved the issue with inline macro insertion in Confluence 5.7.
• Resolved the minor issue with Table Transformer macro editor.

Fixed in this release:

• Resolved the issue with Jira Filter Results gadget dates processing

Fixed in this release:

• Resolved the issue with Jira Filter Results gadget dates processing

Fixed in this release:

• Resolved the issue with Pie chart colors scrambling when some values disappear from the source table and the macro is updated.
• Resolved the issue with Table Filter macro included into the page by Table Excerpt Include macro.

Fixed in this release:

• Resolved the issue with Pie chart colors scrambling when some values disappear from the source table and the macro is updated.
• Resolved the issue with Table Filter macro included into the page by Table Excerpt Include macro.

Fixed in this release:

• Resolved the issue with showing inline macro insertion toolbar when hovering over the Gallery and the Course macros.

Fixed in this release:

• Resolved the issue with showing inline macro insertion toolbar when hovering over the Gallery and the Course macros.

Fixed in this release:

• Resolved the issue with Jira Issues macro within Page Properties Report.

Fixed in this release:

• Resolved the issue with Jira Issues macro within Page Properties Report.

Fixed in this release:

• Resolved the compatibility issue with Zabbix Plugin.
• Resolved the issue with showing inline macro insertion toolbar when hovering over the User Profile macro.

Fixed in this release:

• Resolved the compatibility issue with Zabbix Plugin.
• Resolved the issue with showing inline macro insertion toolbar when hovering over the User Profile macro.

Fixed in this release:

• Resolved the issue with viewing the Table Filter, Pivot Table, and Chart from Table macros wrapped in the Table Excerpt Include macro in the Confluence Mobile app and in mobile browsers.
• Resolved the compatibility issue with Handy Date when exporting page to PDF and Word.

Fixed in this release:

• Resolved the issue with viewing the Table Filter, Pivot Table, and Chart from Table macros wrapped in the Table Excerpt Include macro in the Confluence Mobile app and in mobile browsers.
• Resolved the compatibility issue with Handy Date when exporting page to PDF and Word.

Fixed in this release:

• Resolved the issue with tables lookup in the Table Transformer macro when there are more that 2 tables.
• Resolved the issue with pie / donut chart value formatting in the Chart from Table macro.

Fixed in this release:

• Resolved the issue with tables lookup in the Table Transformer macro when there are more that 2 tables.
• Resolved the issue with pie / donut chart value formatting in the Chart from Table macro.

Fixed in this release:

• Resolved the issue with editing of the last row of a table with the Table Filter macro total row enabled in Confluence 6.14+.
• Resolved the issue with exporting hidden source table of the Table Transformer macro within Chart from Table macro to PDF / Word.

Fixed in this release:

• Resolved the issue with editing of the last row of a table with the Table Filter macro total row enabled in Confluence 6.14+.
• Resolved the issue with exporting hidden source table of the Table Transformer macro within Chart from Table macro to PDF / Word.

New in this release:

• Added diagnostic messages for Table Transformer macro when invalid SQL query is used.

Fixed in this release:

• Resolved the issue with filtration in the page edit mode.
• Resolved the issue with columns suggestions when editing macros with nested Table Transformer and Jira Issues macros.

New in this release:

• Added diagnostic messages for Table Transformer macro when invalid SQL query is used.

Fixed in this release:

• Resolved the issue with filtration in the page edit mode.
• Resolved the issue with columns suggestions when editing macros with nested Table Transformer and Jira Issues macros.

New in this release:

• Added a capability to set thousand separator for totals in the Table Filter macro.

Fixed in this release:

• Resolved the issue with missing values in matching columns for rows with no matches when using look up tables preset in the Table Transformer macro.

New in this release:

• Added a capability to set thousand separator for totals in the Table Filter macro.

Fixed in this release:

• Resolved the issue with missing values in matching columns for rows with no matches when using look up tables preset in the Table Transformer macro.

New in this release:

• Improved compatibility with Easy Dropdown Menu app and page export.
• Table Excerpt Include macro outputs tables from child pages in the page tree order.

Fixed in this release:

• Resolved the issue with Table Filter macro default sorting wrapped around Table Transformer macro.
• Resolved the issue with inline macro insertion when using Table Excerpt Include macros.
• Resolved the issue with Table Filter macro wrapped around Table Transformer macro with Pivot Table macro inside.
• Resolved the issue with the combination of Table Filter Table Excerpt and Pivot Table macros.

New in this release:

• Improved compatibility with Easy Dropdown Menu app and page export.
• Table Excerpt Include macro outputs tables from child pages in the page tree order.

Fixed in this release:

• Resolved the issue with Table Filter macro default sorting wrapped around Table Transformer macro.
• Resolved the issue with inline macro insertion when using Table Excerpt Include macros.
• Resolved the issue with Table Filter macro wrapped around Table Transformer macro with Pivot Table macro inside.
• Resolved the issue with the combination of Table Filter Table Excerpt and Pivot Table macros.

Fixed in this release:

• Resolved the issue with page search by name containing slash in the Table Excerpt Include macro.
• Resolved the issue with date format in the Table Transformer macro.
• Resolved minor issues with multi-select fields.
• Resolved issues with the Table Transformer macro in Confluence 5.7 and older.

Fixed in this release:

• Resolved the issue with page search by name containing slash in the Table Excerpt Include macro.
• Resolved the issue with date format in the Table Transformer macro.
• Resolved minor issues with multi-select fields.
• Resolved issues with the Table Transformer macro in Confluence 5.7 and older.

New in this release

• Added compatibility for RefinedMobile for Confluence app.
• Improved the options search in dropdown filters.
• Added a capability to format numbers without decimals.

Fixed in this release:

• Resolved the issue with Table Transformer macro when source tables contain columns with mixed content type.
• Resolved the issue with wrong table columns width in the app PDF export when some columns are hidden by Table Filter macro.
• Resolved the issue with deleting a row with merged vertically cells inside Table Filter macro.
• Resolved the issue with floating page toolbar.
• Resolved the compatibility issues with Confluence 5.9 and older.

New in this release

• Added compatibility for RefinedMobile for Confluence app.
• Improved the options search in dropdown filters.
• Added a capability to format numbers without decimals.

Fixed in this release:

• Resolved the issue with Table Transformer macro when source tables contain columns with mixed content type.
• Resolved the issue with wrong table columns width in the app PDF export when some columns are hidden by Table Filter macro.
• Resolved the issue with deleting a row with merged vertically cells inside Table Filter macro.
• Resolved the issue with floating page toolbar.
• Resolved the compatibility issues with Confluence 5.9 and older.

New in this release:

• Added support for filtration tables wrapped with macros in page edit mode.

Fixed in this release:

• Resolved the issue with filtering a table with merged cells in the table heading.
• Resolved the issue with including Table Excerpt macro from a blog post.
• Resolved the issue with the repeated Table Transformer macro preview.

New in this release:

• Added support for filtration tables wrapped with macros in page edit mode.

Fixed in this release:

• Resolved the issue with filtering a table with merged cells in the table heading.
• Resolved the issue with including Table Excerpt macro from a blog post.
• Resolved the issue with the repeated Table Transformer macro preview.

New in this release:

• Added a capability to turn off aggregation by date periods in the Pivot Table macro.
• Added a capability to use line breaks in the Table Transformer SQL query.

Fixed in this release:

• Resolved the issue with Merge tables preset when tables' columns do not match by name in the Table Transformer macro.

New in this release:

• Added a capability to turn off aggregation by date periods in the Pivot Table macro.
• Added a capability to use line breaks in the Table Transformer SQL query.

Fixed in this release:

• Resolved the issue with Merge tables preset when tables' columns do not match by name in the Table Transformer macro.

New in this release:

Added the Table Transformer macro. The macro provides the ability to create a new table based on multiple tables in a few seconds:

• merge multiple tables (join rows from multiple tables to one table) using the default preset
• lookup multiple tables (join columns from multiple tables to one table) using the default preset
• perform any transformations: add complex formulas, match only specific rows (columns) using filtration criteria, output data using If/Then constructs, and much more using custom SQL queries

Greatly improved the Table Excerpt Include macro. Table Excerpt Include performs multi-excerpt from various sources:

• from specific pages (new feature)
• from pages with childpages and (or) all descendants (new feature)
• from pages by labels (new feature)
• from the current page

Added support for Confluence Mobile. Filtered tables, created pivot tables, and rendered charts are available for viewing in the Confluence Mobile app and in mobile browsers now.

New in this release:

Added the Table Transformer macro. The macro provides the ability to create a new table based on multiple tables in a few seconds:

• merge multiple tables (join rows from multiple tables to one table) using the default preset
• lookup multiple tables (join columns from multiple tables to one table) using the default preset
• perform any transformations: add complex formulas, match only specific rows (columns) using filtration criteria, output data using If/Then constructs, and much more using custom SQL queries

Greatly improved the Table Excerpt Include macro. Table Excerpt Include performs multi-excerpt from various sources:

• from specific pages (new feature)
• from pages with childpages and (or) all descendants (new feature)
• from pages by labels (new feature)
• from the current page

Added support for Confluence Mobile. Filtered tables, created pivot tables, and rendered charts are available for viewing in the Confluence Mobile app and in mobile browsers now.

Fixed in this release:

• Resolved the issue with showing total rows in Pivot Table macro wrapped with Table Filter macro when "Hide totals" option is set.
• Resolved the issue with doubled values in Pivot Table macro when using the same column in "Row labels" and "Column labels" fields.
• Resolved the compatibility issue with Accessibility for Confluence app.

Fixed in this release:

• Resolved the issue with showing total rows in Pivot Table macro wrapped with Table Filter macro when "Hide totals" option is set.
• Resolved the issue with doubled values in Pivot Table macro when using the same column in "Row labels" and "Column labels" fields.
• Resolved the compatibility issue with Accessibility for Confluence app.

Fixed in this release:

• Resolved the issue with Gantt chart colors reset on table filtration.
• Prevented the possibility of infinite loop inclusion of Table Excerpt macro.

Fixed in this release:

• Resolved the issue with Gantt chart colors reset on table filtration.
• Prevented the possibility of infinite loop inclusion of Table Excerpt macro.

Fixed in this release:

• Resolved the compatibility issue with SQL for Confluence (Pro Edition) app and inline macro insertion.

Fixed in this release:

• Resolved the compatibility issue with SQL for Confluence (Pro Edition) app and inline macro insertion.

Fixed in this release:

• Resolved the issue with color palette when setting colors for one chart type and then switching to another type with greater number of labels.
• Resolved the issue with export functionality when the custom content for storing attachments was not created successfully.
• Resolved the issue with macro browser when the page editor is refreshed.

Fixed in this release:

• Resolved the issue with color palette when setting colors for one chart type and then switching to another type with greater number of labels.
• Resolved the issue with export functionality when the custom content for storing attachments was not created successfully.
• Resolved the issue with macro browser when the page editor is refreshed.

Fixed in this release:

• Resolved the compatibility issue with SonarQube Connector for Confluence app.

Fixed in this release:

• Resolved the compatibility issue with SonarQube Connector for Confluence app.

Fixed in this release:

• Resolved the issue with Line and Area charts' settings when migrating from Confluence Cloud to Confluence Server or Data Center.

Fixed in this release:

• Resolved the issue with Line and Area charts' settings when migrating from Confluence Cloud to Confluence Server or Data Center.

New in this release:

• Improved the display of dates' labels when using the Scale X step option with the Time line chart type in the Chart from Table macro.

Fixed in this release:

• Resolved the issue with the incorrect data aggregation by months in the Pivot Table macro when the date format in the source table includes time.
• Resolved the issue with the incorrect date period aggregation in the Pivot Table macro when the source table includes empty cells.

New in this release:

• Improved the display of dates' labels when using the Scale X step option with the Time line chart type in the Chart from Table macro.

Fixed in this release:

• Resolved the issue with the incorrect data aggregation by months in the Pivot Table macro when the date format in the source table includes time.
• Resolved the issue with the incorrect date period aggregation in the Pivot Table macro when the source table includes empty cells.

New in this release:

• Improved the display of the Table Filter, Pivot Table and Chart from Table macros when using them inside sections and panels.

Fixed in this release:

• Resolved the issue with the incorrect work of the Pivot Table and Chart from Table macros when they are based on the mix of two tables (plain, filtered or pivot tables).

New in this release:

• Improved the display of the Table Filter, Pivot Table and Chart from Table macros when using them inside sections and panels.

Fixed in this release:

• Resolved the issue with the incorrect work of the Pivot Table and Chart from Table macros when they are based on the mix of two tables (plain, filtered or pivot tables).

New in this release

• Added support for the dynamic renderMode parameter in the Jira Issues macro.
• Added the ability to export the whole links' length (more than 255 characters) when using the Export to CSV feature.
• Added the auto-width of a chart option that let to resize a chart when changing the size of a page.

Fixed in this release:

• Resolved the issue with the charts' rendering in the page preview.

New in this release

• Added support for the dynamic renderMode parameter in the Jira Issues macro.
• Added the ability to export the whole links' length (more than 255 characters) when using the Export to CSV feature.
• Added the auto-width of a chart option that let to resize a chart when changing the size of a page.

Fixed in this release:

• Resolved the issue with the charts' rendering in the page preview.

Fixed in this release

• Resolved the issue with pasting in the page editor.

Fixed in this release

• Resolved the issue with pasting in the page editor.

New in this release

• Added compatibility with Confluence 6.14

Fixed in this release

• Resolved the issue broken hyperlinks in CSV export.
• Resolved the issue with SQL Query macro table sorting when using Table Filter macro with row numbering option.
• Resolved the issue when using nested Table Filter macro with default sorting inside another Table Filter macro with default sorting.

New in this release

• Added compatibility with Confluence 6.14

Fixed in this release

• Resolved the issue broken hyperlinks in CSV export.
• Resolved the issue with SQL Query macro table sorting when using Table Filter macro with row numbering option.
• Resolved the issue when using nested Table Filter macro with default sorting inside another Table Filter macro with default sorting.

Fixed in this release

• Resolved the compatibility issue between the ConfiForms Registration Control macro and the combination of the Table Filter and the Pivot Table macros.
• Resolved the compatibility issue between the "Retain row style order after sorting" option of the SQL Query macro and the "Dynamic row numbering" option of the Table Filter macro.
• Improved the space export feature.

Fixed in this release

• Resolved the compatibility issue between the ConfiForms Registration Control macro and the combination of the Table Filter and the Pivot Table macros.
• Resolved the compatibility issue between the "Retain row style order after sorting" option of the SQL Query macro and the "Dynamic row numbering" option of the Table Filter macro.
• Improved the space export feature.

Fixed in this release

• Resolved the compatibility issue with the PocketQuery macro when debug mode is enabled.
• Resolved the issue with Gantt chart placed inside hidden by default content.

Fixed in this release

• Resolved the compatibility issue with the PocketQuery macro when debug mode is enabled.
• Resolved the issue with Gantt chart placed inside hidden by default content.

Fixed in this release

• Resolved the issue with adding the macros in the page view mode when using the app in combination with the Pocketquery macro.
• Improved performance of the app.

Fixed in this release

• Resolved the issue with adding the macros in the page view mode when using the app in combination with the Pocketquery macro.
• Improved performance of the app.

New in this release

• Improved compatibility of the Chart from Table macro with the LaTeX Math app.

Fixed in this release

• Resolved the issue with the Table Filter macro used in dashboard templates.

New in this release

• Improved compatibility of the Chart from Table macro with the LaTeX Math app.

Fixed in this release

• Resolved the issue with the Table Filter macro used in dashboard templates.

New in this release

• Added support of links exporting in the export to PDF option.

Fixed in this release

• Resolved the issue with the sorting option when using dynamic tables in the Pivot Table macro.

New in this release

• Added support of links exporting in the export to PDF option.

Fixed in this release

• Resolved the issue with the sorting option when using dynamic tables in the Pivot Table macro.

New in this release

• Added an option to specify the date format directly when adding the Date Filter type in the Table Filter macro.
• Improved hints when adding filters and setting filter values in the Table Filter macro.
• Added the information messages when using combinations with other macros and apps.
• Added Russian localization.
• Added an ability to set the Total row title in the Table Filter macro.
• Added an option to place filters on the filtration pane according to their adding sequence in the Table Filter macro.
• Added an indicator of unsaved changes.
• Changed the order of setting chart parameters in the Chart from Table macro.

Fixed in this release

• Resolved the issue with broken filters and table scrolling after changes canceling (using Ctrl+z) in the page edit mode.

New in this release

• Added an option to specify the date format directly when adding the Date Filter type in the Table Filter macro.
• Improved hints when adding filters and setting filter values in the Table Filter macro.
• Added the information messages when using combinations with other macros and apps.
• Added Russian localization.
• Added an ability to set the Total row title in the Table Filter macro.
• Added an option to place filters on the filtration pane according to their adding sequence in the Table Filter macro.
• Added an indicator of unsaved changes.
• Changed the order of setting chart parameters in the Chart from Table macro.

Fixed in this release

• Resolved the issue with broken filters and table scrolling after changes canceling (using Ctrl+z) in the page edit mode.

Fixed in this release

• Resolved the compatibility issue with the Future macro.
• Improved performance of the Table Filter macro when filtering in the page edit mode.

Fixed in this release

• Resolved the compatibility issue with the Future macro.
• Improved performance of the Table Filter macro when filtering in the page edit mode.

Fixed in this release

• Resolved the issue with showing a hidden Total row/column and a source table in the Pivot Table macro when using Scroll Office export to Word.
• Resolved the issue with exporting a table created with the help of the Page Include or Excerpt Include macro and wrapped with the Table Filter macro without applied filters when using Scroll Office export to Word.
• Resolved the issue with empty options when selecting columns for filtration in the Table Filter macro editor in Internet Explorer 11.
• Resolved the issue with failing macros when used inside a cross-domain iframe.

Fixed in this release

• Resolved the issue with showing a hidden Total row/column and a source table in the Pivot Table macro when using Scroll Office export to Word.
• Resolved the issue with exporting a table created with the help of the Page Include or Excerpt Include macro and wrapped with the Table Filter macro without applied filters when using Scroll Office export to Word.
• Resolved the issue with empty options when selecting columns for filtration in the Table Filter macro editor in Internet Explorer 11.
• Resolved the issue with failing macros when used inside a cross-domain iframe.

New in this release

• Added space and page tree export support: applied macros persist when exporting space and page tree.

Fixed in this release

• Resolved the issue with incorrect table export to PDF when there are empty rows on the first page of a table.
• Resolved the issue with duplicated November when using date range aggregation in pivot tables.

New in this release

• Added space and page tree export support: applied macros persist when exporting space and page tree.

Fixed in this release

• Resolved the issue with incorrect table export to PDF when there are empty rows on the first page of a table.
• Resolved the issue with duplicated November when using date range aggregation in pivot tables.

Fixed in this release

• Resolved the issue with broken Jira issue links when using Pivot Table macro literal operation.

Fixed in this release

• Resolved the issue with broken Jira issue links when using Pivot Table macro literal operation.

New in this release

• Added Dutch localization.

Fixed in this release

• Resolved the issue with the incorrect filtration pane layout when the filter is disabled.

New in this release

• Added Dutch localization.

Fixed in this release

• Resolved the issue with the incorrect filtration pane layout when the filter is disabled.

New in this release

• Added an option of columns sorting in the page edit mode for macOS with the Cmd+Click shortcut.
• Added an option to display the same type of data labels in 2D and 3D pie and donut charts when hovering over data labels.

Fixed in this release

• Resolved the issue with the dot type of line in line charts.
• Resolved the issue with the line settings interface in line and timeline charts in the page edit mode.
• Resolved the issue with displaying data labels in 3D pie and donut charts on existing pages.
• Resolved the issue with a sticky header layout when the hide columns filter type is applied.
• Resolved the compatibility issue with the Content Formatting app.

New in this release

• Added an option of columns sorting in the page edit mode for macOS with the Cmd+Click shortcut.
• Added an option to display the same type of data labels in 2D and 3D pie and donut charts when hovering over data labels.

Fixed in this release

• Resolved the issue with the dot type of line in line charts.
• Resolved the issue with the line settings interface in line and timeline charts in the page edit mode.
• Resolved the issue with displaying data labels in 3D pie and donut charts on existing pages.
• Resolved the issue with a sticky header layout when the hide columns filter type is applied.
• Resolved the compatibility issue with the Content Formatting app.

New in this release

• Added an option to specify types of lines (solid, dash, dot) and line width when using Line and Time Line types of charts.
• Added an option to define an interpolation type individually for each line when using line charts.
• Added an ability to show descriptions of milestones and events when you hove over the milestone (event) in Gantt charts.
• Added an option to choose a way to show data labels (percents and/or values or none) when using pie/donut charts.
• Added an option to show a copy of a source table in the Table Excerpt Include macro.

New in this release

• Added an option to specify types of lines (solid, dash, dot) and line width when using Line and Time Line types of charts.
• Added an option to define an interpolation type individually for each line when using line charts.
• Added an ability to show descriptions of milestones and events when you hove over the milestone (event) in Gantt charts.
• Added an option to choose a way to show data labels (percents and/or values or none) when using pie/donut charts.
• Added an option to show a copy of a source table in the Table Excerpt Include macro.

New in this release

• Added a default option to display Row labels in a pivot table in order according to a source table if no special order settings are set.

Fixed in this release

• Resolved the issue with the incorrect -Empty- value when changing the interface language.

New in this release

• Added a default option to display Row labels in a pivot table in order according to a source table if no special order settings are set.

Fixed in this release

• Resolved the issue with the incorrect -Empty- value when changing the interface language.

Fixed in this release

• Resolved the issue with the incorrect table layout when cells are merged and the native numbering is applied within the macros.
• Resolved the issue with the incorrect table layout when column labels are set and a heading of a pivot table is collapsed.
• Resolved the issue with the native export to PDF without displaying the total column (row) created in the Table Filter macro.

Fixed in this release

• Resolved the issue with the incorrect table layout when cells are merged and the native numbering is applied within the macros.
• Resolved the issue with the incorrect table layout when column labels are set and a heading of a pivot table is collapsed.
• Resolved the issue with the native export to PDF without displaying the total column (row) created in the Table Filter macro.

New in this release

• Added support for a new Confluence Data Center deployment.

Fixed in this release

• Resolved the issue with selecting colors in charts in the edit mode when the values columns are not specified.
• Resolved the issue with saving an incorrect operation type in the pivot table after its changing in parameters in the edit mode.
• Resolved the issue with incorrect default setting of decimal separator when inserting the macro in the view mode.
• Resolved the issue with displaying visual filter in the view mode after its adding on the filtration pane in the edit mode.

Fixed in this release

• Resolved the issue with cell height displacement in the view mode in Firefox Web Browser when the first N columns are frozen.
• Resolved the issue with adding special symbols to the cell values while copying the data directly from the view mode when the first N rows or columns are frozen.

Fixed in this release

• Resolved the issue with color setting for Pie and Donut charts when several columns are selected in the Labels column field.
• Resolved the issue with number range aggregation in the Pivot Table macro.
• Resolved the issue with dynamic row numbering when default filtering and sorting are set in the Table Filter macro.
• Resolved the issue with counting totals for columns when option Show first N rows is set.

Fixed in this release

• Resolved the issue with incorrect sizing of table and its columns when using two cascading Table Filter macros when inner macro is set to hide columns.

Fixed in this release

• Resolved the issue with Table Filter macro when tablesorter.js is not available on the page.
• Resolved the issue with malfunction of some macros after copying a bunch of Table Filter, Chart from Table and Pivot Table macros into the page.
• Resolved the issue with setting colors in the Chart from Table macro with incorrect table columns set when editing the page.

Fixed in this release

• Resolved the issue with Pivot Table macro when tablesorter.js is not available on the page.
• Resolved the issue with not working Freeze first N columns option with JIRA Issues macro.
• Resolved the issue with setting colors for the icons based chart in the Chart from Table macro when editing the page.
• Resolved the issue with visible Pivot Table controls inside Chart from Table macro with a hidden source table.

New in this release

• Improved performance.
• Table Filter macro Total Row / Column option outputs values with user defined decimal separator.
• Added compatibility of Sparkline charts with worklog and time intervals.

Fixed in this release

• Resolved the issue with setting charts date format when viewing the page.
• Resolved the issue with missing options in dropdown filters when Update dropdown filters option is set and Multi-filter operator is set to OR.
• Resolved the issue with not working Hide Columns filter when Multi-filter operator is set to OR and no filtration is applied.
• Resolved the issue with missing the last Total cell when Total Row and Total Column are set and filtration is disabled by default.
• Resolved the issue with missing Sparkline charts when filtration is disabled by default.
• Resolved the issue with not working sorting of a column with IP addresses in the page editor.

Read more

Fixed in this release

• Resolved the issue with aggregating data against issue priorities in Pivot Table macro when different priorities use same icons.

New in this release

• Added compatibility with Data Center read-only mode.
• Added a capability to show one-day tasks in the Gantt chart.
• Improved the Gantt chart to show tasks' end date inclusively.
• Hiding the source table of a chart doesn't hide pagination and links of the source table macro. Table Excerpt macro can be used to hide it.

Fixed in this release

• Resolved the issue with parsing dates with Polish months names.
• Resolved the issue with impossibility to set colors for Pie and Gantt charts when there are html special characters in the chart labels.
• Resolved the issue with impossibility to set colors for Gantt chart when editing the page

New in this release

• Added date format autodetect of date macro in Pivot Table and Chart from Table macros. Users with different language and date format settings are able to build time based charts and aggregate data against time periods when the source table contains date macros.

New in this release

• Improved export to CSV of a table with embedded table.

Fixed in this release

• Resolved the issue with trimmed axis labels in Bar charts.

New in this release

• Added a capability to export tables using Table Filter macro export feature with disabled filtration.

Fixed in this release

• Resolved the issue with filtration of a table with merged cells using nested Table Filter macros.
• Resolved the compatibility issue with Reporting for Confluence app and inline macro insertion.
• Resolved the issue with loosing Pivot Table macro settings when a dynamic source table shows empty header first.
• Resolved the issue with saving filtration results in the page when the page draft stores a table in the filtered state.

Fixed in this release

• Resolved the issue with sparkline charts and Page Properties Report macro.
• Resolved the issue with wrong table width with hidden columns.

New in this release

• Added support for the year and quarter date formats for the Time Line/Area reports.
• Added the tentative drawing of the trendline in case of insufficient values in the source table.
• Added an option to define shortenings for worklog units for foreign languages.

Fixed in this release

• Improved the export of charts to PDF and image quality.
• Resolved the issue with the export of the hidden total columns and collapsed columns or rows of the Pivot Table macro to PDF.
• Resolved the issue with custom filter labels.
• Resolved the issue with calculation of worklogs having fractional values.
• Resolved the issue with operation of the Table Filter macro when the number of filters on the pane and in the page storage is different.
• Resolved the issue with the nested table with filter.

Fixed in this release

• Improved export to PDF of wide tables and charts.
• Improved accuracy of trend line based on data series with missing values.
• Resolved the compatibility issue with Survey and Votes Macros app.
• Resolved the issue with Freeze first N rows feature in the page edit mode.

Fixed in this release

• Resolved the issue with Table Filter macro "Update dropdown filters" option in Internet Explorer 11.
• Resolved the compatibility issue with Live Template macro from Scaffolding Forms & Templates app.
• Resolved the issue with app's export to PDF of a wide table with fixed width.

Fixed in this release

• Resolved the issue with impossibility to enable inline macro insertion after disabling it when using Oracle database.
• Resolved the issue with zooming charts with trend line enabled.
• Resolved the issue with disabling chart series with trend line enabled.
• Improved performance of CSV export.
• Resolved the issue with setting chart colors in the page edit mode when using dynamic macro as a source table.

New in this release

• Added an option to enable the inline macro insertion for users and groups.
• Added an option to enable/disable inline macro insertion into the user profile.
• Added calculation of the first column if it contains the number.
• Added a capability to pick the color for the milestone without a title.
• Added a capability to rename the Total column.
• Added a new operation type - multiplication.
• Added a new operation type - count values.
• Improved the display of names of milestone on the Gantt chart so they do not overlap each other.
• Added the trendline for the column/bar charts.

Fixed in this release

• Resolved the issue with aggregation of data by day.
• Resolved the issue with failing on an invalid html markup of a table.
• Resolved the issue with resetting colors when saving Chart from Table macro changes with JIRA Issues macro before the macro preview is available.
• Improved performance of the CSV export.

Fixed in this release

• Resolved the compatibility issue with Git4C - Git Viewer for Confluence app.

Fixed in this release

• Resolved the issue with counting same emoticons as different icons in Pivot Table when emoticons were saved as images because of the issue in Confluence.
• Resolved the issue with possibility to insert several copies of a macro from page view mode.

Fixed in this release

• Resolved the issue with duplication of emoticons in Visual Filter when viewing the filter in another language than default values were saved.