RealGrid2 API
RealGrid Package

realgrid package

Classes

ClassDescription
GridViewGridView class, a child class of GridBase.
LocalDataProviderLocalDataProvider class. Inherits DataProviderBase.
LocalTreeDataProviderLocalTreeDataProvider class. Inherits DataProviderBase.
RealGridRealGrid main class
TreeViewIt is a child class of the TreeView class, GridBase.

Abstract Classes

Abstract ClassDescription
CustomCellRendererImplIt is a parent class of user-defined renderer.
DataProviderBaseBase class for LocalDataProvider and LocalTreeDataProvider
GridBaseGridBase is the base class of GridView and TreeView.

Enumerations

EnumerationDescription
BarOriginBar position in BarCellRenderer
ButtonVisibilityHow to display the column button and edit button in the data cell when a button is set in the column
CalendarModeSet limits on the year, month, and day selection screen.
CellButtonType of button to display on the right side of data cell
CellLayoutTypeSpecifies the type of layout.
ColumnHeaderItemLocationPosition type of image or check box in column header
ColumnLayoutDirectionPlacement direction when setting Cell Layout
DataDropModeMode when data drop
DataFillModeHow to populate data
DefaultShowDateWhen using the calendar editor, the date types displayed on the calendar
DragFeedbackStyleStyle of feedback that shows the drop position when the mouse is over
DropDownPositionA list of DropDownCellEditor or a calendar of DateCellEditor, BTDateCellEditor Position of selection box
DropDownSortStyleDropDownCellEditor How to sort the list
DropDownValueLabelHow to show the list of DropDownCellEditor
EdgeMarkedgeMark
ExitGridWhenTab

Conditions for leaving the grid when entering a tab

Can be set in EditOptions.exitGridWhenTab.

ExpanderVisibilityWhether to display Expander when grouping rows
ExpandWhenSetDataSets whether to maintain the existing expansion after setting data.
ExportCompressionWhether to compress when creating a file
ExportLayoutExpandWhen exporting a layout with layout Expandable set to true to Excel
ExportTargetDestination when exporting grid to external document
ExportTypeTypes of exporting grids to external documents
FilterModeFilter operation mode after data modification
FocusMoveStepHow to move focus when inputting the left or right arrow when there is a columnGroup
FocusType

Display focus in layer form or display only borders.

Can be set in DisplayOptions.focusType.

GridCellTypeGrid cell types
GridFitStyleConstants that control how columns are displayed
GroupShowMode

Determines whether the group column will be displayed when collapsed or expanded.

Set in CellLayoutItem.groupShowMode.

HandleVisibilityHow to display handles
IconLocationLocation of icons, checkboxes, shapes, etc. to be rendered
IndicatorValueType of content to be displayed on indicator
InlineFilterOperatorThis is the type of operator that can be used in FilterPanel.
ItemStateCondition of item
ItemTypeTypes of items in grid
LayoutDirectionItem placement direction
MenuItemTypeTypes of menu items displayed in PopupMenu, etc.
NullsOrder

When sorting, place undefined, null '' at the top or bottom regardless of ascending or descending order.

[SortingOptions.nullsOrder](/refs/Interface Set in /SortingOptions#nullsorder).

PolygonShapeList of shapes available in ShapeCellRenderer
RefreshModeConstants needed when redrawing the grid
RestoreModeRestoration Mode Type
RowGroupAdornmentsrow groupHow to display header or footer when in state
RowMaskTypeDisplay type of selected row (row mask type)
RowStatestatus of row
ScrollOnEditingProcessing status when scrolling while editing
SelectionDisplayCell Selection Display
SelectionModeMode for cell selection
SelectionStyleStyles for cell selection
SortCasecase sensitive type
SortDirectionSort by
SortModeSort operation mode after data modification
SortStyleSort type when clicking on grid column header
StateMarkHow to display status in status bar
SummaryModeHow to calculate the sum of each column in a grid
SummaryTypeType for calculating the total value of a field
SyncGridHeightChange the height of the grid so that all searched data can be seen.
TextInputCaseuppercase and lowercase letters
TimeSelectType
TreeExpanderIconStyleSpecifies the style of the default icon displayed in Tree Expander.
UserFilterPositionPosition of user filter when showing autoFilter and user filter at the same time
ValidationLevelData verification result level
ValidationModeVerification method
ValueTypeData type of data field
VerticalMoveStepHow to move focus when an up or down arrow is entered in a subcolumn of a ColumnGruop whose direction is vertical.

Interfaces

InterfaceDescription
ActualTargetBulletRenderer

Series renderer that compares and displays the target value (or expected value) stored in two data fields and the execution value.

The Bullet renderer displays the target value as a vertical bar and the execution value as a horizontal bar.

Available only in SeriesColumn.

[Superclass]

[CellRenderer](/refs/ Interface/CellRenderer)

ActualTargetTextRenderer

Renderer to compare and display the target value (or expected value) stored in two data fields and the actual value.

The ActualTarget text renderer displays in the format of 'execution value / target value'. .

Available only in SeriesColumn.

[Superclass]

[CellRenderer](/refs /Interface/CellRenderer)

BarCellRendererRenderer that displays the value of a numeric column cell as a bar
BTDateCellEditorEditor using BootStrap DatePicker
ButtonCellRendererRenderer that displays a button
CellEditorModel on which cell editors are based
CellIndexCell location information model
CellLayoutColumnItemColumn Layout Information Model
CellLayoutGroupHeader

Configuration information model for CellLayoutGroupItem.header

[Parent class] [CellLayoutHeader](/refs/Interface/ CellLayoutHeader)

CellLayoutGroupItemGroup Layout Information Model
CellLayoutHeaderSetting information model of cell layout header
CellLayoutItemBase model for setting up layout
CellMemoMemo information model for cells
CellProtectPropertiesSet cell lock or cell hiding.
CellRendererBase model for cell renderers
CheckBarConfiguration model related to checkbar
CheckCellRendererA renderer that indicates whether a value is true or false
ClickDataInformation model of clicked item
Code128CellRendererRenderer displaying Code128 Barcode
Code39CellRendererRenderer displaying Code39 Barcode
ColumnFilterSetting information related to column filtering
ColumnFilterCollectionCollection model of ColumnFilter
ColumnFooterSetting information for column footers displayed in the grid footer area
ColumnFooterCollectionCollection of ColumnFooter
ColumnHeaderSetting information model for column headers displayed in the grid header area
ColumnHeaderSummarySetting information of ColumnSummary displayed in grid header area
ColumnHeaderSummaryCollectionCollection of ColumnHeaderSummary
ColumnLayoutInfoIf the set layout is the CellLayoutColumnItem model, the object returned by GridBase.saveColumnLayout()
ColumnObjectBase class for column-related classes
ColumnStyleObjectOne of the style models that must be returned when changing the cell style with CellStyleCallback
ColumnSummaryBase classes such as ColumnFooter, ColumnHeaderSummary
ColumnSummaryStyleObjectOne of the style models that should be returned when changing the cell style with CellStyleCallback
CopyOptionsConfiguration model for copying grid contents to clipboard
CustomCellRendererObject used when setting up a custom cell renderer
DataCellCell information in grid data area
DataColumnColumn information model that inherits ValueColumn
DataDropOptionsd in another gridSetup model for how ragged data is handled
DataExportOptionsSetup model for export
DataFielddata field model object
DataFieldObjectObject with the same structure as DataField used when setting
DataFillOptionsSetting model for data retrieval
DataFilterObject with data filter conditions
DataOptionsDataProviderBase overall configuration information
DataOutputOptionsSetup model for how data is returned when output
DateCellEditordate editor
DateHolidayHolidays specified by date
DayHolidayPublic holidays designated on days of the week
DisplayOptionsSetting model for display information managed at grid level
DocumentTitleWhen exporting a grid using the GridExportOptions model and GridBase.exportGrid(), set the title, subtitle, and footer of the Excel document. model for
DropDownCellEditorEditor that allows editing with lists (dropdown editor)
EditingItemInfoObject type returned by GridBase.getEditingItem()
EditMaskObjectObject type display format in the editor that can be applied to text or date fields
EditOptionsSetup model for data editing in grid
EditorOptionsSetting model for editor information managed at grid level
EditResultOutput information after editing a cell used in GridBase.onGetEditValue
EditValidationModel for verification conditions and methods for column- or row-level data editing
EditValidationCollectionCollection model of EditValidation
ExportBaseOptionsModel based settings for grid and data export
ExportCorePropertiesGrid Export Settings Properties that can specify the properties of the Excel file
ExportMemoA model containing settings related to validation results for a cell
ExportOptionsCommon model for grid and data export settings
FieldMapField name of the grid to be moved used in DataDropOptions.fieldMap - field name of the grid to be moved pair format
FilterAutomatingOptionsSetting information for automatic filtering
FilterCategoryCategory classification model when creating custom automatic filtering
FilteringOptionsSetting model related to column filtering
FilterPanelDisplays an input window for filtering using the value entered by the user under the GridHeader area.
FilterSelectorOptionsSetting model for selection box in column filter
FixedOptionsSetting model for fixed row and column areas in grid
FormatOptionsSetting model for conversion format of data field values
GridCell
GridColumnColumn Information Model
GridExportOptionsConfiguration model for grid export
GridFooterSingle setup model for footer area
GridFooterCollectionCollection model for grid footer area
GridHeaderSetting model for header area
GridItemInformation model of the item
GridOptionsGrid's overall settings information
GroupingOptionsSettings model related to row grouping
GroupItem

Information model of group item

[Parent class]

GridItem

As a parameter of callback Used only when delivered.

GroupLayoutInfoIf the set layout is the CellLayoutGroupItem model, the object returned by GridBase.saveColumnLayout()
GroupPanelSetting information for grid Group Panel display information
GroupSummaryObject type returned by GridBase.getGroupSummary()
HeaderSummaryHeader Summary Single configuration model for areas
HeaderSummaryCollectionHeader summary Collection model object for area
HeaderTemplateEventTemplate event setting information for ColumnHeader or CellLayoutGroupHeader
IconCellRendererIcon Renderer
ImageCellRendererimage renderer
InvalidCellObject type returned by GridBase.getInvalidCells()
LineCellEditorText editor that accepts single-line input
LinkCellRendererRenderer that displays hyperlinks
LiteralColumnColumn that displays fixed values on the screen
LookupDataKeyValuesA type of LookupData
LookupDataRowsA type of LookupData
LookupSourceSetting information for displaying in cells a different value associated with the data field associated with the column instead of the actual value
MenuItemMenu Item Related Setting Information Model
MobileOptionsMobile-specific settings model
MultiCheckCellEditorEditor that allows multiple selections from drop-down lists
MultiCheckCellRendererA renderer that selects one or more than one value
MultiLineCellEditor

An editor that can receive multi-line input.

Inherits CellEditor.

[Super class]

CellEditor

NumberCellEditorEditor that allows only numbers, punctuation, and symbols to be entered
NumberFormatOptionsformatOption for displaying numbers, currency, and accounting expressed differently in each language
PasswordCellEditorEditor for entering passwords
PasteOptionsConfiguration model for pasting data from clipboard into grid
PopupMenu

Setting model for a popup menu or submenu registered in the grid

[Parent class]

PopupMenuBase

PopupMenuBaseThis is the base class for PopupMenu and PopupMenuItem.
PopupMenuItem

Configuration model for popup menu items displayed by right-clicking

See PopupMenu

[Superclass]

PopupMenuBase

RealGridLocale

Set the locale and currency for grid reference.

numberFormats: [Intl.NumberFormat](https://developer.mozilla.org/en-US/docs/Web/JavaScript/ (opens in a new tab) Register numberFormat using Reference/Global_Objects/Intl/NumberFormat/NumberFormat).

messages: Change the grid message to suit the user environment.

RealGridMessagesSpecifies the text output from the grid.
RectangleRectangle coordinate information
RendererEditResultEdited result model of custom renderer
RowGroupSetting model for how to display areas related to row grouping, etc.
RowGroupFootergrid groupfooter model
RowGroupFooterCollectionCollection model for grid group footer area
RowIndicatorConfiguration model for grid indicators
RowStateListList of rows according to row status
RowStyleObjectStyle model returned when changing the style of a row with RowStyleCallback
SearchCellEditorDropDownCellEditor with added search function
SearchCellOptionsFlexible configuration model for cell search
SearchCellResultLocation information of searched cell
SearchOptionsFlexible configuration information model for row retrieval
SelectionGrid Selection Area Information Model
SeriesColumnColumn that displays one or more data values simultaneously
SeriesTextCellRendererRenderer for displaying a Series column that displays one or more data values simultaneously as text
ShapeCellRendererA renderer that displays shapes contained in a grid
SheetProtectPropertiesSpecifies the properties to be allowed when applying Excel sheet protection.
SignalBarCellRendererRenderer that displays cell values as signal strength
SortedFieldsreturn format of gridView.getSortedFields
SortingOptionsSet model for data sorting
SparkChartRendererA base model for renderers to display Spark Chart graphs
SparkColumnRendererRenderer for displaying a Series column that displays one or more data values simultaneously as a Spark Column
SparkLineRendererRenderer for displaying a Series column that displays one or more data values simultaneously as a Spark Line
SparkWinLossRendererRenderer for displaying Series columns that display one or more data values simultaneously with Spark WinLoss
StateBar

Setting model related to the status bar that displays the status of rows

When using GridBase.setStateBar(), you only need to enter the necessary information.

StateTextsTypes of status texts to be displayed on the status bar
StyledCellCell model used to fill space among grid components
SummaryTemplateEventColumnSummary template event setting information
TemplateCellRendererA renderer that displays templates in HTML format
TemplateEventThe format used when adding an event to an element generated by TemplateCellRenderer or ColumnObject.template
TextCellEditorBase model for editors that can accept text input
TextCellRendererDefault Text Renderer
TooltipOptionsA configuration model for displaying messages on the screen.
ToastOptionsSettings model that allows you to specify whether to display Toast View and a message
TreeOptionsTreeView Setup model for display
TreeTemplateEventTreeTemplateOptions template event configuration information
TreeTemplateOptionsConfiguration information for displaying html in the data area of ​​the first column of treeView
UpdatedCellChanged cell information
UpdatedRowChanged row information
UserExportCellWhen exporting to Excel, specify additional content to be output in addition to the content output by the grid.
ValidationErrorSetting information model related to verification results
ValueCellIt is a superclass of DataCell.
ValueColumnColumn information model that inherits GridColumn
ViewOptionsFull configuration information of GridView
WaiOptionsSetting model for Shadow Dom

Type Aliases

Type AliasDescription
BooleanOutputCallbackCallback function format to be performed when converting a boolean field
CategoryCallbackCallback format for custom classification during automatic filtering
CellSpanCallbackCallback to set custom cell spanning
CellStyleCallbackCallbacks for dynamic cell style changes
CheckableCallbackA callback that determines whether a check is possible in CheckBar
ColumnObjectCallbackCallback used when displaying data whose dataType is object on the screen
ColumnSummaryCallbackCallback format used when the user specifies the value displayed in the column's footer or summary
CompareCallbackValue comparison callback format for user-specified conditions when searching
CompareFunctionComparison function format
ConfigObject
CopyTextCallbackCallback format that returns text saved to the clipboard when copying the grid
CreateFooterCallbackCallback format for specifying whether to display a specific group footer
DataDragCallbackCallback format that occurs when starting drag and drop between grids
DataDragLabelCallbackFormat of the callback to determine the label text of the item being dragged
DataDropCallbackCallback format that occurs when dragging and dropping between grids
DataFieldInputInput format for data fields
DataFiltersArray and collection objects in filter conditions
DataValuesRow Objects and Row Arrays
DatetimeOutputCallbackCallback function format to be performed when converting a datetime field
DropFieldMapCallbackA callback format that returns the rules applied when moving/copying by dragging and dropping between grids
EditMaskThe editor's display format, applicable to text or date fields
ExpanderVisibleCallbackA callback that returns whether the group expander is visible
ExportSimpleCallbackdone Type of callback to be performed when completing export to set
ExportValueCallbackFormat for specifying callbacks to be performed when outputting each field in Grid Export Settings
FieldValueCallbackIf it is a calculated field, type of callback to be calculated by specifying a formula
FilterCallbackfilter callback
FilterPanelCallbackThis is a callback called when you enter text in the input window of FilterPanel and then type enter or after filterDelay.
GetAriaLabelCallbackCallback format used in CellRenderer.ariaLabelCallback
GetCellTitleCallbackCallback format for setting the alt text of an image when rendering an image or setting the title text of an HTML Anchor Element when rendering a link cell
GetCheckedCallbackCallback type that determines check value when rendering
GetClassCallbackAdd class to a tag of linkRenderer
GetImageCallbackA callback format that specifies the path to the image for rendering the image
GetLinkUrlCallbackCallback format used in LinkCellRenderer.urlCallback
GetShapeCallbackCallback format used in ShapeCellRenderer.shapeCallback to specify the type of shape in the shape renderer
GetTemplateCallbackCallback format used in TemplateCellRenderer.callback
GroupFooterCellSpanCallbackCallback to set custom groupFooter spanning
GroupFooterStyleCallbackCallback to style grid group footer row
GroupFooterUserSpanCallbackCallback to set custom groupFooterUser span
HeaderCallbackCallback that returns the text displayed in the row group header
HolidaysSetting model for specifying public holidays
LayoutInfoInformation model of the layout returned by GridBase.saveColumnLayout()
LayoutItemA type of layout item model that allows you to create columns of the desired type
ListCallbackDropDownCellEditor Used to retrieve items that change according to callback conditions used when creating a list.
ListResultreturn type of ListCallback or GridBase.onSearchCellButtonClick
ListTemplateCallbackCallback used when the user writes an item displayed in the list in DropDownCellEditor or SearchCellEditor
LookupDataModel information to populate LookupSource
MemoCallbackFormat for specifying a callback to be executed when printing notes for each cell in Export Excel Note
MenuItemClickCallback called when a menu item is clicked
MultiCheckDisabledCallbackCallback format that determines whether an item is disabled when rendering
MultiCheckKeydownCallbackCallback format that determines which value to select or clear on keydown in MultiCheckCellRenderer
NumberOutputCallbackCallback function format to be performed when converting the number field
ObjectToValuesCallbackCallback called for each row when data in json format is entered into the data provider
OuterSortCallbackCallback format specified by the user when performing sorting
ProgressCallbackA format for specifying a callback to be performed when showProgress is true in Grid Export Settings
RealizeHeaderCallbackCallback format used in ColumnHeader.templateCallback or CellLayoutGroupHeader.templateCallback
RealizeSummaryCallbackCallback format used in ColumnSummary.templateCallback
RealizeValueCallbackCallback format used in TemplateCellRenderer.valueCallback
RowBarCellStyleCallbackCallback to specify cell style in RowBar area
RowBlockCallbackCallback to set row block mask
RowHeightCallbackCallback format that returns the height of the row
RowObjectrow object
RowStyleCallbackCallback for changing row style
RowValuesrow data
ScrollMessageCallbackA callback type that returns a message displayed on the screen indicating the scroll position when livescroll is not applied
SetCheckedCallbackCallback format that determines the check result value when editing
SummaryCellSpanCallbackCallback to set custom headerSummary and footer spanning
TreeIconCallback

Callback that specifies the icon displayed next to the tree expander

[Parameter list]

TreeView - tree view object

itemIndex - index of row

dataRow - dataRow of row

iconIndex - value of original iconIndex

[return value] - icon url or sequence number of TreeOptions.iconImages

TreeTemplateEventCallbackCallback format used in TreeTemplateEventCallback
UserCellsCallbackIf there is a callback GridExportOptions.userCells that is used when the user adds output cells, it is not performed.
ValueForGroupCallbackAlthough it is not the same value, it is used when the developer specifies a standard value when grouping it into one group. It must be returned with the same dataType as the dataType of the field.

Enumeration Desc


BarOrigin

The position of the bar in BarCellRenderer

Members:

MemberValueDescription
BOTTOMbottombottom
DEFAULTdefaultdefault
LEFTleftleft
RIGHTrightright
TOPtoptop

Example:

column.renderer = {
      "type": "bar",
      "origin":"right"
}

ButtonVisibility

How to display the column button and edit button in the data cell when a button is set in the column

Members:

MemberValueDescription
ALWAYSalwaysalways visible
DEFAULTdefaultOnly visible when the mouse is over a cell or a cell is selected
HIDDENhiddenDo not display
ROWFOCUSEDrowfocusedWith row selected, Show
VISIBLEvisibleWith cells selected, select Show

Remarks:

Used in the buttonVisibility and editButtonVisibility properties of ValueColumn.

Example:

// column button
column.buttonVisibility = false;
 
// Buttons in editor
column.editButtonVisibility = false;

CalendarMode

Set limits on the year, month, and day selection screen.

Members:

MemberValueDescription
DAYdayYou can select day.
MONTHmonthYou can only select up to month.
YEARyearOnly Year can be selected.

Remarks:

Used to select year-month or only year.


CellButton

Type of button to display on the right side of data cell

Members:

MemberValueDescription
ACTIONactionRun button (calls onCellButtonClicked callback when clicked)
NONEnoneNo button
POPUPpopupPop-up menu button

Remarks:

Used in ValueColumn.button.

Example:

column.button = 'popup';

CellLayoutType

Specifies the type of layout.

Members:

MemberValueDescription
COLUMNcolumnCreate a layout connected to the column.
GROUPgroupUsed when adding groupLayout.

Remarks:

GridBase.addLayout() or [CellLayoutGroupItem.addLayout()](/refsWhen adding a layout using /Interface/CellLayoutGroupItem#addlayout), specify the layout type.


ColumnHeaderItemLocation

Position type of image or check box in column header

Members:

MemberValueDescription
BOTTOMbottombottom
BOTTOM_EDGEbottomEdgebottom corner
CENTERcentermiddle
LEFTleftleft
LEFT_EDGEleftEdgeLeft corner
NONEnoneNone
RIGHTrightright
RIGHT_EDGErightEdgeRight corner
TOPtoptop
TOP_EDGEtopEdgetop corner

Remarks:

Used in ColumnHeader.checkLocation.

Example:

let col = grid.columnByName('col1')
col.header.checkLocation = 'leftEdge';

ColumnLayoutDirection

Placement direction when setting Cell Layout

Members:

MemberValueDescription
HORIZONTALhorizontalplaced horizontally
VERTICALverticalplaced vertically

Remarks:

Used in CellLayoutGroupItem.direction.


DataDropMode

Mode when dropping data

Members:

MemberValueDescription
COPYcopyCopy
MOVEmoveGo

DataFillMode

How to populate data

Members:

MemberValueDescription
APPENDappendAppend data after last row
INSERTinsertInsert
SETsetIgnore existing data and fill as many data rows starting from row 0
UPDATEupdateReplace existing data. Any remaining data after reaching the last row is ignored.

Remarks:

Used in DataFillOptions.fillMode.


DefaultShowDate

When using the calendar editor, the type of dates displayed on the calendar

Members:

MemberValueDescription
DEFAULTdefaultspecified date
DEFAULT_WHEN_NULLdefaultWhenNullIf there is data in the cell, the relevant date is selected and if there is no data, the specified date is selected and displayed.
NORMALnormalGeneral
TODAYtodaytoday
TODAY_WHEN_NULLtodayWhenNullSame behavior as normal, but the current date is selected and displayed only if there is no date.

Remarks:

Used in DateCellEditor.

Example:

column.editor = { type: "date", maxLength: 6, yearNavigation: true, defaultShowDate: 'today' }

DragFeedbackStyle

Feedback style that shows the drop location when the mouse is over

Members:

MemberValueDescription
CELLcell
GROUPgroupDisplayed in block form overlaid on the dropped column group cell.
LINEline

Line

Displayed in line form above or below the dropped row

ROWrow

Block or Row

Displayed in block form overlaid on the dropped row


DropDownPosition

A list of DropDownCellEditor or a calendar of DateCellEditor, BTDateCellEditor Position of selection box

Members:

MemberValueDescription
BUTTONbuttonAlign to button
EDITOReditorAlign to editor

Example:

column.editor = {
type: 'list',
values: ['value1', 'value2'],
dropDownPosition: 'editor'
}

DropDownSortStyle

DropDownCellEditor How to sort the list

Members:

MemberValueDescription
ASCENDINGascendingAscending
DESCENDINGdescendingDescending
NONEnoneNot specified

Example:

column.editor = {
type: 'list',
values: ['value1', 'value2'],
itemSortStyle: 'descending'
}

DropDownValueLabel

How to show the list of DropDownCellEditor

Members:

MemberValueDescription
LABELlabellabel value only
LABEL_VALUElabelValuelabel - value ordered pair
VALUEvaluevalue only
VALUE_LABELvalueLabelvalue - label ordered pair

Example:

column.editor = {
type: 'list',
values: ['value1', 'value2'],
labels: ['label1', 'label2'],
displayLabels: 'valueLabel'
}

EdgeMark

edgeMark

Members:

MemberValueDescription
LEFT_BOTTOMleftBottombottom left
LEFT_TOPleftToptop left
RIGHT_BOTTOMrightBottomBottom right
RIGHT_TOPrightToptop right

Remarks:

Used in ValueColumn.edgeMark.

Example:

column.edgeMark = "leftTop"

ExitGridWhenTab

Conditions for leaving the grid when entering a tab

It can be set in EditOptions.exitGridWhenTab.

Members:

MemberValueDescription
GRIDgridIf it is the last cell of the grid, it goes out.
NONEnoneWhen I press the tab key, I don't leave the grid.
ROWrowIf it is the last cell in a row, it is left out.

Example:

grid.editOptions.exitGridWhenTab = 'grid';

ExpanderVisibility

Whether to display Expander when grouping rows

Members:

MemberValueDescription
ALWAYSalwaysExpander is always displayed when grouping rows.
DEFAULTdefaultDefault value: Displays if multiple grouped rows are visible, otherwise does not display.
NONEnoneExpander when grouping rowsdo not display

Remarks:

Used in RowGroup.mergeExpanderVisibility.

Example:

gridView.rowGroup.mergeExpanderVisibility = 'always';

ExpandWhenSetData

Sets whether to keep the existing expansion after set data.

Members:

MemberValueDescription
COLLAPSEcollapseCollapsed state
EXPANDexpandExpanded state
REMAIN_AND_COLLAPSEremainAndCollapseKeep expanded state and collapse all new rows.
REMAIN_AND_EXPANDremainAndExpandKeep expanded state and expand all new rows.

Remarks:

Used in TreeOptions.expandWhenSetData.


ExportCompression

Whether to compress files when creating them

Members:

MemberValueDescription
DEFLATEDEFLATECompresses files.
STORESTOREDoes not compress files.

ExportLayoutExpand

When exporting a layout with layout Expandable set to true to Excel

Members:

MemberValueDescription
COLLAPSEcollapsePrinted in a folded state.
CURRENTcurrentcurrent current shape
EXPANDexpandPrint out in an unfolded state.
IGNOREignoreIgnores expandable and outputs as set layout shape.

ExportTarget

Destination when exporting a grid to an external document

Members:

MemberValueDescription
LOCALlocalSave directly to local
REMOTEremoteSave via server
STREAMstreamExport to Console

ExportType

Types of when to export a grid to an external document

Members:

MemberValueDescription
CSVcsvCSV
EXCELexcelExcel

Remarks:

Used in ExportBaseOptions.type.


FilterMode

Filter operation mode after data modification

Members:

MemberValueDescription
AUTOautoautomatic
EXPLICITexplicitAfter modifying the data, you must explicitly filter it to be filtered

Remarks:

Used in GridView.filterMode.

Example:

gridView.filterMode = 'explicit';

FocusMoveStep

How to move focus when inputting the left or right arrow when there is a columnGroup

Members:

MemberValueDescription
CELLcellMove by cell.
GROUPgroupMove to the highest group level.

FocusType

Display focus in layer form or display only the border.

It can be set in DisplayOptions.focusType.

Members:

MemberValueDescription
LAYERlayerDisplayed in the form of a layer covering the selected cell.
LINElineOnly the borders of selected cells are displayed as lines.

GridCellType

Grid cell types

Members:

MemberValueDescription
CHECKcheckcheck bar
DATAdatadata
FILTERfilterfilter rowIndicator area
FIXED_BARfixedbarfixed bar
FOOTfootfoot
FOOTERfooterFooter
GRID_EMPTYgridEmptyempty grid
GROUP_BARgroupBargroup bar
GROUP_COLUMNgroupColumngroup column
GROUP_FOOTgroupFootgroup foot
GROUP_FOOTERgroupFooterGroup Footer
GROUP_HEADgroupHeadgroup head
GROUP_HEADERgroupHeadergroup header
GROUP_PANELgroupPanelGroup panel
HEADheadhead
HEADERheaderheader
INDICATORindicatorindicator
INLINE_FILTERinlineFilterinline-filter body area
LAYOUT_HEADERlayoutHeaderHeader of Column Group
SCROLL_BARscrollBarScrollbar area
SCROLL_BUTTONscrollButtonScrollbar button
SCROLL_EDGEscrollEdgeScrollbar bottom right
SCROLL_THUMBscrollThumbScrollbar thumb area
SCROLL_TRACKscrollTrackScrollbar track area
STATEstatestatus bar
SUMsumsum
SUMMARYsummarySummary

Remarks:

Used in ClickData, etc.

Example:

gridView.onMenuItemClicked = function (grid, item, clickData) {
      console.log(item.label + "was clicked.");
      console.log("cellType is: " + clickData.cellType);
};

GridFitStyle

Constants that control how columns are displayed

Members:

MemberValueDescription
EVENevenIf the total width of the displayed columns is smaller than the grid width, distribute the remaining size proportionally
EVEN_FILLevenFillAlways expand or contract to fit the grid width (using the column width)
FILLfillIf fillWidth is set, fill the grid using it, otherwise fill the grid in the same way as even
NONEnoneDisplay as column width without adjustment

Remarks:

Used in DisplayOptions.fitStyle, etc.

Example:

grid.displayOptions.fitStyle = 'even'

GroupShowMode

Determines whether the group column will be displayed when collapsed or expanded.

Set in CellLayoutItem.groupShowMode.

Members:

MemberValueDescription
ALWAYSalwaysIt is always visible.
COLLAPSEcollapseIt is displayed when the group is closed.
EXPANDexpandIt is displayed when the group is expanded.

Remarks:

It is visible or hidden depending on the expansion state of the parent layout.


HandleVisibility

How to display handles

Members:

MemberValueDescription
ACTIVE_OR_HOVEREDactiveOrHoveredDisplays when active or hovered
ALWAYSalwaysalways visible
HIDDENhiddenHidden
HOVEREDhoveredShow only when hovered
VISIBLEvisibledisplay

Remarks:

The function icon displayed in the column header during sorting or filtering is called a handle.

HandleVisiblity is implemented as the handleVisibility property of SortingOptions, FilteringOptions.

Example:

grid.sortingOptions.handleVisibility = 'visible';

IconLocation

Location of icons, checkboxes, shapes, etc. to be rendered

Members:

MemberValueDescription
BOTTOMbottomShow below text
BOTTOM_EDGEbottomEdgeShow in bottom corner of cell
CENTERcenterShow in center of cell
LEFTleftShow left of text
LEFT_EDGEleftEdgeShow in left corner of cell
RIGHTrightShow right of text
RIGHT_EDGErightEdgeShow in right corner of cell
TOPtopShow above text
TOP_EDGEtopEdgeShow in top corner of cell

Remarks:

IconCellRendererUsed in , CheckCellRenderer, ShapeCellRenderer.

Example:

...
"renderer": {
          "type": "check",
          "checkLocation": "right"
      },
...

IndicatorValue

Type of content to be displayed on the indicator

Members:

MemberValueDescription
INDEXindexrow order
NONEnoneNone
REVERSEreverseReverse row order
ROWrowrow unique number

InlineFilterOperator

This is the type of operator that can be used in FilterPanel.

Members:

MemberValueDescription
BETWEENbetweenSpecify the range.
CONTAINScontainsData containing the entered value
EMPTYemptySearch for data without value
ENDS_WITHendsWithData ending with the entered value
EQUALequalData identical to the entered value
GREATERgreaterData greater than the entered value
GREATER_EQUALgreaterEqualData greater than or equal to the entered value
LOWERlowerData smaller than the entered value
LOWER_EQUALlowerEqualData less than or equal to the entered value
NOT_CONTAINSnotContainsData that does not contain the entered value
NOT_EQUALnotEqualData different from the entered value
RESETresetClears the entered value and deactivates the filter.
STARTS_WITHstartsWithData starting with the entered value

Remarks:

There are restrictions on the operators that can be used depending on DataColumn.valueType.


ItemState

Condition of the item

Members:

MemberValueDescription
APPENDINGappendingIf adding
DUMMYdummydummy
FOCUSEDfocusedIf the entered index is the index of the item currently being edited
INSERTINGinsertingIf inserting
NORMALnormalIf you are not editing, adding, or typing
UPDATINGupdatingIf you are editing

ItemType

Types of items in the grid

Members:

MemberValueDescription
FOOTERfooterGroup Footer
GROUPgroupgroup item
ROWrowrow
TREEtreetree items

Remarks:

Used in getModelAs(), etc.

Example:

let model = gridView.getModelAs(3, 'row');

LayoutDirection

Direction of item placement

Members:

MemberValueDescription
HORIZONTALhorizontalArrange items horizontally.
VERTICALverticalArrange items vertically.

MenuItemType

Types of menu items displayed in PopupMenu, etc.

Members:

MemberValueDescription
CHECKcheckcheckbox and text
NORMALnormalplain text
RADIOradioradio button and text
SEPARATORseparatorSeparation between menu items

Remarks:

Used in PopupMenuItem.type and MenuItem.type.

Example:

let menu = [{
      label: "This is menu3",
      type: "check",
      checked: true,
  }]

NullsOrder

When sorting, place undefined, null '' at the top or bottom regardless of ascending or descending order.

Set in SortingOptions.nullsOrder.

Members:

MemberValueDescription
DEFAULTdefaultWhen in ascending order, place it at the top, and when in descending order, place it at the bottom.
FIRSTfirstPlace it at the top.
LASTlastPlace it at the bottom.

PolygonShape

List of shapes available in ShapeCellRenderer

Members:

MemberValueDescription
DIAMONDdiamonddiamond
DOWN_ARROWdownarrowarrow pointing down
EQUALequalequal sign
INVERTED_TRIANLGEitriangleinverted triangle
LEFT_ARROWleftarrowArrow pointing left
MINUSminusminus sign
PLUSplusplus sign
RECTANGLErectanglerectangle
RIGHT_ARROWrightarrowarrow pointing right
STARstarstar shape
TRIANLGEtriangletriangle
UP_ARROWuparrowarrow pointing up

Example:

column.renderer = {
     "type": "shape",
     "shape": "triangle" // PolygonShape
}

RefreshMode

Constants needed when redrawing the grid

Members:

MemberValueDescription
ALLallRedraw all columns
RECYCLErecycleWhen scrolling vertically, only visible columns are redrawn, and when scrolling horizontally, the entire column is redrawn.
VISIBLE_ONLYvisibleOnlyRedraw only visible columns

Remarks:

Used in DisplayOptions.refreshMode.

Example:

grid.displayOptions.refreshMode = 'visibleOnly';

RestoreMode

Restoration mode type

Members:

MemberValueDescription
AUTOautoIf you just change it back to the original value, the RowState will also return to its original state.
EXPLICITexplicitRowState and value are changed only when restoreUpdatedRows() is explicitly used.
NONEnoneDo not set recovery mode.

RowGroupAdornments

How to display header or footer when in row group state

Members:

MemberValueDescription
BOTHbothShow both header and footer when in row group state
FOOTERfooterShow footer when in row group state
HEADERheaderShow header when in row group state
NONEnoneNot displayed, only applicable in expandedAdornments state.
SUMMARYsummaryDisplay summary contents in header position when in row group state

Remarks:

RowGroup.collapsedAdornments, RowGroup.expandedAdornmentsIt is used in

Example:

grid.setRowGroup({expandedAdornments: "none"});

RowMaskType

Display type of selected row (row mask type)

Members:

MemberValueDescription
CELLcellone cell
DATAdatacolumn area
FILLfillArea including indicator, status bar, check bar, and column + empty area
NONEnoneNone
ROWrowArea including indicator, status bar, check bar, and column

Remarks:

rowBlockType, rowHoverType, [rowFocusType](/refs/Interface/DisplayOptions #rowfocustype), etc.

Example:

grid.displayOptions.rowBlockCallback = f;
grid.displayOptions.rowBlockType = 'row';

RowState

status of row

Members:

MemberValueDescription
CREATE_AND_DELETEDcreateAndDeletedDeleted after creation
CREATEDcreatedCreated
DELETEDdeletedDeleted
NONEnonenothing
UPDATEDupdatedUpdated

ScrollOnEditing

Processing status when scrolling while editing

Members:

MemberValueDescription
CANCELcancelCancel Edit
COMMITcommitcommit
DEFAULTdefaultMaintain Editor

Remarks:

It can be set in EditOptions.scrollOnEditing.

Example:

grid.editOptions.scrollOnEditing = 'cancel';

SelectionDisplay

Cell selection display

Members:

MemberValueDescription
CELLcellcell
CELL_AND_BORDERcellAndBorderCells and Borders
MASKmaskmask

Remarks:

developing...


SelectionMode

Mode for cell selection

Members:

MemberValueDescription
EXTENDEDextendedUse multiple area selection
NONEnoneDo not use area selection.
SINGLEsingleUse only one area selection

Remarks:

Used in DisplayOptions.selectionMode.


SelectionStyle

Styles for cell selection

Members:

MemberValueDescription
BLOCKblockSelect by block type
COLUMNScolumnsSelect by column
GROUPgroupSelect in the same format as block, but select in groups rather than cells.
NONEnoneNot selectable
ROWSrowsSelect by row
SINGLEsingleSelect only one cell
SINGLE_COLUMNsingleColumnSelect only one column
SINGLE_ROWsingleRowSelect only one row

Remarks:

SINGLE, SINGLE_ROW, and SINGLE_COLUMN are called single selection styles.

Used in DisplayOptions.selectionStyle.

For the RowIndicator.selectable function to work properly, DisplayOptions.selectionStyle must not be a single selection style.

If DisplayOptions.selectionStyle is not a single selection style, a column-wise selection area is specified when you press the ctrl key and then drag the column header.


SortCase

Case sensitive type

Members:

MemberValueDescription
INSENSITIVEinsensitiveNo distinction
SENSITIVEsensitiveCategory

Remarks:

Used in SortingOptions.textCase, orderBy(), etc.

Example:

gridView.orderBy(['fruit'], ['descending'], ['insensitive']);

SortDirection

sorting method

Members:

MemberValueDescription
ASCENDINGascendingAscending
DESCENDINGdescendingDescending
NONEnoneNone

Remarks:

Used in getDistinctValues(), orderBy(), etc.

Example:

gridView.orderBy(['fruit'], ['descending'], ['insensitive']);

SortMode

Sort operation mode after data modification

Members:

MemberValueDescription
AUTOautoautomatic
EXPLICITexplicitAfter data modification, sorting must be performed explicitly. Sort

Remarks:

Used in GridBase.sortMode.

Example:

gridView.sortMode = "explicit";

SortStyle

Sort type when clicking on grid column header

Members:

MemberValueDescription
EXCLUSIVEexclusiveSort by last clicked column
INCLUSIVEinclusiveSort by first clicked column
NONEnoneUnsorted
REVERSEreverseSort by last clicked column first

Remarks:

Used in SortingOptions.style.

Example:

grid.sortingOptions.style = 'inclusive'

StateMark

How to display status in status bar

Members:

MemberValueDescription
IMAGEimageimage
NONEnoneNone
TEXTtexttext

SummaryMode

How to calculate the sum of each column in the grid

Members:

MemberValueDescription
AGGREGATEaggregateAutomatically calculates arithmetic sums such as sum, average, maximum, and minimum values
NONEnonenot calculated
STATISTICALstatisticalAutomatically calculate statistical sums such as variance, standard deviation, etc.

Remarks:

It can be set and used in GridBase.summaryMode, etc.Example:

let sum = gridView.getSummary('unitPrice', 'sum');

SummaryType

Type for calculating the total value of a field

Members:

MemberValueDescription
AVGavgaverage
COUNTcountcount
DATAAVGdataavgaverage divided by DATACOUNT
DATACOUNTdatacountNumber of data with specified value (not null)
MAXmaxmaximum value
MINminMinimum
STDEVstdevSample population standard deviation
STDEVPstdevppopulation standard deviation
SUMsumSum
VARvarSample population variance
VARPvarppopulation variance

Remarks:

Used in GridBase.getSummary().

Example:

let sum = gridView.getSummary('unitPrice', 'sum');

SyncGridHeight

Change the height of the grid so that all searched data can be seen.

Members:

MemberValueDescription
ALWAYSalwaysAlways set the grid height to the data area.
NONEnoneMaintain the specified height.
OVERoverChange the height of the grid when it becomes larger than the area of the grid.

Remarks:

If there is no data, the initial height is displayed. If a lot of data is output, it becomes slow, so you need to import only some data and then add data using the 'More' button.


TextInputCase

uppercase and lowercase letters

Members:

MemberValueDescription
DEFAULTdefaultIf set to this value in the editor, it will follow the value set in the column
LOWERlowerlowercase
NORMALnormalDisplay as entered
UPPERupperCapitalize

Remarks:

Used in ValueColumn.textInputCase, CellEditor.textCase, etc.

Example:

column.editor = { type: "line", maxLength: 1, textCase: 'lower'}

TimeCategory

Classification unit when filtering by time

Members:

MemberValueDescription
AUTOauto

Data is classified according to its value.

If time is omitted, it is classified by date.

HOURhourCategorize by time.
MINUTEminuteClassified down to the minute.
NONEnoneSort by date, not by time.
SECONDsecondClassifies down to the second.

Remarks:

Used in FilterAutomatingOptions.timeCategorize.


TimeSelectType

Members:

MemberValueDescription
HOURhourDisplays the time selection screen.
MINUTEminuteDisplays the hour/minute selection screen.
NONEnoneThe time selection screen is not displayed.
SECONDsecondDisplays the hour/minute/second selection screen.

TreeExpanderIconStyle

Specifies the style of the default icon displayed in Tree Expander.

Members:

MemberValueDescription
SQUAREsquareDisplays a square-shaped Tree Expander icon.
TRIANGLEtriangleDisplays the triangular Tree Expander icon.

UserFilterPosition

Position of user filter when autoFilter and user filter are shown at the same time

Members:

MemberValueDescription
FIRSTfirstPosition user filter at the top of autoFiler.
LASTlastPosition user filter at the bottom of autoFiler.
NONEnoneDo not display user filter.

ValidationLevel

Data verification result level

Members:

MemberValueDescription
ERRORerrorerror
IGNOREignoreNone
INFOinfoInformation
WARNINGwarningwarning

Remarks:

Used in GridBase.setValidations(), etc.

Example:

gridView.setValidations({
      message: 'Too expensive!',
      criteria: "values['UnitPrice'] > 100",
      level: 'error'
})

ValidationMode

Verification method

Members:

MemberValueDescription
ALWAYSalwaysAlways (insert, modify) whenever committed
INSERTinsertWhen the added row is committed
UPDATEupdateWhen the modified row is committed

Remarks:

Used in GridBase.setValidations(), etc.

Example:

gridView.setValidations({
      message: 'Too expensive!',
      criteria: "values['UnitPrice'] > 100",
      mode: 'always'
})

ValueType

Data type of data field

Members:

MemberValueDescription
BOOLEANbooleanBoolean
CHARcharcharacter
DATEdateDate with time part removed
DATETIMEdatetimedate
INTintinteger type
NUMBERnumbernumbers
OBJECTobjectobject
TEXTtexttext
UINTuintinteger value greater than or equal to 0
UNUMunumnumbers greater than or equal to 0

Remarks:

When used in DataField.dataType, TEXT, NUMBER, DATETIME, BOOLEAN It is used as , OBJECT, and when you want to limit the applied data type, it can be given to DataField.subType as follows.

dataType is TEXT: CHAR

dataType has NUMBER: INT, UNUM, UINT

dataType is DATETIME: DATE

Example:

let fields = [{
...
      dataType: "text",
      subType: "char",
...
}]
 
ds.setFields(fields);

VerticalMoveStep

How to move focus when an up or down arrow is entered in a subcolumn of a ColumnGruop whose direction is vertical.

Members:

MemberValueDescription
CELLcellMove by cell.
ROWrowMove row by row.

Type Aliases Desc


BooleanOutputCallback

Callback function format to be performed when converting a boolean field

Remarks:

Used in DataOutputOptions.booleanCallback.

[Parameter list]

ds - DataProvider control

row - the index of the item

field - field name

value - the value

[return value] - value to output

Example:

const f = function(ds, row, field, value) {
      return !!value;
}

CategoryCallback

Callback format for custom classification during automatic filtering

Remarks:

[Parameter list]

column - Column with automatic filtering applied

values - all values

[Return value] - Array type of category classification model

Example:

const f = function(column, values) {
      const emptyText = 'Empty item'
      if (!values) {
          return null;
      }
      const valids = values.filter(function (el) { return el !=undefined && el != null; });
      const min = Math.min.apply(null, valids);
      const vlen = values.length;
      let unit;
      if (vlen > 15) {
          const groupCount = Math.min(Math.round(vlen / 5)), 10);
          unit = Math.round(vlen / groupCount);
      } else {
          unit = 1;
      }
      let categories = [];
      let gvals = [];
      let gindex = 0;
      let gmin = min;
      let isEmpty = false;
      for (let i = 0; i < vlen; i++) {
          const v = values[i];
          if (v === undefined || v === null) {
              isEmpty = true;
              continue;
          }
          if (i == gindex + unit || i === vlen - 1) {
              categories.push({ text: gmin + ' ~ ' + v, values: gvals });
              gvals = [v];
              gindex = i;
              gmin = v;
          } else {
              gvals.push(v);
          }
      }
      if (isEmpty) {
          categories.push({ text: emptyText, empty: true });
      }
      return categories;
}

CellSpanCallback

Callback to set custom cell spanning

Remarks:

Used in CellLayoutColumnItem.

[Parameter list] grid - GridBase control

layout - layout item

itemIndex - the index of the row

Example:

const f = function (grid, layout, itemIndex) {
     var value = grid.getValue(itemIndex, layout.column.dataIndex);
     if (value) {
         return value[0] === "B" ? 3: value[0] === "F" ? 2:1;
     }
     return 1;
};

CellStyleCallback

Callbacks for dynamic cell style changes

Remarks:

When returning ColumnStyleObject, GridBase.setCellStyleCallback(), [ValueColumn.styleCallback](/refs/Interface/ Used in ValueColumn#stylecallback).

ColumnSummaryStyleObject returns GridFooter.cellStyleCallback, [HeaderSummary.cellStyleCallback](/refs/Interface/HeaderSummary# cellstylecallback).

Specified as a style name when returning a string

[Parameter list]

grid - GridBase control

model - a cell in the grid

[Return value] - Object or style class name to apply dynamic style

Example:

const f1 = function(grid, model) {
      if (model.value > 5) return "rg-data-cell bold-cell";
      if (model.value < 0 && model.value > -10) {
          return {
              styleName: 'custom-negative-cell',
              renderer: {
                  type: 'bar',
                  absoluteValue: true
              }
          }
      }
}
 
const f2 = function(grid, model) {
      if (model.value > 10) {
          return {
              styleName: 'custom-summary-cell'
          }
      }
}
 
// Apply to all data cells
gridView.setCellStyleCallback(f1);
 
// Apply to each column
let column = gridView.columnByName('Price');
column.styleCallback = f1;
 
// Apply footer
gridView.footer.cellStyleCallback = f2;
 
// Apply header summary
gridView.headerSummary.cellStyleCallback = f2;

CheckableCallback

A callback that determines whether a check is possible in CheckBar

Remarks:

[Parameter list]

dataSource - DataProvider control

item - The item to be checked (row item, header item, etc.)

[Return value] - Checkable or not

Example:

const f = function(dataSource, item) {
      if (item.value) {
          return item.value !== 'doNotCheck';
      }
      else {
          return false;
      }
}

ColumnObjectCallback

A callback used when displaying data whose dataType is object on the screen.

Remarks:

[Parameter list]

fieldName - field name

dataRow - dataRow

value - value

[Return value] - Content to display on screen

Example:

const callback = function(fieldName, dataRow, value) {
   return JSON.stringify(value);
}
 
gridView.columnByName("objectColumn").objectCallback = callback;

ColumnSummaryCallback

Callback format used when the user specifies the value displayed in the footer or summary of the column

Remarks:

[Parameter list]

grid - gridView

column - Column of footer or summary

footerIndex - Order number if there are multiple footers in the column

summary - footer or summary object GroupItem object if groupFooter

value - the value if expression is specified

[Return value] - Content to be displayed on the screen.


CompareCallback

Value comparison callback format for user-specified conditions when searching

Remarks:

[Parameter list]

v1 - the value to be searched for

v2 - the searched value

sensitive - case sensitive

partialMatch - Whether to also search for contained characters

[Return value] - Whether the value matches

Example:

const f = function(v1, v2, sensitive, partialMatch) {
      if (v1 === v2) {
           return true;
      }
      let s1 = String(v1);
      let s2 = v2 == null ? undefined : String(v2);
      if (!s1 && !s2) {
           return true;
      }
      if (!s1 || !s2) {
           return false;
      }
      if (!caseSensitive) {
           s1 = s1.toLowerCase();
           s2 = s2.toLowerCase();
      }
      if (partialMatch) {
      return s2.indexOf(s1) >= 0;
      } else {
      return s1 == s2;
      }
}

CompareFunction

Comparison function format

Remarks:

It has the same format as CompareFunction used in Array.prototype.sort().

Used in DataProviderBase.setDataComparer().


ConfigObject


CopyTextCallback

Callback type that returns text saved to the clipboard when copying the grid

Remarks:

[CopyOptions.copyTextCallback]Used in (/refs/Interface/CopyOptions#copytextcallback).

[Parameter list]

grid - GridBase control

itemIndex - itemIndex of the row being copied

column - DataColumn object

[Return value] - When returning undefined, the text to be copied to the clipboard, the text is copied according to value or other settings in copyOptions.

Example:

const f = function(grid, itemIndex, column, value) {
      if (value != null && column.name === "number1") {
          return value + "";
      }
}
grid.copyOptions.copyTextCallback = f;

CreateFooterCallback

Callback format for specifying whether to display a specific group footer

Remarks:

This is the format used in RowGroup.createFooterCallback.

[Parameter list]

owner - GridBase control

group - group item

footerIndex - Index within the footer collection

Example:

createFooterCallback: function(owner, group, footerIndex) {
    if (group.level >= 5) { return false }
    if (group.level === 4) {
        let relation2 = owner.getDataSource().getValue(group.firstItem.dataRow, "relation2");
        return relation2 === "relative"
    }
    if (group.level === 3) {
        let relation1 = owner.getDataSource().getValue(group.firstItem.dataRow, "relation1");
        return relation1 === "same person"
    }
    return true;
}

DataDragCallback

Callback format that occurs when starting drag and drop between grids

Remarks:

If false is returned, drag and drop is canceled. Used in DataDropOptions.dragCallback.

[Parameter list]

source - the GridBase control where the dragged item was located

sourceItems - Index of items in the dragged grid

target - GridBase control or HTMLElement to drop

targetItem - Index of the item in the grid to drop

targetColumn - targetColumn in the grid to drop to

[Return value] - Whether drag and drop is possible

Example:

gridView.dataDropOptions.dragCallback = function (source, sourceItems, target, targetItem) {
     return targetItem % 2 == 0;
}

DataDragLabelCallback

Format of the callback to determine the label text of the item being dragged

Remarks:

[Parameter list]

source - the GridBase control where the dragged item was located

sourceItems - Index of items in the dragged grid

target - GridBase control or HTMLElement to drop

targetItem - Index of the item in the grid to drop

targetColumn - targetColumn in the grid to drop to

[return value] - the text of the label

Example:

gridView.dataDropOptions.labelCallback = function (source, sourceItems, target, targetItem) {
     return sourceItems.length + " rows ";
}

DataDropCallback

Callback format that occurs when dragging and dropping between grids

Remarks:

Used in DataDropOptions.callback.

[Parameter list]

source - the GridBase control where the dragged item was located

sourceItems - Index of items in the dragged grid

target - GridBase control or HTMLElement to drop

targetItem - Index of the item in the grid to drop

targetColumn - targetColumn in the grid to drop to

Example:

gridView.dataDropOptions.callback = function (source, sourceItems, target, targetItem) {
     alert('row from ' + sourceItems + ' to ' + targetItem);
     for (var i = 0; i < sourceItems.length; i++) {
         var r = source.getDataRow(sourceItems[0]);
         var ds = source.getDataSource();
         var row = ds.getJsonRow(r)
         if (targetItem >= target.getItemCount()) {
             ds.addRow(row);
         } else {
             r = target.getDataRow(targetItem);
             target.getDataSource().insertRow(r, row);
         }
     }
}

DataFieldInput

Input format for data fields

Remarks:

Used in setFields, etc.

Example:

// string
ds.setFields('fieldName');
 
// model
let fields = ds.getFields();
ds.setFields(fields);
 
//config
ds.setFields({
      fieldName: 'OrderID',
      dataType: 'text',
});

DataFilters

Array and collection objects in filter conditions

Remarks:

Used in LocalDataProvider.setFilters().

Example:

// string
dataProvider.setFilters([
   "value['field1']='Singer'",
   "value['field2']='Woman'"
], "and");
 
//object
dataProvider.setFilters([
   {criteria: "value['field1']='Singer'"},
   {criteria: "value['field2']='Woman'"}
], "and");

DataValues

Row objects and row arrays

Remarks:

It is used in various ways in the method of LocalDataProvider, LocalTreeDataProvider.

RowObject or RowValues.

Example:

//array
let row = ['value1', 'value2', 'value3']
 
//object
let row = {field1: 'value1', field2: 'value2', field3: 'value3'}

DatetimeOutputCallback

Callback function format to be performed when converting a datetime field

Remarks:

Used in DataOutputOptions.datetimeCallback.

[Parameter list]

ds - DataProvider control

row - the index of the item

field - field name

value - the value

[return value] - value to output

Example:

const f = function(ds, row, field, value) {
      if (value === 'today') {
          return new Date();
      }
      return new Date(value);
}

DropFieldMapCallback

A callback format that returns the rules applied when moving/copying by dragging and dropping between grids.

Remarks:

[Parameter list]

source - the GridBase control where the dragged item was located

sourceItems - Index of items in the dragged grid

target - GridBase control to drop

targetItem - Index of the item in the grid to droptargetColumn - targetColumn in the grid to drop to

[Return Value] - FieldMap object

Example:

gridView.dataDropOptions.fieldMapCallback = function (source, sourceItems, target, targetItem) {
     if (targetItem % 2 == 0) {
         return {
             Country: "Country",
             CompanyName: "ShipAddress",
             EmployeeID: "ShipPostalCode"
         }
     }
}

EditMask

The editor's display format that can be applied to text or date fields.

Remarks:

When applying ValueColumn.editor, it is used in the editor's mask property.

For numeric fields, use NumberCellEditor.editFormat.

The format applied to Marks is displayed only in the editor.

dropDown, multiLine, multiCheck, does not work in number Editor.

Example:

// string
column.editor = {
      type: 'line',
      mask: '9999-99-99'
}
 
//object
column.editor = {
      type: 'line',
      mask: {
          editMask: '9999-99-99',
          placeHolder: 'input...'
      }
}

ExpanderVisibleCallback

A callback that returns whether the group expander is visible.

Remarks:

This is the format used in RowGroup.expanderVisibleCallback.

[Parameter list] grid - GridBase control

group - group item

Example:

gridView.rowGroup.expanderVisibleCallback = function(grid, group) {
      // Only 2-level groups display the expander.
      return group.level === 2;
}

ExportSimpleCallback

Format of the callback to be performed when completing the export to set done

Remarks:

[Parameter list]

data - Sent when the target is stream.


ExportValueCallback

Format for specifying callbacks to be performed when outputting each field in Grid Export Settings

Remarks:

[Parameter list]

index - index

name - Column name or field name

value - the entered value

grid - the grid or data provider being exported

[return value] - value to be exported


FieldValueCallback

If it is a calculated field, the type of callback to be calculated by specifying a formula

Remarks:

Used in DataField.valueCallback or DataFieldObject.valueCallback.

Finally, simply return the value you want to output.

[Parameter list]

ds - DataProvider control

rowId - Row unique number

fieldName - Field name

fields - array of field names

values - array of values

[return value] - value to output

Example:

function (ds, rowID, fieldName, fields, values) {
     let quantity = values[fields.indexOf("Quantity")];
     let unitprice = values[fields.indexOf("UnitPrice")];
     if (isNaN(quantity) || isNaN(unitprice))
         return undefined;
     else
         return quantity >= 1000 ? Math.round(quantity * unitprice * 0.95) : quantity * unitprice;
}

FilterCallback

filter callback

Remarks:

If the return value is undefined, ColumnFilter.criteria is applied.

Used in ColumnFilter.callback or FilterAutomatingOptions.selectCallback.

[Parameter list]

ds - Provider control

dataRow - the index of the row

level - level

field - field name

filter - ColumnFilter object

value - the value

[Return value] - Whether to decide on filtering

Example:

const f = function(ds, dataRow, level, field, filter, value) {
      let res = isMatched(value, filter.criteria);
      return res;
}

FilterPanelCallback

This is a callback called when you enter text in the input window of FilterPanel and then type enter or after filterDelay.

Remarks:

If true is returned, grid filtering is not performed. When operator and text are returned, filtering is performed using the entered operator and text.

[Parameter list]

grid - GridBase control

column - the column object of the input window

operator - InlineFilterOperator

text - entered text

Example:

grid.filterPanel.filterPanleCallback = function(grid, column, operator, text) {
  if (column.fieldName === "notRun") {
      return true; // Fields that are notRun are not filtered.
  } else if (column.fieldName = "userFilter") {
      return {
          operator: InlineFilterOperator.STARTS_WITH,
          text: text.substr(0,2) // Filter only the first 2 characters of the entered characters.
      }
  }
}

GetAriaLabelCallback

Callback format used in CellRenderer.ariaLabelCallback

Remarks:

[Parameter list]

grid - GridBase control

model - a cell in the grid

[Return Value] - String to be read by the screen reader.

Example:

const f = function(grid, model) {
      var s = model.value;
      var date = grid.getValue(model.item.index, "date")
      s += (date.getTime() > Date.now() - 60*60*24*7*1000) ? " new" : "";
      return s;
}
 
column.renderer = {
      type: 'text',
      ariaLabelCallback: f
}

GetCellTitleCallback

A callback format for setting the alt text of an image when rendering an image or setting the title text of an HTML Anchor Element when rendering a link cell.

Remarks:

Used in ImageCellRenderer.titleCallback or LinkCellRenderer.titleCallback.

[Parameter list]

grid - GridBase control

model - a cell in the grid

[return value] - alt text or title text

Example:

const f = function(grid, model) {
      return 'catimage'
}

GetCheckedCallback

Callback type that determines the check value when rendering

Remarks:

Used in CheckCellRenderer.getCheckedCallback.

[Parameter list]

grid - GridBase control

itemIndex - Order of items

column - a column object

value - the value

[Return value] - Checked or not

Example:

const f = function(grid, itemIndex, column, value) {
      if (typeof value === "number") {
          return value % 2 === 1;
      }
      else if (typeof value ==="boolean") {
          return value;
      }
      else {
          return Boolean(v);
      }
}

GetClassCallback

Add class to a tag of linkRenderer

Remarks:

Used when adding a class to the a tag of LinkCellRenderer.

[Parameter list]

grid - GridBase control

model - a cell in the grid

[return value] - string

Example:

const callback = function (grid, model) {
   let cls = "";
   model.value.indexOf("New post") > 0 && (cls += " new");
   model.value.indexOf("Secret post") > 0 && (cls += " lock");
   // When adding a new post/secret post icon to the link in background format
}
 

GetImageCallback

A callback format that specifies the path to the image for rendering.

Remarks:

Used in ImageCellRenderer.imageCallback or IconCellRenderer.iconCallback.

[Property List]

grid - GridBase control

model - a cell in the grid

[return value] - image path

Example:

const f = function(grid, model) {
      const base = '/images/';
      if (jpgSet.indexOf(model.value)){
          return base + model.value + '.jpg';
      }
      else base + 'default.jpg';
}

GetLinkUrlCallback

Callback format used in LinkCellRenderer.urlCallback

Remarks:

[Parameter list]

grid - GridBase control

model - a cell in the grid

[Return value] - Url address

Example:

...
      "renderer" : {
          "type": "link",
          "urlCallback": function (grid, cell) {
              return "http://realgrid.com";
          },
      }
...

GetShapeCallback

Callback format used in ShapeCellRenderer.shapeCallback to specify the type of shape in the shape renderer.

Remarks:

[Parameter list]

grid - GridBase control

model - a cell in the grid

[Return value] - Shape type, PolygonShape or 'ellipse'.

Example:

const f = function(grid, model) {
      if (model.value) {
          return 'ellipse';
      }
      else {
          return 'minus';
      }
}

GetTemplateCallback

Callback format used in TemplateCellRenderer.callback

Remarks:

[Parameter list]

grid - GridBase control

model - a cell in the grid

width - width of the cell

height - height of the cell

[Return value] - template format of string type

Example:

const f = function (grid, model, width, height) {
     return "<img src='images/realgrid-logo.png' height='" + height / 2 + "'></img>" + "<div>" + model.value + "</div>";
}
 
column.renderer = {
     type: "html",
     callback: f
}

GroupFooterCellSpanCallback

Callback to set custom groupFooter spanning

Remarks:

Used in CellLayoutColumnItem.

[Parameter list] grid - GridBase control

layout - layout item

itemIndex - the index of the row

footerIndex - index of groupFooter


GroupFooterStyleCallback

Callback to style the grid group footer row

Remarks:

This is the format used in RowGroupFooter.styleCallback.

[Parameter list] grid - GridBase control

itemIndex - the itemIndex of the footer

footerIndex - The index of the footer if there are multiple footers in the group.

Example:

var f = function(grid, itemIndex, footerIndex) {
     var dataRow = grid.getGroupModel(itemIndex, true).firstDataItem.dataRow;
     var value = grid.getDataSource().getValue(dataRow, "area2name");
     return value && value.indexOf("Gun") >= 0 ? `style-1-${footerIndex}` : undefined;
};
 
gridView.rowGroup.setFooters([{styleCallback: f},{styleCallback: f}]);

GroupFooterUserSpanCallback

Callback to set custom groupFooterUser span

Remarks:

Used in CellLayoutColumnItem.

[Parameter list] grid - GridBase control

layout - layout item

model - GroupModel

itemIndex - the index of the row

footerIndex - index of groupFooter


HeaderCallback

Callback that returns the text displayed in the row group header

Remarks:

This is the format used in RowGroup.headerCallback. RowGroup.headerStatement is ignored if present.

[Parameter list] grid - GridBase control

group - group item

Example:

gridView.rowGroup.headerStatement = undefined;
gridView.rowGroup.headerCallback = function(grid, group) {
      var ds = grid.getDataSource()
      if (group.level === 1) {
          return ds.getOrgFieldName(group.groupField) + " - " + group.firstDataItem.getData(group.groupField) + " - " + group.descendantCount + " rows"
      } else if (group.level === 2) {
          var sum = group.getSum("number");
          return isNaN(sum) ? "no sum" : ("sum => "+ sum.toString());
      } else {
          return "GroupLevel => "+group.level.toString()
      }
}

Holidays

Setup model for specifying public holidays

Remarks:

It is used when specifying using GridBase.setEditorOptions() or directly specifying in grid.editorOptions.holidays.

It is also used in DateCellEditor.

Example:

holidays: [
      {
          type: "date",
          dates : ["2020-01-24","2020-01-25","2020-01-26","2020-01-27"],
          styleName: "seollal",
          tooltips : ["Seollal 1","Seollal 2","Seollal 3","Seollal 4"]
      },
   ...
]

LayoutInfo

The information model of the layout returned by GridBase.saveColumnLayout()

Example:

// array of LayoutInfo
[
      {column: "OrderID", visible: true, width: 80},
      {column: "CustomerID", visible: true, width: 90},
      {
          name: "companyGroup"
          items: [
              {
                  name: "countryGroup"
                  items: [
                      {column: "Country", visible: true, width: 100},
                      {column: "Phone", visible: true, width: 100}
                  ]
                  visible: true;
                  direction: "horizontal",
                  width: 250,
                  header: {visible: true, text: "Country Group"}
              },
              {column: "CompanyName", visible: true, width: 100}
          ]
          visible: true;
          direction: "vertical",
          width: 250,
          header: {visible: true, text: "Company Group"}
      },
      {column: "EmployeeID", visible: true, width: 90}
]

LayoutItem

A type of layout item model that allows you to create columns of the desired type.

Remarks:

Used in GridBase.setColumnLayout().

[Concept Description]

span is a similar concept to html table's colspan (opens in a new tab).

The area is divided by the number of spans and the number of columns, and the area is divided by the sum of width and the following numbers.

It spans in layout units. In other words, if the next layout is a group, it spans the entire group.

You cannot span outside the group.

Groups cannot span.

Proceeds from left to right, top to bottom.

Span from the top layout first (top-down).

If the group spans the following layouts, newly added cells are distributed to child layouts.

(Distribution method: Distribute starting from the last layout according to the ratio of the number of cells in the lower layout.)

When rows are merged, there must be no row misalignment with the next layouts to be spanned.

fixed, rightFixed cannot cross the boundary.

Example:

[
        {
            name: "companyGroup",
            items: [
                {
                    column: "Country",
                    cellSpan: 3
                },
                20,20,
                {
                    column: "CompanyName",
                    cellSpan: 3
                },
                20,20,
            ],
            header: true
        },
        ...
    ];

ListCallback

Used to retrieve items that change according to callback conditions used when creating a list of DropDownCellEditor.

Remarks:

In order for DataColumn.lookupDisplay to be applied, DataColumn.labelField must be used. .

If undefined is returned while lookupSource is connected to the column, the data in the lookupSource is displayed.

[Parameter List]

grid - gridView

index - CellIndex


ListResult

return type of ListCallback or GridBase.onSearchCellButtonClick

Remarks:

When creating a list using ListCallback in IE11, you must add a Promise polyfill.


ListTemplateCallback

A callback used when the user writes an item displayed in the list in DropDownCellEditor or SearchCellEditor

Remarks:

[Parameter list]

grid - gridView

index - CellIndex

dom - div element

value - value

label - label

item - Information entered in DropDownCellEditor.listCallback or GridBase.fillEditSearchItems()

Example:

const columns = [
 {
     fieldName: "text",
     name: "text",
     editor: {
         type: "list",
         templateCallback: (grid, index, dom, value, label, item) => {
             dom.innerHTML = '<img src="images/flags/'+item.flag+'.png" style="width:20px" class="dropdown-image"></img>'+
             '<span> value = '+value+'></span>'+
             '<span style="color:red"> label = '+label+'</span>'+
             '<span style="background:lawngreen"> Country: '+item.name
         }
     }
 }
]

LookupData

Model information to populate LookupSource

Remarks:

Used as a parameter when fillLookupData().

Example:

// When using the rows property
gridView.fillLookupData("empLookup", {
      rows: [
          ["TOMSP", "5", "TOMSP_5X"],
          ["TOMSP", "6", "TOMSP_6X"]
      ]});
 
// When using key-value properties
gridView.fillLookupData("empLookup", {
      keys: [
          ["TOMSP", "5", "TOMSP_5X"],
          ["TOMSP", "6", "TOMSP_6X"]
      ],
      values: [
          ["TOMSP_5X"],
          ["TOMSP_6X"]
      ]});

MemoCallback

Format for specifying a callback to be executed when printing memos by cell in Export Excel Note

Remarks:

[Parameter List]

grid - The grid being exported

itemIndex - Index

dataRow - the dataRow of the row

column - Column name

cellMemo - Memo information model for the cell

[Return Value] - CellMemo | string | undefined

Example:

gridView.exportGrid({
    type:"excel",
    target:"local",
    exportMemo : {
        validation: true,
        callback: (grid, index, column, cellMemo) => {
            if (column == "LiteralCol") {
                cellMemo.author = 'Literal column author';
                cellMemo.message = 'This is a literal column area.';
                return cellMemo;
            }
            if (column === 'SaveCost') {
                return "Message";
            }
 
            return false;
        }
    }
});

MenuItemClick

Callback called when a menu item is clicked

Remarks:

GridBase.onMenuItemClicked and GridBase.onContextMenuItemClicked, PopupMenuItem.callback.

[Parameter list]

grid - GridBase control

menuItem - MenuItem object

clickData - Information about the clicked item

Example:

grid.addPopupMenu("menu1", [
         {
              label: "alpha",
              callback: function(grid, menuItem, clickData) {
                  console.log("aa")
                  console.log(menuItem);
                  console.log(clickData);
              }
         },
         {label: "beta"},
         {label: "gamma"}
]);

NumberOutputCallback

Callback function format to be performed when converting the number field

Remarks:

Used in DataOutputOptions.numberCallback.

[Parameter list]

ds - DataProvider control

row - the index of the item

field - field name

value - the value

[return value] - value to output

Example:

const f = function(ds, row, field, value) {
      let v = Number(value);
      return v === NaN ? 42:v;
}

MultiCheckDisabledCallback

Callback format that determines whether an item is disabled when rendering

Remarks:

Used in MultiCheckCellRenderer.disabledCallback.

[Parameter list]

grid - GridBase control

itemIndex - Order of items

column - a column object

value - value

[Return value] - Disabled or not

Example:

const f = function(grid, itemIndex, column, value) {
 const state = grid.getValue(itemIndex, "stateColumn");
 if (state === "A" && value === "Apple") {
 return true; // If the state is "A" and the value is "Apple", it cannot be selected.
 }
}
 
column.renderer = {
 type: "multicheck",
 disabledCallback: f
}
 

MultiCheckKeydownCallback

Callback type that determines the value to select or release on keydown in MultiCheckCellRenderer

Remarks:

Used in MultiCheckCellRenderer.keyToValueCallback.

[Parameter list]

grid - GridBase control

itemIndex - Order of items

column - a column object

event - KeyboardEvent object

values - values

[return value] - value to select

Example:

const f = (grid, itemIndex, column, event, values) => {
 if (event.ctrlKey && event.shiftKey) {
    const idx = event.keyCode - 49; // When the shift key is pressed, the key is a special character
    if (idx >= 0 && idx < values.length) {
        return values[idx];
    }
 }
}
 
column.renderer = {
    type: "multicheck",
    keyToValueCallback: f
}
 

ObjectToValuesCallback

A callback called for each row when data in json format is entered into the data provider.

Remarks:

Used when the type of data delivered from the server is different from the fieldName set as fields or when the value is arbitrarily changed.

Example:

dataProvider.valuesCallback = function (ds, obj) {
     let row = [];
     if (obj) {
         for (let i = 0, cnt = this.fieldCount; i < cnt; i++) {
             let fld = this.getOrgFieldName(i);
             let fName = Object.keys(obj).find(function(key) {return key.toLowerCase() === fld.toLowerCase()})
             if (obj.hasOwnProperty(fName)) {
                 row[i] = obj[fName];
             }
         }
     }
     return row;
}

OuterSortCallback

Callback format specified by the user when performing sorting

Remarks:

To use it in IE11, you must add a Promise polyfill.


ProgressCallback

A format for specifying a callback to be performed when showProgress is true in Grid Export Settings

Remarks:

[Parameter list] grid - If a grid or zip file is currently being exported, null is passed.

work - If the Grid is called while creating Excel, process is passed, and if it is called while creating a zip file, zip is passed. Called if jsZIP supports generateAsync.

max - maxPosition

position - Current position


RealizeHeaderCallback

Callback format used in ColumnHeader.templateCallback or CellLayoutGroupHeader.templateCallback

Remarks:

Used to retrieve values that are not specified in values among the fields entered in the template of the column header.

[Parameter list]

grid - GridBase control

header - Column header or group layout header

field - field name

[return value] - string

Example:

const f = function (grid, model, field) {
      if (field == "field1") {
          return "1234";
      } else if (field === "field2") {
          return "ABCD";
      } else {
          return "field Fail";
      }
}
 
column.header.template =
                "<img src='images/realgrid-logo.png' height='20'/>"+
                "<span style='color: red;font-weight: bold;'>${field1}</span>"+
                "<span style='color: blue'>${field2}</span>";
column.header.templateCallback = f;

RealizeSummaryCallback

Callback format used in ColumnSummary.templateCallback

Remarks:

ColumnFooter, HeaderSummary, Used to retrieve values that are not specified in values among the fields entered in the template of GroupFooter .

[Parameter list]

grid - GridBase control

column - column of the footer

summaryIndex - sequence number of the footer

summary - GroupItem for a footer object or groupFooter

field - field name

[return value] - string

Example:

const f = function (grid, column, summaryIndex, summary, field) {
      if (field == "field1") {
          return "1234";
      } else if (field === "field2") {
          return "ABCD";
      } else {
          return "field Fail";
      }
}
 
column.footer.template =
                "<img src='images/realgrid-logo.png' height='20'/>"+
                "<span style='color: red;font-weight: bold;'>${field1}</span>"+
                "<span style='color: blue'>${field2}</span>";
column.footer.templateCallback = f;

RealizeValueCallback

Callback format used in TemplateCellRenderer.valueCallback

Remarks:

[Parameter list]

grid - GridBase control

model - a cell in the grid

field - field name

[Return value] - template format of string type

Example:

const f = function (grid, model, field) {
      if (field == "xxx") {
          return "1234";
      }
}
 
column.renderer = {
      type: "html",
      template: "<img src='images/realgrid-logo.png' height='20'/>"+
                "<span>${value}-${value:unitprice}-</span>"+
                "<span style='color: red;font-weight: bold;'>${xxx}</span>"+
                "<span style='color: blue'>${value:Country}</span>",
      valueCallback: f
}

RowBarCellStyleCallback

Callback to specify cell style in RowBar area

Remarks:

This is the format used in CheckBar.cellStyleCallback.

[Parameter list] grid - GridBase control

type - One of check, indicator, state among GridCellType

index - the itemIndex of the cell

Example:

var f = function(grid, type, index) {
  if (grid.getValue(index, "field") === "TEST") {
    return 'style-test';
  }
}

RowBlockCallback

Callback to set the row block mask

Remarks:

Used in DisplayOptions.rowBlockCallback. If DisplayOptions.rowBlockType is RowMaskType.NONE, it is not reflected.

[Parameter list]

grid - GridBase control

itemIndex - Index of the selected row

[Return value] - Range of rows to apply Row Block Mask to, start: starting row, end: ending row

Example:

const f = function(grid, itemIndex) {
     let billNo;
     let ds = grid.getDataSource();
     let fld = ds.getFieldIndex("text1");
     let dataRow = grid.getDataRow(itemIndex);
     if (dataRow >= 0) {
         billNo = ds.getValue(dataRow, fld);
     } else {
         billNo = null;
     }
 
     let top = Math.min(grid.getTopItem(), itemIndex);
     let full = top + grid.fullItemCount();
     let startNo = top + full;
     let endNo = -1;
     let check1 = false;
 
     for (let i = top; i <= full; i++) {
         dataRow = grid.getDataRow(i);
         if (dataRow < 0) {
             continue;
         }
 
         let cBillNo = ds.getValue(dataRow, fld);
 
         if (cBillNo === billNo) {
             startNo = Math.min(startNo, i), endNo = Math.max(endNo, i);
             check1 = true;
         } else {
             if (check1) {
                 break;
             }
         }
     };
 
     if (startNo <= endNo && endNo > 0) {
         console.log(startNo)
         console.log(endNo);
         return { start: startNo, end: endNo };
     }
}

RowHeightCallback

Callback format that returns the height of the row

Remarks:

Specify the row height in the form of number or number[].

[Parameter list]

grid - GridBase control

type - [type] of row(/refs/realgrid#itemtype)

itemIndex - itemIndex of the row

[Return value] - Row height, in case of a multi-line row, it is specified when returned as an array.


RowObject

row object

Remarks:

One of the formats of DataValues


RowStyleCallback

Callback for changing row style

Remarks:

Should return the style class name.

Used in GridBase.setRowStyleCallback().

[Parameter list]

grid - GridBase control

item - row item

fixed - Is the line fixed?

[Return Value] - Style class name or RowStyleObject object

Example:

const f = function(grid, item, fixed) {
      if (fixed) {
          return 'custom-fixed-row';
      }
      else if (item.isDataRow) {
          var val =
          return 'custom-data-row';
      }
}
gridView.setRowStyleCallback(f)

RowValues

row data

Remarks:

One of the formats of DataValues


ScrollMessageCallback

A callback type that returns a message displayed on the screen indicating the scroll position when livescroll is not applied.

Remarks:

Used in DisplayOptions.scrollMessageCallback.

[Parameter list]

grid - GridBase control

isVertical - Whether to scroll vertically

itemIndex - Index of the item at the scroll position

[Return Value] - The text of the message displayed on the screen.

Example:

const f = function(grid, vertical, itemIndex) {
     let msg = grid.getValue(itemIndex, "area3name");
     return "<span style='color:blue;font-size:20px'>itemIndex = " + msg+"</span>";
}

SetCheckedCallback

Callback format that determines the check result value when editing

Remarks:

Used in CheckCellRenderer.setCheckedCallback.

[Parameter list]

grid - GridBase control

itemIndex - Order of items

column - a column object

oldValue - value before editing

checked - Checked status before editing

[Return value] - Check result value

Example:

const f = function(grid, itemIndex, column, oldValue, checked) {
      if (itemIndex % 2 === 0) {
          return checked;
      }
      else if (itemIndex % 17 === 0) {
          return oldValue
      }
      else {
          return false;
      }
}

SummaryCellSpanCallback

Callback to set custom headerSummary and footer spanning

Remarks:

Used in CellLayoutColumnItem.

[Parameter list] grid - GridBase control

layout - layout item

footerIndex - the index of the footer


TreeIconCallback

A callback that specifies the icon displayed next to the tree expander.

[Parameter list]

TreeView - tree view object

itemIndex - the index of the row

dataRow - the dataRow of the row

iconIndex - the value of the original iconIndex

[Return value] - The url of the icon or the sequence number of TreeOptions.iconImages


TreeTemplateEventCallback

Callback format used in TreeTemplateEvent.renderCallback

Remarks:

Called when the TreeRenderer is updated.

[Parameter List]

grid - GridBase control

model - cell information of the tree

element - HTMLElement

initialize - true if called immediately after the element is created, and false if called when the screen is updated.

Example:

treeView.treeOptions.templateOptions = {
    template: `<span class='custom-class'></span>`,
    events: [
        selector: 'span.custom-class',
        renderCallback(tree, model, element, initialize) {
            element.dataset["datarow"] = model.index.dataRow;
            element.innerHTML = model.value;
        }
    ]
}

UserCellsCallback

If there is a callback GridExportOptions.userCells that is used when the user adds output cells, it is not performed.

Remarks:

[Parameter list] grid - grid currently being exported

rowCount - Number of rows in sheet

colCount - Number of columns in the sheet

name - the name of the sheet

[Return Value] - Array of UserExportCell

Example:

var callback = function(grid, rowCount, colCount, sheetName) {
  return [{row:3, col: colCount -3, mergeCol: 3, text:"Show at the end of column", styles:{textAlign:"right"}}]
}
gridView.exportGrid({"type":"excel", "target":"local", "yOffset":4, userCellsCallback: callback});

ValueForGroupCallback

Although it is not the same value, it is used when the developer specifies a standard value when grouping it into one group. It must be returned with the same dataType as the dataType of the field.

Remarks:

This is the format used in RowGroup.valueForGroupCallback. [Parameter list]

grid - GridBase control

dataRow - dataRow

fieldName - fieldName

value - value

Example:

valueForGroupCallback = function(grid, dataRow, fieldName, value) {
if (value && fieldName === 'date1') {// Applies only to specific fields.
// Group data in date format using year and month.
return new Date(value.getFullYear(), value.getMonth());
};
      // If it has not changed, the original value must be reutrn.
return value;
}