Fixed Issues:

• Fixed issue with tab once IME was enabled.

• Fixed issue with cell disappears on Redo after Update cell with auto refresh disabled

Added functionalities:

• Created the new GridOS.ExternalAPI.afterGridInit method that gets fired when the grid has been initialized.

Fixed Issues:

• ExternalAPI AddRow method now triggers dirty marks on new rows.

• Fixed issue with Group Panel on AutoGenerated grids.

• Fixes on undo/redo functionality,

• Fixed issue with AdvancedConfigs parameter on Number column.

Other:

• Wijmo update 5.20203.748

• Changed Modules and Application names:

  • Apps:

    • From Data Grid to Data Grid Web

    • From Grid Sample to Data Grid Sample Web

  • Modules:

    • From DataGridComponent to  DataGridWeb

    • From DataGridSample to DataGridSampleWeb

Fixed Issues:

• Fixed a quick editor bug on currency columns

Other:

• Wijmo update 5.20202.732

Added functionalities:

• Added feedback for sending invalid cells

Fixed Issues:

• Fixed focus on rows after sorting columns
• Improved validation on related columns
• Fixed Undo/Redo during edition of cells
• Improved UX on dropdown columns
• Revamped the Tab key navigation on the grid
• Fixed the “MatchTypeBeginWith” property on dropdown columns
• Fixed Input Method Editors (IME) on cell edition for other languages
• Fixed tooltip not displaying when the content of the cell starts with "#"
• Fixed edition for multiple lines (alt + enter)
• Fixed export to excel when there is only one cell selected
• Improved sort on columns that contain blank cells
• Refactored cell edition
• Changed the format for default values on date columns
• Improved the usability on typing values on cells of numeric columns
• Fixed Numeric and Dropdown columns to allow the delete/backspace to clear the value
• Fixed behavior of sorting after editing a GridColumnText cell

Other:

• Wijmo update 5.20202.724
• Allowed the ‘autoRowHeights’ property for rows

Fixed Issues:

• Fixed some dirty mark behaviors after undo/redo

• Removed edition from Grouped column header

• Fixed ellipsis on headers for IE

• Removed edition for removed rows

Fixed Issues:

• Standardized blank and undefined values for Group Panel

• Added new parameter (SendAllSelectedRows) to allows you to select dirty cell and enable “Send Selected” button 

• Added new parameter (IsLoadingEmpty) in AdvancedFormats to allow user to load an empty grid

• Fixed searching engine to allow “#” character

• Fixed behavior when user sets value in the "GridColumnLink" to multiple input params 

• Fixed edition on cells from Frozen Columns

Fixed Issues:

• Fixed the message on exporting to Excel

• Custom Context Menu can be opened without focus on an empty grid

• Selection by row number with CheckboxSelection disabled

• Selection formulas calculation fix

• Selection using control fixed behavior

• Filter Type minor fix when there is no filter type associated

• Tooltip fix when the string values were large

• Fixed error when loading grid with no data

• Fix on Filtering by values on Dropdown columns

Other:

• Wijmo update to 5.20201.680

Fixed Issues:

• Selection formulas calculation fix

• Selection using control fixed behavior

• Filter Type minor fix when there is no filter type associated

• Tooltip fix when the string values were large

• Fixed error when loading grid with no data

• Fix on Filtering by values on Dropdown columns

• Wijmo update to 5.20201.680

Added functionalities:

• Translation are now included in the DataGrid component

• Mechanism to set behavior and handle feedback messages from DataGrid

• A new input parameter was added inside Grid Container (SanitizeInputValues). When it is set to true, we will sanitize the cell values to prevent XSS attacks

• Added advanced format parameter to specify if Grid Configuration should be loaded from the server. In cases that don’t require configuration, setting this parameter to false will improve the performance

• Large numbers validation in Number Column

• Improvement against XSS vulnerability

Fixed Issues:

• Fixed column group mapping

• Fixed issue for cells being marked as dirty after cancel edition

• Quick fix for LoadConfigs

• Fix hyperlink in export for Excel

• Fix exporting excel/csv in all pages

• Fix paste feature into Number column

• Fix distinct rowId for inserted rows

Added functionalities:

• Large numbers validation in Number Column

• Improvement against XSS vulnerability

• Quick fix for LoadConfigs

• Fix hyperlink in export for Excel

• Fix exporting excel/csv in all pages

• Fix paste feature into Number column

• Fix distinct rowId for inserted rows

Added functionalities:

• Translation are now included in the DataGrid component

• Mechanism to set behavior and handle feedback messages from DataGrid

• A new input parameter was added inside Grid Container (SanitizeInputValues). When it is set to true, we will sanitize the cell values to prevent XSS attacks

• Added advanced format parameter to specify if Grid Configuration should be loaded from the server. In cases that don’t require configuration, setting this parameter to false will improve the performance

• Fixed column group mapping

• Fixed issue for cells being marked as dirty after cancel edition

Added functionalities:

• It is now possible to define the steps for Number columns

  • Added the AdvancedConfigs so you can map cell properties from wijmo

• Groups can now be collapsed or expanded by default

• Option to have a feedback message displayed on first load with total number of records

• Select and Date/DateTime columns allow the delete/backspace to clear the value

• Column index is automatically filled in the Freeze Column context menu

• ‘Undefined’ values are now validated and set to the columns’ default

• Row headers’ display was improved to not break from misalignment

• Date/Datetime columns now are affected by culture selection

• DateTime icons now display correctly with OSCellRenderer functions

• After server side validation red error mark is kept

• ‘Popup’ windows like calendar or Select options are correctly displayed with position fixed set to the grid and when used on Modal or Popup widgets

• Row index adjusts to the length of its content

• Blank values are now displayed correctly after sorting

• Dirty cells keep their mark if changes are canceled

• Group Panel now displays correctly if the grid width is changed

• Row headers now have fixed width

• Buttons and ‘Dirty Mark’ behavior was unified to only change status if changes were made

• “Paste Ctrl+V" option from Context Menu is no longer available

Added functionalities

• GridColumnSelect

  • Sorting and filtering Select columns by Label

  • Default values are correctly displayed when inserting a new row

  • Export to Excel and CSV fixes

Fixed issues

• Improvement to the UX to freeze the columns of Grid

• Loading overlay no longer disappears when resizing the browser window

• Grouping columns in IE now works as expected

• Row index column adjusts automatically

• Fixes to validation methods

• Filter Icon no longer disappears when sorting ungrouped headers

• Deleted rows cannot be edited

• Fixes to the layout when using the column selection menu and unhiding hidden columns

You can now export to Excel much faster, without the styles.
Use the context menu command Excel Export (w/o styles) in the Export option.

• Improvement to GridColumnDateTime to avoid showing the null date (1900-01-01).

• Option Copy Selected Rows was removed from the context menu.

• The Copy and Copy with headers options, now copy the content of the:

  • selected cell, if you select a single cell

  • selected range, if you select a range of cells within the grid

  • selected rows, if you select rows with the row index or the row’s selection checkbox

• Selection of cells in the copy and export methods now have similar functionality:

  • A range of 4cols x 2rows + 2col x 1row is copied/exported as the biggest range in the selection: 4cols x 3rows

  • The same range + a full row selection is exported/copied as full row (total cols) x 4 rows

• We improved the Dirty state and the error display feature.

• Only one Header label is shown when there are groups and when you use Copy with headers.

• Decimal values are now rounded correctly in the Excel export.

• Column selection menu closes properly.

• We fixed several selection issues: grid losing selection when clicking the scrollbars, when inserting the selected rows, and when selecting multiple rows while holding Ctrl and clicking the first selection.

• Now after searching, the selection is no longer in focus and the line number selection is cleared.

Fixed Issues:

• Fixed CSS rule that prevented Link, Upload, Download and Advanced columns from being clicked.

Added functionalities:

• Added support to filter Link by label

• Added ‘Renderer’ parameter to GridContainer to allow customization at the grid level

  • Kept the CellRenderer parameter in columns for column customization

• Export to CSV now exports the value of combobox columns instead of ID
  
  

Fixed Issues:

• Tooltip misbehaviour with validations

• Fixed selection jump when rows were deleted

• Fixed selection of combobox values between rows

• Fixed multiple headers when exporting to CSV

• Fixed server-side validation for checkbox columns

Others:

• Added ‘original_os_RowId’ attribute to the DataRow structure.

  • Set this value with the same value of os_RowId to identify to which row the validation applies to when new lines are created.

• Context menu now closes when clicking anywhere outside it

• Deprecated ‘SuppressMenu’ and ‘FilterSetType’ parameters

  • Use the new FilterType:

    • Defaults to "Condition".
      Until the "SuppressMenu_DEPRECATED" is not removed, to avoid breaking changes, the "FilterType" will only be applied when that option is set to false.

Added functionalities:

• Added support to JSON with a hierarchical structure

• Added selection blocks that display Count, Average, Maximum, Minimum and Summation

  • Added MultiSelection and SingleSelection event handlers to achieve the same behaviour with AjaxRefresh

• Added the ability to show custom tooltips on hovering a header column

• Added ExportingMessage parameter to show overlay message while exporting

• Deprecated FilterSetType and SuppressMenu parameters

  • Added the FilterType parameter as a replacement.
    
    

Fixed Issues:

• Added sample usage of showing the summation while grouping columns

• Fixed rendering issue on IE after the page was refreshed

• Fixed multiple export issues

  • Characters are no longer garbled on CSV output

  • Export with row index when HasAutoNumbering is True instead of a blank column

• Fixed Undo/Redo issues

• Fixed CSS issues with filter and sort icons

Fixed Issues:

• Fixed issue that prevented data from loading.
• Fixed issue that prevented deleting selected rows after Undo.

Added functionalities:

• Added Undo/Redo capabilities

  • Undo/Redo “Insert Blank Rows”

  • Undo/Redo “Insert Selected Row(s)”

  • Undo/Redo “Remove Selected Rows”

Fixed Issues:

• Improved the behaviour of marking a cell as dirty when it has a checkbox.

• Switching from lowercase to uppercase makes a cell dirty. 

• Improved the cell’s update behaviour, regardless of it being dirty or not.

• Fixed the display of the “dirty mark” after server-side validation.

• Fixed the behaviour of tooltips on the header after scrolling and column resizing. 

• GridId attribute’s length was increased. 

• Changed method to update the dirty state after the cell is changed.

Bug Fixes

• Fixed reference issue that prevented column sorting.

Added functionalities:

• The Feedback Message can now be set in the body of the JSON structure for the REST APIs. This feature supports the old structure as well and the DataGridExample was updated to use the new structure.

• GridColumnSelect can now handle blank elements for data reset.

• Added the Context Menu support when there are no results.

• Improved usability for showing all records.

• Fixed the capabilities of UndoStack over DataGrid elements.

• Fixed an issue regarding the Save capabilities of DateTime objects in the database.

• Improved usability on Action Buttons enabled/disabled status.

• Fixed a display issue when the “Loading” message would disappear before the results were shown.

• Fixed an issue with cell validation after pressing ctrl+z/y and ctrl+c/v.

• Fixed an issue that prevented saving data for a specific date format.

• Fixed an issue that prevented data from being updated with SendSelectedRows and line number selection after filtering.

• "SendChanged"/"SendSelected" actions now trigger the validation for dirty cells.

Added functionalities:

• "GridColumnNumber" now supports decimal numbers.

Fixed Issues:

• Increased "GridId" parameter length to 200 characters.
• Fixed an issue that prevented the "SuppressMenu" option to work as expected.
• Dirty items styles are now removed after SendSelected or SendChanged are used.
• Improved the styles of selected cells to have an overlay instead of replacing cell colors.
  
  

Added functionalities:

• Row selection without checkbox has the same options in the Context Menu.

Fixed Issues:

• Added validation on pasting.
• Non-editable Date columns no longer display the "▼" symbol.
• Select columns no longer transform the selected value to lowercase.

Fixed Issues:

• Removed rows won’t be removed immediately from the list. Instead they will look greyed out and only be removed once pressing the “SendRemovedRowsButton”.
• Removed the styles of a line that has had its checkbox checked. The style of “selected” only happens upon a click on the line to avoid false expectations when copying values
• Clicking on the dropdown arrow from a select column directly is now possible
• Fixed issues when the filtering was set as false in the Grid
• There will be no longer an indication of dirty cell when double clicking and not changing its value
• Changed the style of the dirty cell (from red to black) to avoid confusion with invalid values
• Added style to the action “SendRemovedRowsButton” to look disabled when there are no items removed
• When a Column’s value changes depending on a Select column, it will switch to the default first value of the new value
• Refactored the validation of the getDateFormat method to prevent an error when the format changed from dd-MM-yyyy to MM-dd-yyyy

Release for OutSystems 11

Fixed Issues:

• Standardized blank and undefined values for Group Panel

• Added new parameter (SendAllSelectedRows) to allows you to select dirty cell and enable “Send Selected” button 

• Added new parameter (IsLoadingEmpty) in AdvancedFormats to allow user to load an empty grid

• Fixed searching engine to allow “#” character

• Fixed behavior when user sets value in the "GridColumnLink" to multiple input params 

• Fixed edition on cells from Frozen Columns

• Fixed the message on exporting to Excel

• Custom Context Menu can be opened without focus on an empty grid

• Selection by row number with CheckboxSelection disabled

• Selection formulas calculation fix

• Selection using control fixed behavior

• Filter Type minor fix when there is no filter type associated

• Tooltip fix when the string values were large

• Fixed error when loading grid with no data

• Fix on Filtering by values on Dropdown columns

Other:

• Wijmo update to 5.20201.680

Added functionalities:

• Translation are now included in the DataGrid component

• Mechanism to set behavior and handle feedback messages from DataGrid

• A new input parameter was added inside Grid Container (SanitizeInputValues). When it is set to true, we will sanitize the cell values to prevent XSS attacks

• Added advanced format parameter to specify if Grid Configuration should be loaded from the server. In cases that don’t require configuration, setting this parameter to false will improve the performance

• Fixed column group mapping

• Fixed issue for cells being marked as dirty after cancel edition

Added functionalities:

• It is now possible to define the steps for Number columns

  • Added the AdvancedConfigs so you can map cell properties from wijmo

• Groups can now be collapsed or expanded by default

• Option to have a feedback message displayed on first load with total number of records

• Select and Date/DateTime columns allow the delete/backspace to clear the value

Fixed Issues:

• Column index is automatically filled in the Freeze Column context menu

• ‘Undefined’ values are now validated and set to the columns’ default

• Row headers’ display was improved to not break from misalignment

• Date/Datetime columns now are affected by culture selection

• DateTime icons now display correctly with OSCellRenderer functions

• After server side validation red error mark is kept

• ‘Popup’ windows like calendar or Select options are correctly displayed with position fixed set to the grid and when used on Modal or Popup widgets

• Row index adjusts to the length of its content

• Blank values are now displayed correctly after sorting

• Dirty cells keep their mark if changes are canceled

• Group Panel now displays correctly if the grid width is changed

Others:

• Row headers now have fixed width

• Buttons and ‘Dirty Mark’ behavior was unified to only change status if changes were made

• “Paste Ctrl+V" option from Context Menu is no longer available

For the remaining notes check the notes from:

• Version 2.1.11
• Version 2.1.10
• Version 2.1.9
• Version 2.1.8
• Version 2.1.7
• Version 2.1.6
• Version 2.1.5
• Version 2.1.4

Added functionalities:

• The Feedback Message can now be set in the body of the JSON structure for the REST APIs. This feature supports the old structure as well and the DataGridExample was updated to use the new structure.

• GridColumnSelect can now handle blank elements for data reset.

• Added the Context Menu support when there are no results.

Fixed Issues:

• Improved usability for showing all records.

• Fixed the capabilities of UndoStack over DataGrid elements.

• Fixed an issue regarding the Save capabilities of DateTime objects in the database.

• Improved usability on Action Buttons enabled/disabled status.

• Fixed a display issue when the “Loading” message would disappear before the results were shown.

• Fixed an issue with cell validation after pressing ctrl+z/y and ctrl+c/v.

• Fixed an issue that prevented saving data for a specific date format.

• Fixed an issue that prevented data from being updated with SendSelectedRows and line number selection after filtering.

• "SendChanged"/"SendSelected" actions now trigger the validation for dirty cells.

Added functionalities:

• Row selection without checkbox has the same options in the Context Menu.

Fixed Issues:

• Added validation on pasting.
• Non-editable Date columns no longer display the "▼" symbol.
• Select columns no longer transform the selected value to lowercase.

Fixed Issues:

• Removed rows won’t be removed immediately from the list. Instead they will look greyed out and only be removed once pressing the “SendRemovedRowsButton”.
• Removed the styles of a line that has had its checkbox checked. The style of “selected” only happens upon a click on the line to avoid false expectations when copying values
• Clicking on the dropdown arrow from a select column directly is now possible
• Fixed issues when the filtering was set as false in the Grid
• There will be no longer an indication of dirty cell when double clicking and not changing its value
• Changed the style of the dirty cell (from red to black) to avoid confusion with invalid values
• Added style to the action “SendRemovedRowsButton” to look disabled when there are no items removed
• When a Column’s value changes depending on a Select column, it will switch to the default first value of the new value
• Refactored the validation of the getDateFormat method to prevent an error when the format changed from dd-MM-yyyy to MM-dd-yyyy

Renamed extensions and UI flows