Changelog

[4.1.2] - 26-03-2024

• Added "Total Pivot Rows" and "Filtered Pivot Rows" labels in the status bar for pivot mode.
• Fixed a bug affecting Excel exports with grouping enabled.
• Fixed a bug to ensure the configuration page uses the data fetching method set in settings.
• Removed the "Keep Only" and "Exclude" options in the context menu for pivot mode.

[4.1.1] - 22-03-2024

• Added option to set both filter styles (list and wildcards).

[4.1.0] - 14-03-2024

• Added option to use the new paginated method of loading data.
• Fixed conditional background coloring of columns that use calculated column's value.
• Improved column filter functionality: Now supports up to 20 filter values for each column filter.
• Improved CSV Export: Grouped row values will now be displayed in all the group cells.
• Fixed pivot column ordering when the column is a date field and the date format is set to 'WW' for the week number.
• Improved Inline filters to include both the search option and the filter values by selection (checkboxes).
• Added floating filters to grouping columns.
• Improved column header tooltip. The tooltip will only appear when it has been configured.

[4.0.3] - 08-02-2024

• Improved renaming calculated fields throwing an error.
• Improved exporting to Excel not working when using custom sorting.
• Improved exporting to Excel with seperators.

[4.0.2] - 24-01-2024

• Improved background coloring of dimensions not always working.

[4.0.1] - 23-01-2024

• Resolve a possible issue with grouping of values when conditional coloring of measures.

[4.0.0] - 23-01-2024

Added

• Column groups: We've improved and streamlined the process of creating and managing column groups, making it more intuitive and user-friendly.
  • Column groups can now be effortlessly managed via a new, dedicated page accessible from the data tab in the configuration settings.
  • Personalise your column groups with enhanced customisation options, including the ability to independently style the background and font colours of each header cell.
  • When using the greater then (>) sign in the column name, an option appears to escape the (>) character and it will be treated as part of the name.
• Added option to color the font and background of each column header individually.
• Manual sort order of column values.
  • A custom sort order can be set for columns with less then 100 unique values.
  • Ordering can be set on the datacolumn configuration page by dragging the values in the desired custom order.
• Added options to configure display units for measures (Thousands, Millions, Billions, Trillions).
• Added an option to configure the column header alignment (left, center, right).
• Enhanced Excel Export: Now features a 'Grand Totals' row at the bottom of each exported table, just like it appears in SuperTables. It's included by default, so there's no extra work needed.
• Added 2 new operators in the If-Else Formula Builder: 'And' and 'Or'. These operators can be used to create more complex conditions and combine multiple conditions into one.
• Added a new option to the hamburger menu per column that lets you configure autosize columns (width) to the window size.
• Added advanced filter option in configuration. This filter allows you to filter on multiple columns and values at once with And and Or operators. The builder can also be used to create complex filters with multiple conditions.
• Added an option to conditionally color all the cells based on the same or a different column (continuous or discrete).
• Added new Theme options to style the totals and sub totals rows. These styles will also be applied in the Excel export.
• Added new option to add floating export buttons to the table. These buttons can be used for a one click export of the SuperTable to Excel, CSV or PDF.
• Added a new option to make group rows sticky. This option will make the group rows stick to the top of the table when scrolling down.

Improved

• Fixed a filtering issue where columns containing a dot ('.') in their name would not be filtered correctly.
• Fixed the column background color when grouping the column or using the column in pivot mode.
• Fixed a bug with tooltip where using a column as an image URL would add an additional space at the end of the URL.
• Fixed disappearing group rows when using the 'Hide parent group row' without 'Use multiple columns for grouping'. Now the parent group row will only be hidden when using the 'Use multiple columns for grouping' option.
• Fixed a bug with background color in the theming section where the background color would not be applied to the odd rows in row banding.
• Fixed an issue with the Multiple Values (list) filter style not working correctly.
• Improved security and bumping of dependencies to latest and most secure versions.

[3.4.6] - 09-11-2023

• Fixed grid update when only the data of the datasheet changes.

[3.4.5] - 17-10-2023

• Improved styling inconsistency with barchart backgrounds.

[3.4.4] - 12-10-2023

• Fixed styling where selecting a row was not showing a full row selection.
• Fixed text not always wrapping which prevented auto row height to work.

[3.4.3] - 04-09-2023

• Fixed issue with Excel and CSV export names not matching the configured name.
• Fixed issue with grouped column's name not being shown in the rows when enabled.
• Fixed issue with the tooltip showing row count when disabled.

[3.4.2] - 01-09-2023

• Improved landingspage.

[3.4.1] - 24-08-2023

• Fixed the issue with the state parameter not storing the state when it was empty.
• Fixed the down-arrow icon not showing in the formula builder sidebar.
• Fixed the double percent (%%) showing up for calculated fields of type percentage.

[3.4.0] - 18-08-2023

• Formula Builder: Added a formula builder to create calculated fields. The end users can now create their own custom-calculated fields in SuperTables.
• If Else Formula Builder: Added an if else formula builder to create conditional calculated fields. This feature is available to both SuperTables configurators and their end users.
• Tooltip: Added Tooltip functionality to SuperTables, create multiple tooltips with text, images, and more. Find the tooltip configuration as a new tab in the settings.
• Added option to format negative values as positive values (absolute).
• Added option for the grand totals to be visible at the top of the table.
• Added subtotals to be visible at the top of the grouped rows.
• Added an option to hide the index column in the columns side panel.
• Improved the configuration layout by making the buttons fixed at the bottom.
• Removed the product guide due to issues with its website cookies.

[3.3.4] - 12-07-2023

• Reverted to older data fetching method, Extensions API v1.10 is causing SuperTables to crash when no data is present in the datasheet.
• [Enterprise Only] Improved enterprise binary executable.

[3.3.3] - 09-05-2023

• [Enterprise Only] Improved enterprise binary executable.

[3.3.2] - 02-05-2023

• Fix for grouped column calculation with pivot mode.

[3.3.1] - 01-05-2023

• Fix for export to csv.

[3.3.0] - 28-04-2023

• Added option to prevent users to be able to select multiple rows

• Added paginated data loading support when opening SuperTables.

• Added option to prevent users to be able to select multiple rows.

• Added option to set the file name of Excel and CSV export.

• Changed configuration modal to a non blocking popup.

• Changed popup mode modal to a non blocking popup.

• Changed OK button to Apply & Close.

• Fixed background color not showing in excel export.

• Fixed export to csv/excel when setting Export all rows except last level is ON.

• Fixed Excel export without thousands seperator.

• Added currency validity check. Not supported in Tableau Desktop.

• [Enterprise Only] Added auditing option for exports. The audits are stored in a log file on the server.

• [Enterprise Only] Implemented our new enterprise installer. Make sure to read our latest upgrade guide on the website.

• [Enterprise Only] New enterprise binary with improved and additional features.

[3.2.2] - 22-02-2023

• Fixed issue with null values showing up while using the date filter.

[3.2.1] - 02-02-2023

• Fixed bug for 'Enable URL actions for grouped values'

[3.2.0] - 01-02-2023

• Added option to enable disable URL actions for grouped values. Appearance -> grouping options.
• Added option to set a fixed background color for a column.
• Added option to set the order of value columns in pivot.
• Added option to set order of column labels in pivot.
• Added option to hide (sub)total values.
• Added option to set conditional formatting of dimensions based on a value column.
• Fixed excel export not having styling on measures.
• Fixed right click menu from disappearing on the columns.
• Fixed count distinct on pivot label columns.
• Fixed URL actions for blank cells.

[3.1.3] - 21-12-2022

• Fixed disabling aggregated while grouping.

[3.1.2] - 30-11-2022

• Fixed issue with specific SuperTables configuration ending in an endless loading screen with version 3.1.0.

[3.1.1] - 29-11-2022

• Grouping bar will now have a scrollbar when the amount of grouped fields does not fit in the grouping bar. The scrollbar will be visible when you hover over the grouping bar.
• Fixed sorting on dates with quarters.
• Fixed crash in exporting to Excel when date column contains a blank (null).
• Improved UX in configuration when using a parameter to store multiple views.

[3.1.0] - 10-11-2022

• New theme option:
  • Change font size of SuperTables.
• [Export to Excel] Background and text coloring on dimensions, measures and/or calculations will be included in the export to Excel.
• [Export to Excel] Improved layout of group rows. Groups will now automatically indent, are bold and have an improved look and feel.
• [Export to Excel] Fixed export to Excel not always showing dates formatted.
• [Export to Excel and CSV] Fixed exporting a pivot table not including column headers.
• [Export to PDF] Improved export to PDF, catched some bugs.
• Fixed filtering not working in pivot mode.
• Fixed sorting on date fields when using custom formatting like DD-MM-YYYY.
• Fixed parameter layout switching for dashboard viewers.
• Improved license check for SuperTables enterprise customers.
• Added separate restrictions for all export types.