Release of version 2.18.1 (2024-12-02)

What's New

• ROU-11192 - Updated Wijmo library to version 2024v2 - build 5.20242.21.

Fixed Issues and Improvements

• ROU-11338 - Fixed an issue that caused the column Dropdown to display ‘[object Object]’ when using the arrow keys to move between options.
• ROU-11327 - Fixed an issue where the column headers displayed incorrect tooltip content when using grouped columns in a Grid.
• ROU-11289 - Fixed an issue that prevented the ContextMenu block from triggering the OnMenuToggle/OnBeforeOpen events as expected. This occurred when having more than one Grid instance on a screen.
• ROU-10980 - Fixed an issue that caused the Column's TextConditionalFormat property not to be applied correctly on the OnParametersChanged. This occurred when having more than one Grid instance on a screen.

Release of version 2.17.0 (2024-09-30)

Fixed Issues and Improvements

• ROU-11001 / RPM-5153 - To improve security and protect against XSS vulnerabilities, a new parameter, SanitizeInputValues, has been added to the Grid block's optional configurations.
  This parameter allows developers to control whether data should be sanitized to prevent HTML injection, particularly in column blocks like the ActionColumn, ImageColumn, and ContextMenu.
  The default value for SanitizeInputValues is set to True, ensuring that HTML content is automatically sanitized out of the box, prioritizing security.
• ROU-11034 - Fixed an issue where an error was being thrown in the console when clicking a cell in an autogenerated Grid that uses JSON serialization.
• ROU-11162 - Fixed an issue where the Grid filter's dropdown values were misaligned, and the Grid content along with pagination appeared in bold.
  This occurred when the Grid block was placed inside a Popup widget.

Release of version 2.16.0 (2024-08-19)

What's New

• ROU-10869 - Updated Wijmo library to version 2024v1.1 - build 5.20241.19.
• ROU-4904 - A new event called OnBeforeOpen was added to the ContextMenu block, to allow developers to control the items that appear as options on each column.

Fixed Issues and Improvements

• ROU-4896 - Fixed an issue that caused the ApplyRowValidations client action to delete a Dropdown Column cell content when called.
  This occurred when the Dropdown Column cell was dependent on another one.
  The ApplyRowValidations client action will no longer trigger the OnCellValueChange event handler as it did before so any edge case using this must be changed.
• ROU-4900 - Fixed an issue that caused the Grid’s OnCellClick event to return the wrong column information when the columns were reordered.
  This occurred when clicking on a cell after manually reordering the Grid’s columns.
• ROU-10722 / RPM-4970 - Fixed an issue where the Group Column header would disappear during horizontal scrolling.
  This occurred when the first column in a group was set to "hidden" and horizontal scrolling was performed.
• ROU-10759 / RPM-4956 - Fixed an issue where Data Grid Dropdown columns allowed entries not present in the filtered list.
  This issue occurred when two Dropdowns were parent-child bound, and users manually input a value that wasn't in the filtered list of the child Dropdown.
• ROU-10775 / RPM-4982 - Fixed an issue that caused the AddColumnClass client action to apply the CSS class to the Grid's header when setting the ApplyToHeader parameter to false.
  This occurred due to a regression in Wijmo's Flexgrid library on version 5.20241.9 that was now fixed in the latest version.
• ROU-10824 - Fixed an issue that caused ContextMenuItems to be displayed in a different order than the one specified in the IDE.
• ROU-10868 / RPM-5077 - Fixed a security vulnerability. CVSSv3.1 score 7.3 (High).
  Updated an internal dependency from JSZip to version v3.10.1 and, because of that, the internal method for exporting to XLSX in Wijmo FlexGrid now needs to use an asynchronous method (saveAsync instead of save).
• ROU-10879 / RPM-5069 - Fixed an issue that caused the ColumnPicker to allow the selection of disabled checkboxes.
  This occurred when one of the columns had the CanBeHidden Column property set to true and Ctrl+A was performed inside the Column Picker.
• ROU-10979 - Fixed an issue that caused the Grid block to have some elements above other components.
  This occurred when the Grid had frozen columns and had elements like dropdowns that opened above its headers.

ODC Release of version 2.15.0 (2024-04-15)

What's New

• ROU-4827 - Updated Wijmo library to version 5.20241.9 (2024v1).

Fixed Issues and Improvements

• ROU-4652 / RPM-4580 - Fixed an issue that caused the Dropdown Column options not to update to the correct ones when the parent was edited.
  This occurred in a Grid with three Dropdown Dependency levels with options containing duplicated labels.
• ROU-4722 - Fixed an issue that caused a console error to appear when trying to open a dependent Dropdown Column cell without any option available.
  This occurred when two Dropdown Columns were dependent on each other and the corresponding parent Dropdown Column cell was empty.
• ROU-4765 / RPM-4716 - Fixed an issue that caused the GetChangedLines client action to detect a change when a Dropdown cell returned to its original value.
• ROU-4768 - Fixed an issue that caused the OnCellValueChange to return the Dropdown labels options instead of the Dropdown values.
  This occurred when using the SetCellData client action to edit a cell value.
• ROU-4827 - Fixed an issue that caused a pencil icon to override the checkbox when editing a cell in a Grid with the Row Checkbox feature enabled.
• ROU-4829 / RPM-4830 - Fixed an issue that caused the GetChangesLines client action to return the HasInvalidLines property set to True when there were no invalid rows in the Grid.
  This occurred when using the MarkChangesAsSavedByKey client action with the ForceCleanInvalids parameter set to True.
• ROU-4871 / RPM-4874 - Fixed an issue that caused the Dirty Mark to appear in an Action Column inside a Group Column.
  This occurred when a new row was added to a Data Grid.

Release of version 2.15.0 (2024-04-15)

What's New

• ROU-4827 - Updated Wijmo library to version 5.20241.9 (2024v1).

Fixed Issues and Improvements

• ROU-4652 / RPM-4580 - Fixed an issue that caused the Dropdown Column options not to update to the correct ones when the parent was edited.
  This occurred in a Grid with three Dropdown Dependency levels with options containing duplicated labels.
• ROU-4722 - Fixed an issue that caused a console error to appear when trying to open a dependent Dropdown Column cell without any option available.
  This occurred when two Dropdown Columns were dependent on each other and the corresponding parent Dropdown Column cell was empty.
• ROU-4765 / RPM-4716 - Fixed an issue that caused the GetChangedLines client action to detect a change when a Dropdown cell returned to its original value.
• ROU-4768 - Fixed an issue that caused the OnCellValueChange to return the Dropdown labels options instead of the Dropdown values.
  This occurred when using the SetCellData client action to edit a cell value.
• ROU-4827 - Fixed an issue that caused a pencil icon to override the checkbox when editing a cell in a Grid with the Row Checkbox feature enabled.
• ROU-4829 / RPM-4830 - Fixed an issue that caused the GetChangesLines client action to return the HasInvalidLines property set to True when there were no invalid rows in the Grid.
  This occurred when using the MarkChangesAsSavedByKey client action with the ForceCleanInvalids parameter set to True.
• ROU-4871 / RPM-4874 - Fixed an issue that caused the Dirty Mark to appear in an Action Column inside a Group Column.
  This occurred when a new row was added to a Data Grid.

ODC Release of version 2.14.0 (2024-01-06)

What's New

• ROU-4407 - A new parameter ExternalURL was added and allows it to redirect to an external URL on an ActionColumn, using a URL from data or a fixed URL. If the ExternalURL is being defined, the click event will not be triggered.
  This feature will only be used when the ElementType is a Link.
• ROU-4659 - Now, it’s possible to use the SetColumnFilterOptions for the Number, Currency, Checkbox, Date and DateTime columns.
  For the Number, Currency, Date, and DateTime Column, the Options List must be formatted according to the displayed data.
  Example: in the case of a Number column where values are presented as “$99.90” the options should be aligned with this format (“$99.90" rather than “99.9”).
• ROU-4689 - Now, when a Column’s width configuration is changed in runtime its layout width will be preserved.

Fixed Issues and Improvements

• ROU-3712 / RPM-4244 - Fixed an issue that caused the Data Grid to fail from triggering the OnCellValueChange event when changing a DropdownColumn cell’s option for a different option with the same label.
• ROU-4588 - Updated the GetChangedLines client action’s description to bring visibility to its usage inside the column’s OnCellValueChange event.
• ROU-4658 - Improved deployment performance by optimizing static entities,
  Now, all non-translated static entities were set to have Use Translations = No.
  This update is intended to optimize performance and mitigate the limitations on the previous asset version for the Oracle databases, where the customer needed to ensure they are in at least Oracle 12.2. No adverse side effects are anticipated.
• ROU-4660 - Now, the Data Grid will change its state to “no data” when a filter is applied and doesn’t have any matching record. In this situation, the content of NoResults_Placeholder is shown.
• ROU-4662 - Now, the client actions GetCurrentPage, GetRowNumberByKey, GetSelectedRowsCount, GetSelectionAverage, GetSelectionCount, GetSelectionMax, GetSelectionMin, and GetSelectionSum, will return -1 when they fail.
  When one of these actions is used and fails, beyond the Success = false, the value return will be -1 instead of 0.
• ROU-4691 - Fixed an issue that caused the filter’s column to not display the filtered condition values correctly.
  This occurred when setting a filter to the CurrencyColumn using the FilterByCondition client action.
• ROU-4695 / RPM-4619 - Fixed an issue that caused the ActionColumn not to show commas delimitation properly.
  This occurred when LongInteger, Integer and Decimal values were being set.
• ROU-4702 - Fixed an issue in the client actions FilterByCondition and FilterByValue that were not allowing filtering of the Date/DateTime columns by a null date.
• ROU-4710 - Fixed an issue that caused the filters not to be set to the correct column when using the FilterByCondition and FilterByValue client actions. This occurred when there were two columns with the same binding on the same Grid.

Release of version 2.14.0 (2024-02-05)

What's New

• ROU-4407 - A new parameter ExternalURL was added and allows it to redirect to an external URL on an ActionColumn, using a URL from data or a fixed URL. If the ExternalURL is being defined, the click event will not be triggered.
  This feature will only be used when the ElementType is a Link.
• ROU-4659 - Now, it’s possible to use the SetColumnFilterOptions for the Number, Currency, Checkbox, Date and DateTime columns.
  For the Number, Currency, Date, and DateTime Column, the Options List must be formatted according to the displayed data.
  Example: in the case of a Number column where values are presented as “$99.90” the options should be aligned with this format (“$99.90" rather than “99.9”).
• ROU-4689 - Now, when a Column’s width configuration is changed in runtime its layout width will be preserved.

Fixed Issues and Improvements

• ROU-3712 / RPM-4244 - Fixed an issue that caused the Data Grid to fail from triggering the OnCellValueChange event when changing a DropdownColumn cell’s option for a different option with the same label.
• ROU-4588 - Updated the GetChangedLines client action’s description to bring visibility to its usage inside the column’s OnCellValueChange event.
• ROU-4658 - Improved deployment performance by optimizing static entities,
  Now, all non-translated static entities were set to have Use Translations = No.
  This update is intended to optimize performance and mitigate the limitations on the previous asset version for the Oracle databases, where the customer needed to ensure they are in at least Oracle 12.2. No adverse side effects are anticipated.
• ROU-4660 - Now, the Data Grid will change its state to “no data” when a filter is applied and doesn’t have any matching record. In this situation, the content of NoResults_Placeholder is shown.
• ROU-4662 - Now, the client actions GetCurrentPage, GetRowNumberByKey, GetSelectedRowsCount, GetSelectionAverage, GetSelectionCount, GetSelectionMax, GetSelectionMin, and GetSelectionSum, will return -1 when they fail.
  When one of these actions is used and fails, beyond the Success = false, the value return will be -1 instead of 0.
• ROU-4691 - Fixed an issue that caused the filter’s column to not display the filtered condition values correctly.
  This occurred when setting a filter to the CurrencyColumn using the FilterByCondition client action.
• ROU-4695 / RPM-4619 - Fixed an issue that caused the ActionColumn not to show commas delimitation properly.
  This occurred when LongInteger, Integer and Decimal values were being set.
• ROU-4702 - Fixed an issue in the client actions FilterByCondition and FilterByValue that were not allowing filtering of the Date/DateTime columns by a null date.
• ROU-4710 - Fixed an issue that caused the filters not to be set to the correct column when using the FilterByCondition and FilterByValue client actions. This occurred when there were two columns with the same binding on the same Grid.

ODC Release of version 2.13.0 (2023-11-09)

What's New:

• Now, we can use the new Image Column block to render image fields in the Data Grid.

Fixed Issues and Improvements

• Updated Wijmo library to version 5.20231.908-RC (2023).
• Improved the Undo/Redo actions on Safari to respond to the default key combination for MacOS devices. Now, use Command+Z to undo an action and Shift Command+Z to redo an action.
• Fixed an issue that caused a console error when the ESC key was pressed twice in the Data Grid.This occurred when starting editing a cell and then pressing the ESC key twice to cancel a cell edition.
• Fixed an issue that caused the Data Grid to not allow the frozen column resizing.This occurred when a frozen column was resized to the maximum width possible.
• Fixed an issue that caused the undo action to not restore all the dropdown cell values when the Dropdown Column has a dropdown dependency.This occurred when multiple cells of the parent Dropdown column were selected, and deleted, and then the undo action was performed.
• Fixed an issue that caused a runtime error to be thrown when using the GetChangedLines client action. This occurred when calling the GetChangedLines client action after adding, removing, and adding a row again.
• Now, when setting DynamicHeight = True the client action SetColumnWordWrap the header will also receive the same behaviour.
• Fixed an issue that was causing the column cells and headers not to have the proper dimensions. This occurred when using the SetColumnWordWrap client action on a column.
• Fixed an issue that caused the OnCellValueChange event not to be triggered when using the BackSpace and Delete keys to erase cell data values.
• Fixed an issue that prevented the frozen columns from being resized when they had their maximum width.
• Fixed an issue that caused the Dropdown Columns to trigger the OnCellValueChange event twice.
• Fixed an issue that caused the Dropdown Columns to trigger the OnCellValueChange even when no change was performed.
• Fixed an issue that caused the OnCellValueChange event of the Dropdown Columns to return the wrong value for the OldValue output parameter.This occurred when one Dropdown column had a dependency on another and the parent Dropdown value changed or an undo action was performed.
• Fixed an issue that caused the custom tooltip to be assigned to the wrong Column Header. This occurred when the Data Grid had a Column Group.

Release of version 2.13.0 (2023-10-30)

What's New:

• ROU-4182 - Now, we can use the new Image Column block to render image fields in the Data Grid.
  Check the documentation for more information.

Fixed Issues and Improvements:

• ROU-4528 - Updated Wijmo library to version 5.20231.908-RC (2023).
• Improved the Undo/Redo actions on Safari to respond to the default key combination for MacOS devices. Now, use Command+Z to undo an action and Shift Command+Z to redo an action.
• ROU-4442 - As mentioned in the release notes of version 2.12.1, the module OutSystemsDataGrid_Resources was removed from the OutSystems Data Grid application since the language resources were previously moved to OutSystemsDataGrid.
  This should have no impact on the consumer applications. For consistency reasons, since the platform mechanisms don’t remove the OutSystemsDataGrid_Resources module, you can manually remove it to avoid future conflicts.
• ROU-4214/RPM-3849 - Fixed an issue that caused a console error when the ESC key was pressed twice in the Data Grid.
  This occurred when starting editing a cell and then pressing the ESC key twice to cancel a cell edition.
• ROU-4380 - Fixed an issue that caused the Data Grid to not allow the frozen column resizing.
  This occurred when a frozen column was resized to the maximum width possible.
• ROU-4439 - Fixed an issue that caused the undo action to not restore all the dropdown cell values when the Dropdown Column has a dropdown dependency.
  This occurred when multiple cells of the parent Dropdown column were selected, and deleted, and then the undo action was performed.
• ROU-4467 - Fixed an issue that caused a runtime error to be thrown when using the GetChangedLines client action.
  This occurred when calling the GetChangedLines client action after adding, removing, and adding a row again.
• ROU-4472 - Now, when setting DynamicHeight = True the client action SetColumnWordWrap the header will also receive the same behaviour.
• ROU-4476 - Fixed an issue that was causing the column cells and headers not to have the proper dimensions. This occurred when using the SetColumnWordWrap client action on a column.
• ROU-4481/RPM-3916 - Fixed an issue that caused the OnCellValueChange event not to be triggered when using the BackSpace and Delete keys to erase cell data values.Fixed an issue that prevented the frozen columns from being resized when they had their maximum width.
• ROU-4519 - Fixed an issue that caused the Dropdown Columns to trigger the OnCellValueChange event twice.
• Fixed an issue that caused the Dropdown Columns to trigger the OnCellValueChange even when no change was performed.
• Fixed an issue that caused the OnCellValueChange event of the Dropdown Columns to return the wrong value for the OldValue output parameter. This occurred when one Dropdown column had a dependency on another and the parent Dropdown value changed or an undo action was performed.
• ROU-4571 - Fixed an issue that caused the custom tooltip to be assigned to the wrong Column Header. This occurred when the Data Grid had a Column Group.

ODC Release of version 2.12.1 (2023-07-26)

What's New:

• Created a new client action called SetNumberAggregateConditionalFormatting to allow conditional formatting rules to be applied to a Number/Currency columns aggregated.

• Now, is possible to save and load the state of a Grid with frozen columns using the SetViewLayout and GetViewLayout client actions.

• Updated Wijmo library to version 5.20231.888 (2023 v1).

• Now, the OutSystems Data Grid has a new supported language French-Canada (fr-CA).

Fixed Issues and Improvements:

• Fixed an issue that caused the GroupColumn to raise an error when IsCollapsed started as true. This occurred due to a breaking change introduced by Wijmo library version 5.20231.888 (2023 v1).

• Fixed an issue that caused the GetSelectedRowsData action to not return the correct value when using a column filter.
  This occurred when getting the GetSelectedRowsData result after selecting all the cells in the Grid using the Ctrl+A key and then adding a column filter.
  Now, the GetSelectedRowsData returns the correct data considering the filter applied.

• Fixed an issue that caused the GetChangedLines client action to detect a changed line when no change was performed.
  This occurred when, in an empty row, the user started editing an empty cell and then finish editing it without performing any changes.

• Fixed an issue that caused the SetRowAsSelected client action to not select the rows properly. This occurred when the SetRowAsSelected client action was used in a Grid with Row Checkboxes.
  Now, the SetRowAsSelected client action can be used for both Grids with and without Row Checkboxes.

• Fixed an issue that caused the Data Grid to log an error in the Developer's Tools console.
  This occurred when hovering the Data Grid row that had aggregated values and when a filter was applied letting the Grid empty.

• Improved the client action ClearFilter to trigger the OnFiltersChange event so that it’s consistent with the other filter APIs.

• Fixed an issue on the Action Column that was causing the cells to be marked as dirty when the text coming from another column is edited.
  Now, when the text is edited, the action columns will not be marked as dirty.

• Fixed an issue that caused the OnMenuToggle event from the ContextMenu block to return the block identifier instead of the (internal) uniqueId.

• Fixed an issue that caused the SetCurrentPage client action to throw an error in a success scenario. This occurred when SetCurrentPage was being called successfully but the consumer was implementing logic depending on the success value of the return since the functionality itself was working as expected.

• Fixed an issue on the GetChangesInGrid API that was returning the internal object __osRowMetadata when returning lines with Errors.

• Fixed an issue that caused the ContextMenu to trigger the OnMenuToggle event twice when opening.

• Improved the Grid’s Row and Column header's accessibility.

• Now, it is possible to focus on Row and Column headers using the keyboard.

• Fixed an issue that caused the ApplyRowValidation client action not to apply the correct validation for Group columns.
  This occurred when a new row was added to the Grid with mandatory columns in the Group Column and the ApplyRowValidation client action was called.

• Fixed an issue that caused the ApplyRowValidation client action to incorrectly invalidate Group Rows.
  This occurred when a column was added to the Grid’s Group Panel and the ApplyRowValidation client action was called for the Group Row.

• Fixed an issue that caused the client actions FilterByCondition and FilterByValue to not work as expected when used on a CheckboxColumn.
  This occurred when the client actions FilterByCondition or FilterByValue were used to filter a CheckboxColumn based on a boolean value.

• Fixed an issue that caused empty text values not to be mapped when using a Dropdown Column.
  This occurred when the DropdownOptionList of Dropdown Columns contained an empty value to be mapped to a specific label.

• Fixed an issue that caused empty text values not to be returned in Data client actions (GetRowData, GetChangedLines, etc). This occurred when the Grid data source contained empty text values.
  Now, the text values are returned as empty strings in these Data client actions.