Power XL Table v24.3.1 Release Notes

The Power XL Table now offers dependent or cascading drop-down lists within the grid. This feature ensures that subsequent drop-down lists display options based on the selection made in the preceding drop-down. For instance, selecting Hungary in the Country drop-down will filter the City drop-down to only display cities in Hungary. If you then select Budapest as the city, the Street drop-down will display localities in Budapest.

This functionality is available for the Selection type column, which provides a drop-down control for each cell in the selected column. The following fields are now available in the Column Settings panel in the Power XL tab:

• Parent Column Name - This field allows you to set the parent drop-down for cascading lists.
• Parent Value - This field allows you to provide the original name of the parent column if the parent column has been renamed in the data table, ensuring it maps correctly.

Power XL Table now allows you to apply write security measures to specific columns. The Column Settings panel includes a Write Security tab with the following new options:

• Apply to Selected Columns - This checkbox becomes available only when the Write Security option is enabled. It allows you to specify which columns should be subject to write security measures. If this checkbox is disabled, write security applies to all columns. This setting is also available under Column Properties for each individual column. Enabling it marks the column as a Protected Column.
• Available Columns - Lists all the available columns in the grid.
• Protected Columns - Move the required available columns to this list to make them non-editable and ensure all cells within these columns are read-only.

A column will now be fully editable only when the visual is in Edit mode and no write security measures are applied to it, which means the write security column must not return a value of 0 or null.

Power XL Table now supports additional input formats. From the new Region setting in the Localization tab of the Design and Layout panel, you can either choose Auto Detect, which identifies the browser language and sets the local format for decimals, thousand separators, and dates, displaying the column values accordingly, or select any language of your preference. The default value is English (US).

The new Save Confirmation Pop-up setting in the Writeback Settings panel allows you to define the time interval (up to 30 seconds) for displaying the save confirmation pop-up. The default value is 0 which indicates that the pop-up remains on screen and can be manually closed.

The new Show Status Bar in Reading View setting in the Design and Layout > Layout panel allows you to display the timestamp of the last successful save in the grid’s status bar when in reading mode. The status bar also displays the average, count, and summary values for the numbers selected in the grid.

Power XL Table allows formula updates in edit mode as expected, even when the cell is protected by write security.

The =IFISROWDIRTY(USERPRINCIPALNAME()) formula now triggers correctly on the data table sheet when modifications are made on the subsequent sheet/form.

This release resolves the issue where icons appeared pixelated when display buttons were set as icons in the design and layout settings. The icons have now been updated.

The custom tables styles created in Home > Styles > Format Table are now successfully saved.

The export and import functions now include enhanced error messages. These error messages are triggered when the visual uses the VP Service from VPS_store or when the Web Service URL is incorrect in the report. The specific conditions for these error messages are as follows:

• If the value is an empty string.
• If the value does not end with PPWebService.svc.
• If the value does not start with http:// or https://.

Data validations for calculated columns are now consistently applied, and after successful validation, saving is enabled.

This release resolves the issue where error messages appeared in sheets that did not contain the data table.

Decimal formatting is now correctly applied to numbers, even when there is only one row in the table.

Power XL Table now successfully saves the list input control for columns added in Home > Cell Dropdowns.

This release fixes the issue where the border color setting was not being applied successfully in the data table.

This version ensures the scroll bar remains accessible in panels.

Connection details updated in the configuration panel accessed through the Power XL ribbon are now saved successfully.

The visual no longer crashes when there are rows and drop-downs with up to 2000 selection values.

This release fixes the issue where the custom size of grouped columns was not being saved successfully.