Release Notes Power XL Table v1.3.2
This topic describes feature enhancements, resolved issues, and important information for Power ON Power XL Table v1.3.0, v1.3.1 and v1.3.2 released on December 15th, 2023.
Power XL Table v1.3.0 New Features
New settings are available on Designer Ribbon of Power XL table.
Title | Description |
|---|---|
Detailed Validation Message Threshold | The Detailed Validation Message Threshold field allows you to specify how many invalid cell coordinates should be visible in the data validation error message. |
External Stylesheet | The External Stylesheet setting provides an option to inject CSS code to customize elements of the visual, such as buttons and labels. Users can either supply a CSS file as a URL or simply paste inline CSS code. |
Insert Security Measure | The Insert Security Measure setting allows you to manage record insertion in Reading View. To use this setting, you must add the SmartFilter visual to the report with a DAX measure. Then, in the input field of the setting, you must write the name of the same DAX measure in the following format: |
Power XL Table v1.3.0 Features Enhancements
Title | Description |
|---|---|
Enable Row Selection | The 'Enable Row Selection' setting has been renamed to 'Row Selection', and it has four new options instead of the previous 'ON' and 'OFF' states. The available options are None, Cells, Entire Row, and Both. |
Enable Add and Enable Delete | “Display Add Row button” and “Display Delete Row button” settings have been renamed to “Enable Add” and “Enable Delete”. |
Power XL Table v1.3.0 Resolved Issues
Title | Description |
|---|---|
Data Validation issue with Validate All Records: OFF | When you insert a new row with Insert button, the data validator does not check the old records. |
The issue with Validate All Records: OFF | The issue with the data validation not being triggered for the formula result is changed to an invalid value. |
Formula refresh on non-Data sheets | The formulas do refresh as expected on another non-data sheets. |
Comma divided selection type column | Selection type column does not divide even if there are two commas in name. |
IFISROWDIRTY() AND IFISRANGEDIRTY() with Always Show Insert Row | If the user filters to see insert row only, IFISROWDIRTY() and IFISRANGEDIRTY() functions now show the result as expected. |
The (in)activation of the Row Selection | Row selection does not get inactivated if you select another cell in the same row. |
Exporting xlsx from Power XL Table | Users can export reports to a xlsx file without encountering any error. |
Cell selection after slicer change | Cell selection positions remains same even if slicer is changed. |
Validate All Records: OFF and existing cells | If "Validate All Records" is set as OFF, a newly inserted row will not be validated. |
| Validate All Records: OFF and inserted rows | If the "Validate ALL Records" setting is set as OFF, the last row is not validated now. |
Required column cell | If the required column's cell is left empty in a new row, you cannot save. |
Validate All Records: ON and existing cells | If "Validate All Records" setting is set as ON, all the existing invalid records are validated even if a new row is inserted. |
Validate All Records: OFF and the data validations | The data validation of fields is disabled when the user sets the "Validate All Records" setting as OFF. |
IFISROWDIRTY() and performance | Report rendering speed is as expected even if it contains IFISROWDIRTY() formulas. |
Editing a formula in formula bar | While editing in the formula bar and clicking on another spot in it, the formula editor remains in its position. |
Selection columns and stepping back from Focus mode | The selection controls remain in its position after stepping back from Focus mode. |
Border All setting and Performance | Performance is as expected if "Border All setting" is applied to the data table. |
IFISROWDIRTY() and row delete | If the user deletes a row with a IFISROWDIRT formula, the next row is not affected any more. |
CTRL + Arrow keys | The behavior of the CTRL + Arrow keys is similar to that of Excel. |
Two fields with the same name | If two fields share the same name, the one with the proper Source Table setting is used. |
Wrap text on new rows | The Wrap text setting now applies in new rows. |
Duplicated columns | The Columns do not duplicate now while performing a save or trying to set the field to “Don’t summarize”, or for any other reason. |
Iterative formulas | The iterative formulas now behave as expected. |
Validate All Records:ON and the customized data validations | If a user sets "Validate All Records" setting as ‘ON’, previous customized data validation appears as expected. |
Selection type columns and Validate All Records setting | If "Validate All Record" is set as OFF, the selection type columns work as expected. |
Scrolling and mouse click | While scrolling and the mouse click is released outside of the visual, the scroll does not get locked. |
Formula fill down in value-formula range | In the Edit mode, the formula delete populates in case of a value-formula range as expected. |
TypeError on the DataSource or the TableSheet sheets | The TypeError does not appear now after right-clicking on the DataSource or the TableSheet sheets. |
Power XL Table v1.3.1 Resolved Issues
Title | Description |
|---|---|
The hyperlink formula | Hyperlink formulas are now working as expected. |
Power XL Table v1.3.2 Resolved Issues
Title | Description |
|---|---|
CSS injection issue | The horizontal scroll bar appears as expected even after custom CSS is applied. |