IMPORTANT UPDATE
[Thursday, May 15, 2025] RealGrid2 2.9.0 Update Important
- Added ExportOptions.exportMemo property to add notes to cells when exporting to Excel
- Fixed an error that occurred in the grid module when using
ssr
in node21 or later versions - Improved so that the position of the list changes when scrolling occurs in the upper element of the grid when showing a list of DropDownCellEditor or DateCellEditor
- Improved so that copy/paste is possible when a physical keyboard is connected in a mobile environment
- Enable drag and drop by pressing the pointer on the rowIndicator of the selected row. Add property rowIndicator.draggableSelectedRows
[Thursday, March 20, 2025] RealGrid2 2.8.9 Update Important
- Added treeTemplateOptions to display the first column of treeView in
html
format - Added DisplayOptions.selectionRemovable property to deselect when DisplayOptions.selectionMode is
extended
- Added
editResult
argument to change the pasted value in GridBase.onCellPasting - Added autoFilter when the filter window is displayed Added FilterAutomatingOptions.userFilterPosition property to display filter at the top or bottom
- Added ExportOptions.coreproperties property to change the properties of the Excel file when exporting to Excel
- Added DisplayOptions.altSelectAndImmedinateDrag property to make the cell be in a
drag&drop
state when pressing thealtKey
when EditOptins.movable istrue
[Thursday, January 9, 2025] RealGrid2 2.8.8 Update Important
- Added showMessage to allow users to display arbitrary messages
- Improved the phenomenon where an error occurred intermittently when the number of rows changed or hintDelay was used when displaying tooltips.
[Thursday, December 19, 2024] RealGrid2 2.8.7 Update Important
- Improved export to Excel even when dynamic style is specified as inline using ColumnStyleObject.style
- Improved so that contextMenu can be used using
longPress
inIos
- Improved speed when retrieving non-duplicated values using Provider.getDistinctValues
- Added
coordianteByBody
argument to interpret the input coordinates based on the body when retrieving cells using GridBase.mouseToIndex - When deleting another row when the focus is on the last row Improved the phenomenon where the onCurrentRowChanged event does not occur
[Thursday, October 24, 2024] RealGrid2 2.8.6 Update Important
- Fixed the phenomenon of scrolling to the first row after DataProvider.addField is executed
- Added TreeOptions.expandWhenSetData property to display nodes in an expanded state when data is loaded in TreeView
- Added SortingOptions.sortDataRow property to prevent sorting by
dataRow
when values are the same during sorting - Fixed the case where an incorrect date is entered in DateCellEDitor so that it is changed to blank.
[Thursday, September 12, 2024] RealGrid2 2.8.5 Update Important
- Improved error message output when license error occurs
- Changed min and max value to be applied after keyboard editing is completed in numberCellEditor
- Added exportOptions.compression and exportOptions.compressionLevel properties to specify whether to compress and the compression ratio when exporting to Excel
- Display
tooltip
only when only part of the text displayed in the header is displayed Added header.tooltipEllipsisOnly property - Added
data
argument so that data can be entered when adding a new row using beginInsertRow or beginAppendRow
[Thursday, August 8, 2024] RealGrid2 2.8.4 Update Important
- When lookupSourceId and labelField are set at the same time, if there is no value in
lookupSource
, it is improved to get the value fromlabelField
- Remove
CRLF
added at the end when copying from the grid - Add LiteralColumn to output a fixed value without being connected to DataField
- Add text property to specify the value displayed on the screen in styleCallback
- Added templateEvents property to connect
event
to element when displaying cell inHTML
format using TemplateCellRenderer - Improved so that
aria-hidden
related error message that occurs afterchrome
update is not displayed
[Thursday, June 27, 2024] RealGrid2 2.8.3 Update Important
- Added GridBase.showFilterSelector method to display the filter selection window.
- Added MultiCheckCellRenderer to select multiple
checkbox
orradio
- Added cut function when entering
Ctrl + x
- Improved the issue where userCellStyle applied to TreeView is not removed.
- Improved the phenomenon where
undo
does not work properly when rows are added or deleted usingremoveRow
,insertChildRow
, etc. of TreeView
[May 2024] RealGrid2 2.8.2 update important notes
- Added DisplayOptions.tooltipEllipsisOnly property to display tooltip only for cells in
ellipsis
state when displaying tooltip. - Added FilterAutomatingOptions.timeCategorize property to classify by hour/minute/second when using autoFilter.
- Fixed an error that occurred when calling the GridView.groupBy method after initializing fields and columns in row group state.
- Fixed the phenomenon of grid being distorted when fixedOptions.rowBarHeight is set to
0
- checkBar.toggleRadio property that clears the checked state when
radio
is clicked again when checkBar.exclusive istrue
addition
[March 2024] RealGrid2 2.8.1 update important notes
- Added
groupFocusLevel
property to specify the level of the group selected when groupFocusVisible istrue
. - Changed so that styleName set in footer is also added to the
foot
area of the rowIndicator or checkBar. - RowGroup.resetOriginVindex property that returns to the original position when a column in Row Merged Grouping is ungrouped addition
- Improved the phenomenon in which the fillWidth property set in the subcolumn of
groupLayout
is not applied when GridFitStyle isfill
.
[March 2024] RealGrid2 2.8.0 Update Important Notes
- Improved to add images in userCellsCallback
- Added sortingOptions.nullsOrder property to display
null
undefined
""
first or last when sorting. - listCallback and templateCallback, which are called when a list is displayed in the listEditor, checkList editor Improved to allow users to specify using /refs/Interface/DropDownCellEditor#templatecallback)
- Added viewMode property to allow only
year
ormonth
to be selected in DateCellEditor - Improved the phenomenon that when clicking when there is no focused cell in the grid, the focus goes to the first cell and then moves to the clicked cell.
- Add RealGrid.setDefault to apply defaultOption of grid
- Added RealGrid.setLicenseKey, which allows the license key to be stored in an environment variable and used.
- Added RealGrid.registerCustomRenderer to register CustomCellRenderer used in grid.
- Added RealGrid.setLocale to change the message used in the grid.
[November 2023] RealGrid2 2.7.2 update important notes
- Fixed an issue where an editor with a list does not work properly when EditOptions.commitWhenLeave is
true
. - Improved so that jszip module can be passed as an option when
excel export
- Improved to display even if there is a
-
value among the values of spark-column renderer
[October 2023] RealGrid2 2.7.1 update important notes
- Added
menu
andrightClick
parameters to GridBase.onContextMenuPopup event. - Improved to apply HandleVisibility.hovered
- Added addUserCellStyle to allow users to specify the style of cells.
- Improved UI for selecting date and time in dateEditor
- Modified so that the GridExportOptions.footer property is applied properly when exporting to Excel with the
footer
hidden.
[August 2023] RealGrid2 2.7.0 update important notes
- When combining cells horizontally using columnLayout.dataSpan, improvements have been made so that they can be combined even if the parent groups are different.
- Fixed an issue where
booleanFormat
was not applied properly when the field's dataType wastext
when connecting a field to the checkBar oftreeView
. - ColumnSummary.value, which can retrieve the value of ColumnSummary.valueCallback or ColumnSummary.expression Add #value) attribute
- Added DataDragOptions.dropOtherElement property to enable drag&drop to areas other than the grid.
- Improved scrolling behavior on mobile devices
- Removal of
formView
and deletion of related APIs
[May 2023] RealGrid2 2.6.3 Update Important Notes
- Changed so that the footer area is not covered when EmptyMessage is displayed.
- Added onWheel event, which is called when a mouse wheel event occurs.
- Fixed error related to
params
when downloadingexcel remote
- Added displayOptions.groupFocusVisible property that can display
focus
in groups. - When a row is moved using moveRow, getUpdatedCells is intermittently missing. phenomenon improvement
- Added DataColumn.filterSelectorWidth property to specify the width of the filter selector for each column.
- Fixed the issue where spanCallback is not applied when exporting to Excel.
- Added GridBase.resetFilters method to deactivate all active columnFilters.
[January 2023] Important notes on RealGrid2 2.6.2 update
- Fixed the issue where
itemIndex
anddataRow
of the onEditRowPasted event are incorrectly transmitted when pasting multiple rows in Treeview - Improved the phenomenon of values disappearing intermittently when selecting a searched item in searchEdit
Improved the phenomenon where the onEditSearch event occurs once more when entering
enter
. - Improved the phenomenon in which the grid becomes distorted when the height is set to
1
using setRowHeight - Added editOptions.currentChangingFirst property to ensure that the onCurrentChanging event is called before
commit
when moving to another cell after editing a cell. - Improved the phenomenon of
selection
being changed when clicking on the rowIndicator area when focus cannot be moved. - Improved the phenomenon in which the
exportStyleName
set in header is not applied properly when exporting to Excel. - Changed so that the editor does not disappear when returning
false
in onEditCommit
[January 2023] Important notes on RealGrid2 2.6.1 update
- onLayoutCollapsed, onLayoutCollapsing, onLayoutExpanded that occurs when a column is collapsed or expanded. , onLayoutExpanding event added Refer to Column Column
- When there are multiple grids on one screen, change the id of
checkBox
in checkBar so that it does not overlap. - Fixed an error that occurred in some browsers when exporting imageRenderer to Excel.
- When exporting to Excel, if there is a control code (0x00 ~ 0x1F) in the data, the control code is changed to a code that Excel can read and exported.
- Improved so that you can directly specify the style of the
tr
element of the row in rowStyleCallback - When searching using dataProvider.searchData, if there is only one row, the warp property is applied. Improving the phenomenon that does not work
[September 2022] Important notes on RealGrid2 2.6.0 update
- When using rowGroup, valueForGroupCallback has been added so that grouping can be done by referring to partial values of data or values of other fields. For more information, see Row group
- When a merged cell is clicked, change the clickData.itemIndex of the onCellClicked event to return the itemIndex of the actual clicked row rather than the first row of the merge cell.
- Changed so that the sortIcon of the column where DataColumn.sortable is false is not displayed when sortingOptions.handleVisibility is
always
. - Improved so that it does not enter the editing state when double-clicking the expander of treeView or the expander of mergeRowGroup.
- Improved the phenomenon in which the filter is not applied when clicking on the filter corresponding to
category
when autoFilter is set on a treeView column. - Fix error that occurs when fixedRow occupies the entire data area of the grid
[July 2022] RealGrid2 2.5.4 update important notes
- Speed improvement when entering large amounts of data into LocalTreeDataProvider
- Fixed the issue where getDisplayValues does not execute due to an error. Added useColumnName parameter to make the attribute name of the returned JSON object into a column name.
- New to the gridFixed an issue where the size of the grid returns to the size when it was first created when a row is entered or the size of the browser is changed.
- When performing validateCells of a grid with paging, the page visible on the screen Added
ignorePaging
parameter to also perform validation. - Improved the phenomenon of unchecking when clicking on a specific area when exclusive of checkBar is
true
.
[June 2022] Important notes on RealGrid2 2.5.3 update
- Add the
userCells
property to GridExportOptions so that strings can be output at the location specified by the user when Excel output. For more information, see [UserCells] Refer to Specified character output Added a function to set ‘Sheet Protection’ when Excel Output. For more information, see Excel Sheet Protection. - Improved the phenomenon of not being able to select cells when changing the size of the fixed column after setting fixedOptions.resizable to
true
.
[April 2022] RealGrid2 2.5.2 update important notes
- In numberEditor, the behavior is different when English is input and when Korean is input, but the behavior has been improved to be the same.
- When merging by referring to a column whose dataType is
object
, improved to use objectKey or objectCallback of the object column. - Improved so that DisplayOptions.syncGridHeight is applied even in the case of automatic row height
- Added checkLocation property to change the location of the checkBox when checkBar.headText is displayed. checkLocation property to change the spacing between checkBox and text. itemGap property added
[March 2022] Important notes on RealGrid2 2.5.1 update
- Improved to retrieve child nodes including child nodes from treeProvider.getJsonRow
- Added DisplayOptions.syncGridHeight property to display all searched data without vertical scrolling of the grid.
- Added
extended
status value to DisplayOptions.selectionMode to use multiple selection areas. For more information, see Demo - Added cell merging function for columns that refer to fields whose valueType is object
- Improved the phenomenon where the rowIndicator area and data area are misaligned when zooming in/out in Chrome-based browsers.
- Improved the phenomenon in which some areas of documentTitle and subTitle are not merged when exporting from treeView to Excel.
- Added the ability to export images to Excel. For more information, see Demo
- Load data using setRows or fillJsonData in dataProvider. Add valuesCallback, which is called when
- Improved the phenomenon in which the height of some rows is calculated incorrectly when using automatic row height when there are merged cells.
[January 2022] RealGrid2 2.5.0 update important notes
- Changed the method of calculating the width when the direction of the group layout is
vertical
and the child layout has only one column. - Added the ability to collapse or expand groupLayout. For more information, see Collapse group column.
- Fixed an error that occurred when using setValue within the dataProvider.onRowInserted event.
- Improved groupFooter.valueCallback from returning only number type to returning other types as well.
- Added the ability to move to the previous cell when pressing shift+enter.
- Improved the phenomenon in which individual heights are not set for the header of a fixed area when header.heights is specified and fixedColumn is set.
- Fixed an issue where values were not displayed in some groupFooters when row grouping and column grouping existed at the same time and fixedColumn was set.
[November 2021] RealGrid2 2.4.2 Update Important Notes
- Fixed an issue where the onCellClicked event occurs when multiple cells in a row are selected using drag.
- Improved the phenomenon of changing the column width to minCellWidth or less when changing the column width using the mouse.
- Fixed an issue where the onCellItemClicked event does not occur and the default action of the
a
tag is executed when the link renderer is used on a cell that is only partially displayed on the screen. - Fixed an error that occurred when calling the gridView.setAllCheck method when gridView.checkBar.exclusive is true.
- If a string is added in the form of a prefix to the selector in realgrid-style.css, add the stylePrefix property so that it can be applied when exporting to Excel.
[September 2021] RealGrid2 2.4.0 update important notes
- The gridView.onDataLoadComplated event, which is issued after data is loaded, has been added. For more information, see Rendering Complete Event.
- Fixed an issue where the displayOptions.defaultColumnWidth property was not applied.
- The column.header.edgeMark property has been added to display an edgeMark in the column header.
- SetRowStyleCallback has been improved to control the editability of rows. For more information, see Row Dynamic Style.
- An issue where the height of the footer did not change intermittently when there was a column group has been fixed.
- A feature has been added to limit input characters in the text editor. For more information, see Input Limit Editor.
- The border of the grid has been improved to be displayed when exporting to Excel.
- The hiddenColumns property has been added to display columns but hide them when exporting to Excel.
- Fixed an issue where rowGrouping could not be performed when column.movable was false.
- We have improved the phenomenon in which some rows are output as unmerged when exporting to Excel in row merge grouping mode.
[June 2021] RealGrid2 2.3.3 update important notes
- Corrected errors related to date interpretation in ISO Format
- Fixed an issue where
undefined
was displayed in cells with no value in some renderers in IE. - Fixed an issue where some cells intermittently disappear when merging in Chrome-based browsers
[May 2021] RealGrid2 2.3.2 update important notes
- When editOptions.updatable is false, editing is not possible when a row is committed, but has been changed to allow editing even after commit.
- The default value of column.editable has been changed to
undefined
. - editOptions.columnEditableFirst property has been added. If columnEditableFirst is true and column.editable is specified, then editOptions.editable is better than column.editableProperties are applied first.
- Fixed an error that occurred when inserting while treeView was filtered.
- The merge function of checkBar has been added. For more information, see Linking checkbars and data fields.
- The column.placeHolder property has been added to display content to be entered when there is no value in the cell. You can specify the style using column.placeHolderStyleName. For more information, see Place Holder.
- A step button has been added to numberEditor. For more information, see Number Edit Button.
- Fixed an issue where the progress bar was displayed abnormally when showProgress:true was applied when exporting a grid with page options applied to Excel.
[April 2021] RealGrid2 2.3.1 update important notes
- The issue of losing focus when clicking on an external input box when commitWhenLeave is true has been improved.
- Fixed an error that occurred due to font-family and font-size not being specified during export or settings such as inherit.
- The issue of not being able to find the group header with getGroupModel when it is not visible on the screen has been improved.
- The issue where copying does not work when there is no value in the editor in IE has been improved.
- The issue where sapnCallback and setCellStyleCallback are not applied when exporting has been improved.
[March 2021] RealGrid2 2.3.0 update important notes
- An error where columns using checkCellRenderer could not be edited when merged has been fixed.
- A class has been added to apply CSS to focused cells and rows.
- Improved to commit even if validation fails according to editOptions.commitLevel.
- Fixed an issue where checkBar was not exported when exporting to Excel.
- Fixed an issue where changing the editor in column.styleCallback was not applied.
- Fixed an error that occurred when clicking the filter icon after setting autoFilter to true for a column whose dataType is number.
- When changing ColumnLayout in groupBy state, groupBy has been changed to be released.
- A function has been added to allow users to specify rowspan and colspan when the footer, headerSummary, and groupFooter have multiple lines.
[December 17, 2020] RealGrid2 2.2.2 update important notes
- Improved the phenomenon of being visible in the filter selector even if ColumnFilter.visible is false.
- Improved the phenomenon where the filter icon is visible in ColumnHeader even if FilteringOptions.enabled is false.
- Add Column.filterable property. If filterable is false, the filter icon is not displayed in the header.
- Improved the phenomenon where the value corresponding to the label is not displayed even if lookupDisplay is true when exporting to Excel
- Fixed an error that occurred when checkBar.exclusive was set to true when creating a grid.
[December 10, 2020] RealGrid2 2.2.0 update important notes
- Improvements and errors related to Column Layout have been corrected.
- Improvements and errors related to layout have been corrected when exporting to Excel.
- If the name of the column is omitted, it has been modified to be created by replacing it with fieldName.
- ColumnFilter created using autoFilter has also been improved so that it can be selected/deselected using the API.
[September 18, 2020] RealGrid2 2.1.0 update important notes
- Autofilter performance has been improved and errors have been corrected.
- Excel multi-export function has been added.
- Excel DocumentTitle function has been added.
- When using a keyboard connected on a mobile device, the focus has been improved to move using the keyboard.
[August 7, 2020] RealGrid2 2.0.5 update important notes
- Whether or not each row is checked can be saved in the data field.
- A callback has been added to display the column buttons according to conditions.
- When there are many popupMenu items, the size has been limited and scrolling has been improved.
- Several exportGrid errors have been fixed.
[July 3, 2020] RealGrid2 2.0.3 update important notes
- RowStaet status values were displayed with the letters "N", "C", "U", "D", and " Modified to "createAndDeleted".
- The treeView function, which was lacking compared to RealGridJS, has been supplemented.
- Span processing that did not work smoothly during merging, etc. has been improved and errors have been corrected.
Customers developing with RealGrid2 must modify the rowState value as it has changed.
[June 1, 2020] RealGrid2 vs RealGridJS
- The name of RealGridJS is changed to RealGrid, and the product name of version 1.0 is also unified as RealGrid1.0.
- The implementation method has changed from Canvas to DOM. In 1.0, which was directly implemented using the Canvas method, there was a phenomenon in which the image appeared blurred when enlarged or reduced. 2.0 is implemented in the DOM method, improving the blurring phenomenon when zooming in/out.
- The biggest difference in 2.0 is the use of CSS. In 1.0, style-related work could be done directly by the grid and settings could be specified as properties, but in 2.0, everything, including dynamic styles, is set using CSS. If you have experience with CSS, it is more usable than 1.0, and you can check the style selector in the web browser's developer tools, making it easier to apply styles.
- The layout configuration method for column grouping has changed. Column grouping was implemented using SPAN, etc. in accordance with the more limited characteristics of the DOM than Canvas. For this reason, column grouping is set by defining it as a layout. Therefore, column setting information specified in JSON format in 1.0 is not compatible with 2.0.
- HTML renderer has been added. You can place HTML code within grid cells.
- FormView mode has been added. When adding or modifying data on mobile, you work in FormView mode and then return to grid mode to display it in grid form.
- Provides the option to undo (Undo) or redo (Redo) user input or dataset modification step by step. To use this feature, set GridBase.undoable to true. Also, to enable Undo/Redo within the dataset, set DataProviderBase.undoable to true. In most cases, when providing the Undo/Redo UI to the user, you can simply specify both properties as true.