PropertyEventMethodIndex
WebSquare.uiplugin.gridView - 5.0_4.4427B.20210603.112955

GridView. Renders large-volume data on a grid.
The user can display or edit large-volume data on grid.
The GridView must be bound with a DataList.
Provide various features - sub-total, grand-total, dynamic grouping, Excel Upload/Download, sorting, filtering, etc.
The top level uses the <div> tag under which the <table> and other tags are used.
Use column ID or header ID in the APIs of gridView.column.

Type

uiplugin

Property Summary

adaptive
Adaptive web design mode (in which page layouts adapt to the screen sizes and the device types.)
adaptiveThreshold
A threshold at which the layout enters the adaptive mode.
alwaysTriggerScrollStart
Triggers the onscrollstart event every time that the scroll reaches the first row of the GridView. (Options) "true" : Triggers the onscrollstart event every time reaching the first first row of the GridView. "false" (Default) : Triggers only once.</xmp>
applyAllColumnStyle
Applies all styles defined in the column.
arrowMove
Allows the end user to move to the next cell at the last character in the cell or to the previous cell at the first character in the cell using arrow keys. (Options) "true": Allows moving. "false" (Default) : Prevents moving.</xmp></xmp>
autoFit
Evenly distribute all columns of the GridView to fill up the full width of the GridView. [default: none, lastColumn, allColumn]
autoFitMinWidth
Minimum width of the GridView to apply autoFit="allColumn" setting. (Unit: px)
captionAuto
Combines the CaptionTitle with the header title of the table and displays it as the table title. false (Default) : Does not display.
captionTitle
Text to be displayed before the header title.
checkDisabledOnCut
Allows cutting through Ctrl (or cmd)+X in disabled="true" columns.
checkEditableInputClass
Removes "w2grid_input" class from nobr tag in case the cell is readOnly or disabled in the inputType = "text" column.
checkReadOnlyOnCut
Allows cutting through Ctrl (or cmd)+X in readOnly="true" columns.
checkReadOnlyOnPaste
Allows pasting through Ctrl (or cmd)+V in readOnly="true" columns.
checkReadOnlyOnPasteEnable
Set the columns to apply checkReadOnlyOnPaste="false".
class
Same as the class property in HTML.
columnMove
Allows column moving through header dragging.
columnMoveWithFooter
Moves the column and the footer. [default: false, true]
contextMenu
Uses the context menu.
contextMenuAltClick
Displays the context menu upon Alt + mouse left-clicking.
copyOption
When copying Gridview data, decide which value to copy - those defined in the DataList (“dataList”) or those currently display (“display”).
customFilterBox
Keeps the use-defined filter after groupby(); being executed. [default: false, true]
dataDragDrop
Allows dragging-n-dropping between the GridViews. [true, false]
dataDragSelect
Allows cell selection through dragging. [true, false]
dataDragSelectAutoScroll
Allows automatic scrolling when the mouse move out of the browser while multiple cells are dragged and selected (dataDragSelect="true").
dataDragSelectAutoScrollLevel
Time to double the current scrolling speed when the dataDragSelectAutoScroll is enabled. (Unit: ms) [default: 1300]
dataDragSelectAutoScrollPeriod
Scrolling interval when the dataDragSelectAutoScroll is enabled. (Unit: ms) [default: 70]
dataList
ID of the DataList to bind with the GridView component data.
defaultCellHeight
Default cell height
disabledBackgroundColor
Background color of the disabled (disabled="true") cell or row.
disabledFontColor
Font color of the disabled (disabled="true") cell or row.
disabledScrollHidden
Hides the scroll when disabled. [default: false, true]
dragDisplayColumn
Column ID to display on the tooltip when dragging data (dataDragDrop="true").
dragEndFunction
The function to be executed upon the end user's finishing dragging.
dragStartFunction
The function to be executed upon the end user's starting dragging.
drilldownToggleScrollFix
Fixes the scroll upon the end user’s opening the list by clicking + button on the drilldown column.
dynamic
Dynamically thorugh setGridStyle. [default: false, true]
editModeEvent
Mouse action event to edit the cell data.
editModeEventIcon
Mouse action to edit cell data in the viewType="icon" column.
enterKeyMove
Focus-moving direction upon end user’s pressing the Enter in the cell.
escape
Converts <>&" characters into HTML Escape characters.
euroMask
Masking value to be applied when the dataType is "euro" or when the changeCurrency API is used.
evenRowBackgroundColor
Background color of the even rows
excludeDeletedRows
Excludes the deleted rows when calculating subtotal and total in the footer.
excludeModifiedRows
Excludes the rows of which status has been changed to “d” by modifyRowStatus API from subtotaling and totaling (in the foot) expressions.
fastScroll
Adds fast scrolling effects to vertical scrolling.
filterBoxvisibleRowNum
Number of the conditions to be displayed on the filtering condition list
filterFocusMode
Whether to remove the focus or not on the selected cell or row in the body before the sorting event is triggered.
filterShowAlways
Shows the filtering icon first when the width of the column with useFilter=true setting is small.
fixedColumn
Column to fix.
fixedColumnNoMove
Allows moving (columnMove) of the column that is fixed by fixedColumn property.
fixedColumnScrollHidden
Hides the scroll on the fixed columns.
fixedColumnWithHidden
Includes the hiddenColumn when calculating the position of the fixedColumn property.
fixedRow
Rows to fix.
focusDefaultColumn
When set as true, both the rowNum and the rowStatus columns can get the focus.
focusFlow
Sets the focus-flowing directions.
focusMode
Mode to display the focusing in the cell.
focusMove
Ignores the focus upon moving by the arrow keys.
footerCaption
Footer caption.
footerCaption
caption of the grid footer
footerCaptionAuto
Automatically generates the footer text for the footerCaption property regardless of the captionAuto setting. [default: false, true] (Related Property) captionTitle footerCaption</xmp></xmp>
footerSummary
Summary of the footer.
footerSummary
grid footer summary
footerSummaryAuto
Automatically generates footer in the footer summary regardless of the captionAuto setting. [default: ""(Empty string)] (Related Property) captionTitle footerSummary</xmp></xmp>
groupbyFilterBox
Displays the filtering conditions when using the groupby (filtering) feature.
groupbyFilterBoxFormatter
Formats the labels to be displayed on the filtering condition list (groupbyFilterBox).
groupbyFilterBoxLocation
Location of the filtering condition box (groupbyFilterBox). (Options) "top" : Display at the top. “bottom” (Default): Display at the bottom.</xmp></xmp>
groupbyMaxCount
Set the maximum number of the columns to which groupby can be applied.
groupbyZone
Uses groupby feature or not.
groupbyZoneHeight
Height of groupbyZone.
groupbyZoneMessage
Message to display when the groupbyZone is in initial state.
hammerEnabled
Hammers the dblclick event in the mobile.
hammerPressTime
Time to hold until the press event is triggered.
hideHeader
Hides the header.
id
Component ID
ignoreCellClick
Ignore cell clicking.
ignoreNonEditableCell
Ignores Tab or Enter key pressing when cell editing is not allowed.
ignoreNonEditableCellTabEnter
Allows moving between readOnly cells when the ignoreNonEditableCell is “true”.
ignoreToggleOnDisabled
Ignores toggle image clicking on a disabled cell upon drill-down.
initFixedHeightByRowNum
Initializes the GridView height based on the number of the rows of the initially rendered GridView.
keepDefaultColumnWidth
Fixes rowNum and rowStatus columns when autoFit is used.
keyMoveEditMode
Immediately enters the editing mode upon the end user’s pressing Tab or Enter key moving the focus.
loadCount
Number of the remaining rows to trigger the onscrollend event.
mergeCells
Merges adjacent cells of the same data in the same row or on the same column.
mergeCellsFixedCols
Merges adjacent cells with the same data in the fixedColumn.
mergeCellsFixedRows
Merges adjacent cells with the same data in the fixedRow.
mergeCol
Specify columns to apply the mergeCells property.
moveKeyEditMode
Immediately enters the editing mode upon the end user’s pressing Up or Down keys moving the focus.
moveKeyEditModeAll
Enter the editing mode upon the end user’s pressing Up, Down, Left, and Right key moving the focus. [default: false, true] (Options) "true": Enters the editing mode upon the end user’s pressing Up, Down, Left, and Right keys. "false" (Default) : Moves the focus only upon the end user’s pressing Up, Down, Left and Right keys. </xmp></xmp>
nextTabID
The ID of the component to be selected upon the end user’s pressing the Tab key.
noResultMessage
Message to display when there is no search result. (When there is 0 data in the DataList.)
noResultMessageClass
Class to apply to the noResultMessage. (When there is 0 data in the DataList.)
noResultMessageStyle
Class to apply to the noResultMessage. (When there is 0 data in the DataList.)
noResultMessageVisible
Message to display when there is no search result. (When the DataList has 0 data.)
noSelect
Prevents cell text selection through mouse dragging (useCtrlKey="true") (useShiftKey="true").
numberMask
Masking value to be applied when the dataType is "number" or when the changeCurrency API is used.
oddEvenColorDisplay
Uses different colors in odd and even rows.
oddRowBackgroundColor
Background color of the odd rows
overflowX
Uses horizontal scrolling.
overflowY
Uses vertical scrolling.
pasteOption
Pastes the data to the clip board through Ctrl (or cmd) + V.
preventAddRowOnPaste
Prevents adding of a new row upon pasting data from the clipboard through Ctrl (or cmd)+V.
preventCopy
Prevents copying of the GridView data through Ctrl (or cmd)+C or Ctrl (or cmd)+X. [default: false, true]
preventCopyColumn
Column ID to prevent copying of the data to the clipboard through Ctrl (or cmd) + C.
preventMultisort
Prevent multiple-sorting.
preventPaste
Prevents pasting of the data to the clip board through Ctrl (or cmd) + V.
preventPasteColumn
Column ID to prevent pasting of the data to the clipboard through Ctrl (or cmd) + V.
readOnly
Allows reading only. [default: false, true]
readOnlyBackgroundColor
Background color of the cell of which readOnly property is true.
readOnlyBackgroundImg
Path of the cell background image of which readOnly property is true.
readOnlyBackgroundImgCSS
Path of the cell background image of which readOnly property is true.
readOnlyPriority
readOnlyTabIgnore
Ignores readOnly cell upon Tab key being pressed.
resize
Allows column width adjustment through column dragging.
rowMouseOver
Displays the background color of the currently moused-over row.
rowMouseOverColor
Background color of the row upon the end user's hovering the mouse over the row.
rowNumBackgroundColor
Background color of the Body column.
rowNumHeaderValue
Header text.
rowNumLocaleRef
localeRef key to set in the rowNum column.
rowNumStatusResize
Allows resizing of the widths of rowNum and rosStatus columns.
rowNumStatusUniqueId
Uses unique IDs when rowNum and rowStatus columns are used. [default: false, true]
rowNumVisible
Displays the row numbers based on the data of the bound DataList.
rowNumWidth
Width of the rowNum column when rowNumVisible is "true".
rowStatusHeaderValue
Header text.
rowStatusLocaleRef
localeRef to set in the rowStatus column.
rowStatusVisible
Displays row status (Add/Modify/Remove) on a separate column.
rowStatusWidth
Width of the rowStatus column when rowStatusVisible is "true".
rupeeMask
Masking value to be applied when the dataType is "rupee" or when the changeCurrency API is used.
scrollByColumn
Horizontally scrolls by column.
scrollByColumnAdaptive
Moves scrolls by column in the adaptive mode.
selectedCellColor
Background color of the selected cell.
selectedCellOverColor
Background color of the cell to be displayed upon the end user’s hovering the mouse over the cell.
selectedRowColor
Background color of the selected cell
selectedRowOverColor
Background color of the row to be displayed upon the end user’s hovering the mouse over the cell.
senseReader
A mode to support web accessibility requirements. [default: false, true] (Options) "false" (Default) "true": Allows the end user to rotate through all cells using the Tab key. </xmp></xmp>
setCellInputTypeCustom
An option to dynamically change the inputType of the cell of which inputType is custom.
showImageTooltip
Displays the tooltip for inputType = "image".
showSortableImage
Shows sorting images on the header of the sortable column.
showSortableUseFilter
Displays the sortable and the useFilterList icons on the header when both the useFilterList and the showSortableImage properties are in use. [default: false, true] (Options) "true": Displays both the user-defined filter icon and the sorting icon. "false" (Default) : Display only the sorting icon.</xmp></xmp>
sortable
Whether to support data sorting by the end user's clicking the header on the GridView component.
sortedIconPosition
Position to show the sorting icon.
sortEvent
Define the sorting events. [default: ondblclick, onclick]
sortOrderReverse
Sorts the data in descending powers first upon user's clicking the header.
summary
Similar to the summary property of the table tag in HTML.
summaryAuto
Automatically sets the header column name in the summary to support web accessibility.
summaryOnlyAuto
Sets the summary only with text without tags if the header title includes HTML. [default: false, true] (Options) "true": Sets the text only without the HTML tag as the summary. "false" (Default) : Sets the text and the HTML tag as the summary.</xmp></xmp>
syncScroll
Scrolls down multiple GridViews at the same time.
syncScrollId
ID of the GridView to synchronize scrolling.
tengeMask
Masking value to be applied when the dataType is "tenge" or when the changeCurrency API is used.
titleAuto
Disable the component. [default: false, true]
titleFormatter
Uses the user-define value as the title. [default: false, true]
tooltipDisplay
Displays hidden data as a tooltip when the data is not fully displayed.
tooltipDisplayColumn
Sets the column name to display tooltip on certain columns
tooltipFormatter
Name of the function to format the tooltip contents when the tooltipDisplay is “true”.
tooltipFormatterHeader
Name of the user-defined function to format the tooltip contents when the tooltipDisplay is “true”.
tooltipHeader
Provides multi-language support. [default: false, true]
tooltipHeaderShowAlways
Always shows the tooltip upon the end user’s hovering the mouse regardless of the text length. [default: false, true]
tooltipPositionX
X coordinate of the tooltip. (Unit: px) [default: 20]
tooltipPositionY
X coordinate of the tooltip. (Unit: px) [default: cellHeight+3]
tooltipShowAlways
Always shows the tooltip. [default: false, true]
tooltipShowAlwaysColumns
Columns to display tooltip always. [default: ""]
useCtrlKey
Allows selection of multiple cells through using the Ctrl key.
useCtrlOnMultisort
Allows selection of multiple columns using Ctrl key to sort multiple columns.
useFilterList
Displays the filter list. [default: false, true]
useFilterListSync
Displays the filter done by setFilter(); or setColumnFilter(); function of the DataList. [default: false, true]
useLocale
Multilanguage support
userData1
User-defined property.
userData2
User-defined property.
userData3
User-defined property.
useShiftKey
Whether to allow selection of multiple cells through the use of the Shift key.
visibleRowNum
Number of the rows to be displayed on the screen.
visibleRowNumFix
Automatically adjusts the initial height of the GridView according to the visibleRowNum or initFixedHeightByRowNum setting. [default: true, false]
wheelRows
Number of the rows changing upon the end user's clicking the vertical scrolling bar each time.
wheelStop
Stops scrolling although the user moves the mouse wheel when the scroll is at the bottom.

Event Summary

onaftercolumnmove
Triggered right after a column moving.
onaftercolumnresize
Triggered right after column resizing.
onafteredit
Triggered upon the focus moving of the cell after editing is done.
onbeforecolumnmove
Triggered right before column moving.
onbeforeedit
Triggered before entering into the cell editing mode.
onbeforesort
Triggered right before column sorting. Returns the sorting status.
onblankclick
Triggered upon end user’s clicking empty part within the GridView.
onbodymouseout
Triggered when the mouse moves out of the GridView body.
onbodymouseover
Triggered upon the end user's hovering the mouse over the body.
oncellclick
Triggered upon the end user's clicking the cell.
oncelldblclick
Triggered upon cell being double-clicked.
oncellindexchange
Triggered upon the end user's selecting a cell and changing the cell through the use of an arrow key, mouse clicking, or a method.
oncolumnindexchange
Triggered upon the end user's selecting a cell and changing the column through the use of an arrow key, mouse clicking, or a method.
oncolumnwidthchange
Triggered upon a change in the column length.
oncustomcopy
Define an event to replace the copy event of the GridView.
oncustompaste
Define an event that will replace the paste event of the GridView.
ondatadragover
Triggered upon data being moved over another Gridview when the dataDragDrop is “true”.
ondatadragstart
Triggered upon data dragging when the dataDragDrop is “true”.
ondatadrop
Triggered upon the data being dropped on another GridView when the dataDragDrop is “true”.
ondateselect
Triggered upon selection of a date when the inputType is “calendar”.
oneditdblclick
Triggered upon the end user’s double-clicking the cell being edited.
oneditend
Triggered upon the end user's finishing editing the cell data. Triggered before the onafteredit.
oneditkeydown
Triggered upon the end user’s pressing the key while a cell is being edited.
oneditkeyup
Triggered upon the end user's releasing a key off the keyboard after pressing the key.
onfilereadend
Triggered after an Excel file is uploaded to the GridView component.
onfooterclick
Triggered upon the footer being clicked.
onheaderclick
Triggered upon the header being clicked.
onheaderdblclick
Triggered upon the end user's double-clicking the header.
onkeydown
Triggered upon the end user's pressing a key on the keyboard.
onkeyup
Triggered upon the end user's releasing a key off the keyboard after pressing the key.
onmonthselect
Triggered upon selection of a date when the inputType is “calendar”.
onrightbuttonclick
Triggered upon the end user's right-clicking the cell in the body part.
onrowindexchange
Triggered upon the end user's selecting a cell and changing the row of the selected cell through the use of an arrow key, mouse clicking, or a method.
onrownumclick
Triggered upon the rowNum column being clicked.
onrowstatusclick
Triggered upon the rowStatus column being clicked.
onscrollend
Triggered when the vertical scrolling reaches the bottom.
onscrollstart
Triggered when the vertical scrolling reaches the top.
onscrollx
Triggered upon the end user's horizontal scrolling.
onscrolly
Triggered upon the end user's vertical scrolling.
onsort
Triggered upon a change in the sorting method by clicking or double-clicking on the sorted header.
onsubtotalclick
Triggered upon clicking of the subtotal.
onsubtotaldblclick
Triggered upon double-clicking of the subtotal.
ontextimageclick
Triggered when the image of which inputType is textImage is clicked.
ontoggleclick
Triggered upon clicking of the toggling button when the inputType is drilldown.
onviewchange
Triggered when the value on the list is changed through keyboard input or mouse clicking.
onyearselect
Triggered upon selection of a date when the inputType is “calendar”.

Method Summary

advancedExcelDownload( options , infoArr )
Saves the grid data as an Excel file.
advancedExcelUpload( options )
Reads an Excel file, and sets the read data in the GridView. (Supported for JDK 1.5 or higher.)
changeCurrency( columnID , dataType , displayFormat , delimiter , decimalDelimiter )
Dynamically changes the monetary unit in the cell displayed on the column basis.
checkAll( colIndex , dataValue )
Selects or unselects all rows with checkboxes.
clearAutoFit( )
Removes the autoFit property.
clearGroupby( )
Cancels the groupBy setting.
clearRowVisible( )
Shows all rows hidden by the setRowVisible API.
drillTo( rowIndex )
Opens all parent rows when showing the row of the given row index through drilldown.
getAllDisplayData( )
Returns the currently displayed data as a one-dimensional array. (displayFormat-applied data.)
getAllDisplayJSON( )
Returns the currently displayed data as JSON data. (displayFormat-applied data.)
getAllDisplayXML( )
Returns the currently displayed data as XML data. (displayFormat-applied data.)
getAllFocusedIndex( )
Returns rowIndex and colIndex of the selected cells.
getAllFocusedRowIndex( )
Returns rowIndex of the focused cells selected by the Ctrl key.
getAllVisibleData( )
Returns the currently displayed data as a one-dimensional array (being filtered).
getAllVisibleJSON( )
Returns the currently displayed data as JSON data. (displayFormat-applied data.)
getAllVisibleXML( )
Returns the currently displayed data as an XML (being filtered).
getAncestorRowIndexArray( rowIndex )
Returns the rowIndex of all parents of the specified row to support drill-down.
getBottomRowIndex( )
Returns rowIndex of the lowest row on the currently visible GridView component.
getCellBackgroundColor( rowIndex , colIndex )
Returns the background color of the cell of the corresponding rowIndex and the corresponding colIndex.
getCellChecked( rowIndex , colIndex )
Returns whether the cell of the corresponding rowIndex and the colIndex is checked or not.
getCellClass( rowIndex , colIndex )
Returns the name of the user class dynamically applied to the Grid cells.
getCellColor( rowIndex , colIndex )
Returns the Text color of the cell of the corresponding colIndex and the rowIndex.
getCellDisabled( rowIndex , colIndex )
Returns the value of the disabled property of the cell of the corresponding colIndex and the rowIndex.
getCellDisplayData( rowIndex , colIndex )
Returns the displayed data of the cell of the corresponding rowIndex and the colIndex (with displayFormat being applied).
getCellPosition( row , colIndex , propertyName )
Returns the position of the cell (top or left).
getCellReadOnly( rowIndex , colIndex )
Returns the value of the readOnly property of the cell of the corresponding colIndex and the rowIndex.
getCellSize( row , colIndex , sizeName )
Returns the cell size (width or height).
getCheckedData( colIndex )
Returns the data of the checked row as an array when the column is of the corresponding colIndex and is a Radio or CheckBox component. If the column is not a Checkbox component, an empty array will be returned.
getCheckedIndex( colIndex )
Returns the index of the checked row as an array when the column is of the corresponding colIndex and the inputType property of the column is Radio or Checkbox.
getCheckedJSON( colIndex )
Returns the JSON data of the checked row as an array when the column of the corresponding colIndex is a Radio or Checkbox.
getCheckedXML( colIndex )
Returns the data of the checked row as an XML when the column of the corresponding colIndex is a Radio or CheckBox.
getChildrenRowIndexArray( rowIndex )
Returns the rowIndex of the children (one-depth below) of the row of the corresponding rowIndex as an array when drilling-down is enabled.
getColIdByHeaderId( headerId )
Returns the columnId of the body corresponding to the columnId of the header.
getColumnBackgroundColor( colIndex )
Returns the background color of the column of the corresponding colIndex.
getColumnColor( colIndex )
Returns the Text color of the column of the corresponding colIndex.
getColumnDataListInfo( colIndex )
Returns the dataList bound with the column of the specified colIndex.
getColumnDisabled( colIndex )
Returns the value of the disabled property of the row of the corresponding colIndex.
getColumnID( colIndex )
Returns the value of the disabled property of the column of the corresponding colIndex.
getColumnIdListMultiRow( )
Returns all column IDs of the GridView as two-dimensional array data.
getColumnIndex( colIndex )
Receives the column ID, and returns the corresponding column index.
getColumnNodeSet( colIndex )
Returns the nodeset of the column when the inputType = "select" or "autoComplete".
getColumnOrder( byName )
Returns the current sequence of the columns as an array.
getColumnReadOnly( colIndex )
Returns the value of the readOnly property of the column of the corresponding colIndex.
getColumnType( colIndex )
Returns the inputType of the colIndex column.
getColumnVisible( colIndex )
colIndex에 해당하는 열의 visible여부를 반환
getDataDragDrop( )
Returns the dataDragDrop setting.
getDataLength( )
[deprecated] Use getRowCount() instead.
getDataList( )
Returns the Id of the currently bound DataList.
getDataListInfo( )
Returns the dataList bound with the component.
getDataType( colID )
Returns the dataType of the column.
getDescendantRowIndexArray( rowIndex )
Returns rowIndex of all children of the specified row to support drill-down.
getDisabled( type , rowIndex , colIndex )
Returns the value of the disabled property according to the type.
getFixedColumnLastIndex( includeDefaultColumn )
Returns the most right column index among the fixed columns.
getFixedRightColumnLastIndex( )
returns the most right column index among the fixed right columns when the FixedRightColumn property is set.
getFixedRow( )
Returns the location of the fixed row when the GridView is horizontally fixed.
getFocusedColumnID( )
Returns the ID of the column of the currently focused cell.
getFocusedColumnIndex( )
Returns the colIndex of the currently focused cell.
getFocusedRowIndex( )
Returns the rowIndex of the currently focused cell.
getFocusedRowStatus( )
Returns the status of the row in which the currently focused cell exists in status string.
getFooterData( footerId , display )
Returns the footerId of the footer.
getFooterStyle( footerId , style )
Gets the style properties of the footer of the corresponding footerId.
getFormattedHeaderValue( headerId , value )
Returns the header value formatted by the dispalyFormat.
getGridReadOnly( )
Returns the readOnly property or the entire GridView.
getHeaderBackgroundColor( headerId )
Returns the background color of the header cell.
getHeaderClass( headerId )
Returns the name of the user class dynamically applied to the header cell of the Grid.
getHeaderColor( headerId )
Gets the Text color of the header cell.
getHeaderID( header )
Returns the header ID through the header index.
getHeaderIndex( header )
Gets the header index through the header ID.
getHeaderPosition( headerId , propertyName )
Returns the position of the header cell (top or left).
getHeaderSize( headerId , sizeName )
Returns the size of the header cell (width or height).
getHeaderValue( headerId )
Returns the value of the header.
getMaxLength( colIndex )
Returns the maxLength of the column.
getMerged( rowIndex , colIndex )
Returns the merging state of the specified cell.
getOpenStatus( rowIndex )
Returns whether the row of the corresponding rowIndex can be drilled down in a Boolean value when the drilling-down is enabled for the entire GridView.
getOverflowX( )
Returns the setting of the overflowX property.
getOverflowY( )
Returns the setting of the overflowY property.
getParentRowIndex( rowIndex )
Returns the rowIndex of the parent row of the row of the corresponding rowIndex when drilling-down is allowed.
getReadOnly( type , rowIndex , colIndex )
Returns the value of the readOnly property depending on the type.
getRealRowIndex( rowIndex )
Returns the rowIndex of the actual data based on the rowIndex displayed on the screen when drilling-down is enabled.
getRowBackgroundColor( rowIndex )
Returns the background color of the row of the corresponding rowIndex.
getRowColor( rowIndex )
Returns the Text color of the row of the corresponding rowIndex.
getRowDisabled( rowIndex )
Returns the disabled setting of the specified row.
getRowNumVisible( )
Returns the option values of the rowNumVisible.
getRowReadOnly( rowIndex )
Returns the value of the readOnly property of the row of the corresponding rowIndex.
getRowVisible( rowIndex )
Hides or shows specified rows.
getSortableArr( )
Returns the sortable status of the header columns as an array.
getSortableStatus( )
Returns header information as an array in the sequence of the sorted columns.
getTopRowIndex( )
Returns the rowIndex of the top row on the current screen.
getTotalCol( )
Gets the total number of the columns.
getTotalHeaderCol( options )
colIndex에 해당하는 열의 visible여부를 반환
getTotalRow( )
Gets the total number of the rows.
getUncheckedData( colIndex )
Returns the data of the unchecked row as an array when the column of the corresponding colIndex is a Radio or CheckBox.
getUncheckedIndex( colIndex )
Returns the index of the unchecked row as an array when the inputType of the column of the corresponding colIndex has a Radio or CheckBox component.
getUncheckedJSON( colIndex )
Converts the data of the unchecked row into JSON data and returns as an array when the column of the corresponding colIndex is radio or checkbox.
getUncheckedXML( colIndex )
Returns the data of the unchecked row as an XML when the inputType of the column of the corresponding colIndex is radio or checkbox.
getVisibleColData( colIndex )
Returns the currently displayed (filtered or sorted) data of the column of the corresponding colIndex as an array.
getVisibleRowNum( )
Returns the number of the visible rows.
groupby( Options )
Groups two or more columns and displays only the grouping result (statistical data).
hasChild( rowIndex )
Returns whether the row of the corresponding rowIndex has a child row or not when drilling-down is enabled.
hideGroupbyZone( )
Hides the groupbyZone area.
initGrid( )
Deletes the entire date and the filtering conditions and initializes the column information (such as the nodeset of the SelectBox component) and returns the data as a one-dimensional array.
isEditing( )
Returns the current editing status of the GridView.
mergeByCol( options )
Merges repetitive data cells within the same column.
mergeByColRec( options )
Executes mergeByCol and mergeByRow for the cells not merged.
mergeByRestriCol( options )
Merges the rows when the same data is repeated within the column and the column on the left is merged.
mergeByRestricRow( options )
Merges the rows when the same data is repeated within the same row and the upper row is merged.
mergeByRow( options )
Merge the cells with the same data within the same row.
mergeByRowRec( options )
Executes mergeByRow and mergeByCol for the cells not merged.
mergeCell( mergeInfo )
Dynamically merges cells.
mergeCells( mergeOptionStr , options )
Merges adjacent cells of the same data in the same row or on the same column.
mergeCellsFixedCols( mergeOptionStr , options )
Executes mergeCells within the fixedColumn area.
mergeCellsFixedRows( mergeOptionStr , options )
Executes mergeCells within the fixedRow area.
mergeClear( )
Unmerges all cynamically merged cells.
mergeCol( colIndex , flag )
Excludes a certain column from automatic merging based on the data.
mergeFocusedCell( )
Merges only the currently focused cells.
mergeRow( rowIndex , flag )
Excludes a certain row from automatic merging based on the data.
mergeSplitFocusedCell( )
Splits the currently focused cell merged.
modifyCheckedStatus( colIndex , status )
Changes the status codes of all checked rows when the inputType of the specified column is checkbox.
modifyUncheckStatus( col , status )
Changes the status codes of unchecked rows when the inputType of the specified column is checkbox.
moveFooterColumn( fromIdx , toIdx )
Moves the footer column from fromIdx to toIdx.
readCSV( options )
Reads a CSV file and sets the grid data.
redrawColumn( colIndex , valid )
Resets the specified column.
refreshCell( rowIndex , colIndex )
Refreshes the cell of the corresponding index.
refreshColumn( colIndex )
Refreshes the column of the specified index.
refreshColumnItemset( col )
Valid only when the inputType is Select. Updates the itemset of the specified column.
refreshRow( rowIndex )
Refreshes the row of the specified index.
removeCellClass( rowIndex , colIndex )
Removes the user-defined class from the Grid cell.
removeFocusedCell( )
Removes focus from all (selected) cells.
removeFocusedMultiCell( startRow , startCol , endRow , endCol )
Removes focuses from the cells within the specified rectangular area.
removeHeaderClass( headerId )
Removes the user class applied to the header cell of the Grid.
saveCSV( options )
Saves the data as a CSV file.
setAutoFit( options )
Sets the autoFit property.
setBottomRowIndex( bottomRowIndex )
Sets the row of the corresponding bottomRowIndex to the bottom of the currently displayed area of the GridView component. (Moves the vertical scroll bar.)
setCaption( htmlStr )
Defines the HTML caption property or the GridView component.
setCaptionAuto( captionTitle )
Sets the captionTitle as the table title.
setCellAllowChar( rowIndex , colIndex , allowChar )
Changes the allowChar setting of a certain cell.
setCellBackgroundColor( rowIndex , colIndex , color )
Sets the background color of the cell of the corresponding rowIndex and the colIndex.
setCellChecked( rowIndex , colIndex , flag )
Selects or unselects the cell in inputType="checkbox" or "radio" column.
setCellClass( rowIndex , colIndex , className )
Dynamically applied the user class to the Grid cell.
setCellColor( rowIndex , colIndex , color )
Sets the Text color of the cell of the corresponding rowIndex and the colIndex.
setCellCustomFormatter( rowIndex , colIndex , formatter )
Changes the setting of the customFormatter property of a certain cell.
setCellDataType( rowIndex , colIndex , dataType )
Changes the setting of the dataType property of the certain cell.
setCellDisabled( rowIndex , colIndex , disabled )
Sets the value of the disabled property of the cell of the corresponding colIndex and the rowIndex.
setCellDisableEdit( rowIndex , colIndex , onoff )
Changes the disableEdit property when the inputType=“custom” cell is autoComplete.
setCellDisplayFormat( rowIndex , colIndex , displayFormat )
Changes the setting of the displayFormat property of a certain cell.
setCellDisplayFormatter( rowIndex , colIndex , formatter )
Changes the setting of the displayFormatter property of a certain cell.
setCellInputType( rowIndex , colIndex , info )
Sets the inputType of the cell of the specified rowIndex and the colIndex.
setCellMaxLength( rowIndex , colIndex , maxLength )
Changes the maxLength setting of the specified cell.
setCellReadOnly( rowIndex , colIndex , readOnly )
Sets the value of the readOnly property of the cell of the corresponding colIndex and the rowIndex.
setColumnBackgroundColor( colIndex , color )
Sets the background color of the column of the corresponding colIndex.
setColumnChooseOption( colIndex , chooseOptionValue , chooseOptionLabel )
Changes the value and the label of the chooseOption property when the inputType is select in the gridView column.
setColumnColor( colIndex , color )
Sets the Text color in the column of the corresponding colIndex.
setColumnDisabled( colIndex , disabled )
Sets the disabled property for all rows of the corresponding colIndex.
setColumnDisableEdit( rowIndex , onoff )
Changes the disableEdit property of the inputType=“autoComplete” column.
setColumnDisplayFormat( colIndex , displayFormat )
Sets the value of the displayFormat property of the column. Replaces the existing setDisplayFormat API.
setColumnDisplayFormatter( colIndex , displayFormatter )
Sets the value of the displayFormatter property of the column.
setColumnGridItemset( colIndex , obj )
Dynamically changes the gridViewItemset when inputType = "select" and gridViewItemset are used.
setColumnIoFormat( colIndex , ioFormat , dateMast )
Sets the ioFormat property of the column.
setColumnNodeSet( colIndex , nodeset , label , value )
Sets the nodeset of the column for which an itemset can be set.
setColumnOrder( columnOrderArray )
Rearranges the order of the columns based on the given array. The columns not specified by the parameter will be put after the columns specified by parameters.
setColumnReadOnly( colIndex , readOnly )
Sets the value of the readOnly property or the column of the corresponding colIndex.
setColumnVisible( colIndex , colVisibleFlag )
Hides or displays the column.
setColumnVisibleColumn( gridColumnId , visibleColumnId , visibleColumnFalseValue )
Hides some of the selection item list of the selected GridView column.
setColumnWidth( colIndex , size )
Changes the width of the column.
setCustomFormatter( colIndex , customFormatter )
Sets the customFormatter setting of the column.
setDataDragDrop( onoff )
Changes the dataDragDrop setting of the Grid.
setDataType( colIndex , dataType )
Sets the dataType of the column.
setDisabled( type , rowIndex , colIndex , disableFlag )
Sets the disabled property according to the type.
setDrillDownDragDrop( value )
Sets drag-n-drop in the drill-down column.
setFixedColumn( fixedColNum )
Fixes the column.
setFixedRightColumn( count )
Dynamically sets the number of the columns to set to the right (fixedRightColun).
setFocusedCell( rowIndex , colIndex , editMode )
Focuses (or selects) the cell and moves to the cell.
setFocusedHeaderObj( headerId )
Sets the focus to the header when the inputType is an object such as selectbox or checkbox, not Text.
setFocusedMultiCell( startRow , startCol , endRow , endCol )
Focuses the cells within the specified rectangular area.
setFooterCaption( htmlStr )
Sets the innerHTML for the footer table caption.
setFooterData( footerId , data )
Sets the data in the footer when the inputType of the footer is Text.
setFooterDisplayFormat( footerId , displayFormat )
Sets the displayFormat of the footer.
setFooterStyle( footerId , style , value )
Sets the style of the footer cell.
setFooterSummary( str )
Sets the summary for the footer table.
setFooterValue( footerId , data )
Sets the data value in the footer when the inputType of the footer is text.
setGridHeight( height )
Sets the height of the GridView.
setGridReadOnly( readOnly )
Enables the readOnly for the entire GridView.
setGridSize( width , height )
Sets the height and the width of the GridView component.
setGridWidth( width )
Sets the width of the GridView.
setHeaderBackgroundColor( headerId , color )
Sets the background color of the header cell.
setHeaderClass( headerId , className )
Dynamically applies the user class to the header cell of the Grid.
setHeaderColor( headerId , color )
Sets the Text color of the header cell.
setHeaderDisabled( headerId , disabled )
Sets the disabled property or the header.
setHeaderHide( hide )
Hides or displays the header.
setHeaderNodeSet( headerId , nodeset , label , value )
Valid when the inputType of the header is select. Sets the nodeSet of the list.
setHeaderSortImage( headerId , orderNum , sortOrd )
Sets the sorting image of the header. Data sorting must be made by the sorting method of the Datalist.
setHeaderStyle( headerId , style , value )
Sets the style for the header cell of the corresponding headerId in the GridView.
setHeaderValue( headerId , value , useFormat )
Sets the value formatted by the displayFormat in the header.
setImageSrc( colIndex , src )
Dynamically changes the image when the inputType is textimage.
setMaxLength( colIndex , len )
Sets the maxLength of the GridView column.
setNoResultMessage( message )
Sets the message to display when there is no data in the GridView component.
setNoResultMessageVisible( visible )
Dynamically sets the noResultMessageVisible.
setReadOnly( type , rowIndex , colIndex , readOnlyFlag )
Controls the "readOnly" property.
setRowBackgroundColor( rowIndex , color )
Sets the background color of the row of the corresponding rowIndex.
setRowColor( rowIndex , color )
Sets the Text color of the row of the corresponding rowIndex.
setRowDisabled( rowIndex , disableFlag )
Sets the disabled property of the row of the corresponding rowIndex.
setRowNumColumnWidth( size )
Changes the width of the rowNum column.
setRowReadOnly( rowIndex , readOnly )
Sets the readOnly property for the row of the corresponding rowIndex.
setRowStatusColumnWidth( size )
Changes the width of the rowStatus column.
setRowVisible( rowIndex , flag )
Hides/Unhides certain rows.
setScrollLeft( left )
Moves the horizontal scroll as much as specified.
setScrollTop( top )
Sets the top style of the div that covers the vertical scroll of the GridView same with the specified top style.
setStartRowNumber( rowIndex )
Sets the index of the starting row displayed on the rowNum column.
setStyleAll( styleObj )
Sets the GridView style.
setSubtotalVisible( flag )
Hides or unhides the subtotal.
setSummary( str )
Sets the HTML summary property or the GridView component.
setTopRowIndex( topRowIndex , noEvent , autoFocus )
Moves the vertical scroll bar in a way that the row of the corresponding topRowIndex is displayed on the first row.
setUseFilter( colId , flag )
Dynamically changes the useFilter setting of the specified header in the GridView.
setUseFilterList( flag )
Dynamically controls the useFilterList setting of the GridView.
showChooseOption( colIndex , chooseOption )
Sets the chooseOption of the SelectBox when the inputType of the gridView column is select.
showCustomFilter2( headerID )
Displays the “Use-defined Filter” popup for the end usr.
showCustomFilterReset( )
Shows the button to initialize the user-defined filter.
showGroupbyZone( )
Shows the groupbyZone area (which was previously hidden by hideGroupbyZone.)
spanAll( openFlag )
Spans or unspans the entire data of the GridView component when drilling-down is enabled.
toggle( rowIndex )
Enables toggling on the row of the corresponding rowIndex when drilling-down is enabled. (Opened for a closed row, and closed for an opened row.)

Property Detail

adaptive
Adaptive web design mode (in which page layouts adapt to the screen sizes and the device types.)
Supports Chrome, Safari, Firefox, Opera, and IE10+.
adaptiveThreshold
A threshold at which the layout enters the adaptive mode. [default: 480]
alwaysTriggerScrollStart
Triggers the onscrollstart event every time that the scroll reaches the first row of the GridView. (Options) "true" : Triggers the onscrollstart event every time reaching the first first row of the GridView. "false" (Default) : Triggers only once.
applyAllColumnStyle
Applies all styles defined in the column. (Options) "true" "false" (Default) : Only the first style property will be applied.
arrowMove
Allows the end user to move to the next cell at the last character in the cell or to the previous cell at the first character in the cell using arrow keys. (Options) "true": Allows moving. "false" (Default) : Does not allow.
(Related Property) Valid only for moveKeyEditMode="true".
autoFit
Evenly distribute all columns of the GridView to fill up the full width of the GridView. [default: none, lastColumn, allColumn]
When autoFit is used, no horizontal scroll is displayed. (Options) "none" (Default) : Does not use the autoFit feature. "allColumn" : Evenly distributes all columns. "lastColumn" : Adjusts only the width of the last column.
autoFitMinWidth
Minimum width of the GridView to apply autoFit="allColumn" setting. (Unit: px)
When the GridView width is smaller than the autoFitMinWidth, autoFit="allColumn" setting will not be applied. Instead, a horizontal scroll will be created. (Related Property) autoFit="allColumn"
captionAuto
Combines the CaptionTitle with the header title of the table and displays it as the table title. false (Default) : Does not display.
To use this property in the TableLayout, set as tagName="table". (Options) "true": Combines the CaptionTitle with the header title of the table and displays it as the table title. "false" (Default) : Does not display.
(Related Property) inputType="text" (Header) captionTitle
(Example) "The transaction is a table of Item 1, Item 2, and Item 3" (1) Header titles in the GridView are "Item 1", "Item 2", and "Item 3". (2) captionTitle="Transaction" captionAuto="true"
captionTitle
Text to be displayed before the header title. [default: “”] (Related Property) captionAuto="true"
checkDisabledOnCut
Allows cutting through Ctrl (or cmd) + X in the disabled="true" columns. [default: true, false] (Options) "true" (Default) : Does not cut the disabled="true" columns. "false" : Cuts the disabled="true" columns.
checkEditableInputClass
Removes "w2grid_input" class from nobr tag in case the cell is readOnly or disabled in the inputType = "text" column. [default: false, true] (Options) “true” : Deletes "w2grid_input" class from nobr tag in readOnly or disable state. "false" : Applies "w2grid_input" class to nobr tag all the time.
checkReadOnlyOnCut
Allows cutting through Ctrl (or cmd) + X in the readOnly="true" columns. [default: true, false] (Options) "true" (Default) : Does not cut the readOnly="true" column. "false": Cuts the readOnly="true" column.
checkReadOnlyOnPaste
Allows pasting through Ctrl (or cmd) + V in the readOnly="true" columns. [default: false, true] (Options) "true" : Does not paste the readOnly="true" columns. "false" (Default) : Pastes the readOnly="true" columns.
checkReadOnlyOnPasteEnable
Set the columns to apply checkReadOnlyOnPaste="false". [Default: “”] (Example) checkReadOnlyOnPasteEnable = "col1,col2"; // Data can be pasted on readOnly="true" cells in col1 and col2 columns.
class
Same as the class property in HTML.
The class defined in the CSS file or style block can be applied. Multiple classes can be defined with being divided by blank space.
WebSquare5 Engine applies different classes to different components. By defining a common class, the common class can be applied to multiple components.
As a very complex structured component, the lower components of the GridView should be accessed by the CSS selectors.
columnMove
Allows column moving through header dragging.
Header value is displayed on the tooltip during dragging. (!!!Warning!!!) Cannot be used with the groupby API. (Restrictions) colSpan : When the column has colSpan setting, the column cannot be moved. Two rows in the header: The column cannot be moved. subtotal: The subtotal column is not moved. footer : The footer column is not moved.
columnMoveWithFooter
Moves the column and the footer. [default: false, true]
Moves the footer too when the user drags the column by using the setColumnOrder function or when the columnMove is "true". [default: false, true]
(Not supported if the footer and header do not share the same merge structure with the body.) (Options) "true" : Moves the footer. "false" (Default): Does not move the footer.
(Related Functions and Properties) setColumnOrder(); columnMove="true"
contextMenu
Uses the context menu. [default: false, true]
contextMenuAltClick
Shows the context menu upon Alt + mouse left-clicking. [default: false, true] (Related Property) contextMenu="true"
copyOption
When copying Gridview data, decide which value to copy - those defined in the DataList (“dataList”) or those currently display (“display”).
copyOption can be set for each column, and the copyOption setting of the column is prior to that of the entire GridView. (Options) "dataList" (Default) : Copies the data set in the dataList. "display" : Copies the data currently displayed on the GridView. (Example) The inputType of gridView (1,1) cell is "select". For this cell, the dataList value is "1001", but the currently displayed value on this cell is "a1". In case of copyOption="dataList", "1001" will be copied. In case of copyOption="display", "a1" will be copied.</div> </dd> <a class="anchor" id="customFilterBox"></a> <dt class="ename">customFilterBox</dt> <dd> <div class="edesc">Keeps the use-defined filter after groupby(); being executed. [default: false, true] <br />Keeps displaying the filter upon execution of groupby(); execution while the user-defined filter is applied. <br />Filtering and grouping can be applied at the same time. <xmp class='js sample'>(Options) "true": Displays the user-defined filter and keeps the filter upon execution of the groupby(); function. "false" (Default) : Displays the user-defined filter and resets the filter upon execution of the groupby(); function.
(Related Property) groupbyZone="true" groupbyFilterBox="true" useFilterList="true" useFilter="true"
dataDragDrop
Allows dragging-n-dropping between the GridViews. [true, false]
Two GridView must be bound with different DataLists each, and this property must be set for them.
dataDragSelect cannot be used at the same time.
(!!!Warning!!!) Use the Ctrl key in the FireFox.
dataDragSelect
Allows cell selection through dragging. [true, false]
Valid when the useShiftKey is used. Cannot be used with the dataDragDrop property. (Related Property) useShiftKey="true" dataDragDrop="false"
dataDragSelectAutoScroll
Allows automatic scrolling when the mouse move out of the browser while multiple cells are dragged and selected (dataDragSelect="true"). [default: false, true] (Options) "true": Automatic scrolling occurs upon the mouse moving outside the browser. "false" (Default) : Automatic scrolling does not occur upon the mouse moving outside the browser. (Related Property) dataDragSelect="true" dataDragSelectAutoScrollLevel dataDragSelectAutoScrollPeriod
dataDragSelectAutoScrollLevel
Time to double the current scrolling speed when the dataDragSelectAutoScroll is enabled. (Unit: ms) [default: 1300]
The longer the dragging time, the faster the scrolling speed. (Example) dataDragSelectAutoScroll="1300" means that the scrolling speed will double every 1.3 seconds. (Related Property) dataDragSelectAutoScroll="true" dataDragSelectAutoScrollPeriod
dataDragSelectAutoScrollPeriod
Scrolling interval when the dataDragSelectAutoScroll is enabled. (Unit: ms) [default: 70]
The smaller the value, the faster the scrolling speed doubling (Related Property) dataDragSelectAutoScroll="true" dataDragSelectAutoScrollLevel
dataList
ID of the DataList to bind with the GridView component data.
defaultCellHeight
Default cell height.
disabledBackgroundColor
Background color of the disabled (disabled="true") cell or row.
disabledFontColor
Font color of the disabled (disabled="true") cell or row.
disabledScrollHidden
Hides the scroll when disabled. [default: false, true]
Prevents the scroll from being moved when the GridView is disabled in non-IE browsers.
dragDisplayColumn
Column ID to display on the tooltip when dragging data (dataDragDrop="true").
Displays the column data on the tooltip.
Use “,” when setting multiple column IDs.
If not specified, the data of the clicked column will be displayed on the tooltip.
dragEndFunction
The function to be executed upon the end user's finishing dragging.
To be used with the dragStartFunction.
Define the function for drill-down case and the other. (Example 1) // For the dragEndFunction, // targetRowIndex, rowXml, and infoObj are received as first, second, and third arguments respectively. // The second argument rowXml is returned by dragStartFunction. // The third argument infoObj is an object. // The third argument infoObj contains fromColumnId, fromColumnIndex, toColumnId, and toColumnIndex. // Implement logic to insert a row to the targetRowIndex in the dragEndFunction. // Only when true is returned, the row of the rowIndex where drag-and-drop was initiated will be deleted. function end( targetRowIndex, rowXml, info ) { var fromColumnId = info.fromColumnId; var fromColumnIndex = info.fromColumnIndex; var toColumnId = info.toColumnId; var toColumnIndex = info.toColumnIndex; . . . return true; // Only when true is returned, the row of the rowIndex where drag-and-drop was initiated will be deleted. } (Example 2) // When the GridView is enabled with drill-down, // The first argument must be true for the setDrillDownDragDrop. // In this case, toIndex, rowXml, and infoObj will be received as first, second, and third parameters. // The first parameter is toIndex and the drilldown is used. // It is same the realRowIndex of the targetIndex. // The third parameter is an object containing: // removedData, removedRowIndex, insertedData, insertedRowIndex, fromRowIndex, and toRowIndex. // Unlike the cases above, the return value does not have any relevance. function end( toIndex, rowXml, info ) { var removedData = info.removedData; var removedRowIndex = info.removedRowIndex; var insertedData = info.insertedData; var insertedRowIndex = info.insertedRowIndex; var fromRowIndex = info.fromRowIndex; var toRowIndex = info.toRowIndex; . . . }
dragStartFunction
The function to be executed upon the end user's starting dragging.
To be used with the dragEndFunction.
Define the function for drill-down case and the other. (Example 1) // For the dragEndFunction, // rowIndex, rowXml, and infoObj are received as first, second, and third arguments respectively. // The third parameter infoObj is an object containing fromColumnId and fromColumnIndex. // When the dragEndFunction is defined, the return of the dragEndFunction can be used as the second parameter. function start( rowIndex, rowXml, info ) { var fromColumnId = info.fromColumnId; var fromColumnIndex = info.fromColumnIndex; . . . return rowXml; // Used as the second parameter of the dragEndFunction. } (Example 2) // When the GridView is enabled with drill-down, // The first argument must be true for the setDrillDownDragDrop. // Execute dragStartFunction. Only when “true” is returned, drill-down and drag-n-drop will be enabled. // In this case, the dragStartFunction will be given an object as the first argument which contains parentRowIndex, parentRowData, beforeRemoveRowIndex, and beforeRemveData . function start( info ) { var parentRowIndex = info.parentRowIndex; var parentRowData = info.parentRowData; var beforeRemoveRowIndex = info.beforeRemoveRowIndex; var beforeRemoveData = info.beforeRemoveData; . . . return true; // In case of true, drilldown dragDrop is executed. }
drilldownToggleScrollFix
Fixes the scroll upon the end user’s opening the list by clicking + button on the drilldown column. [default: false, true]
dynamic
Dynamically thorugh setGridStyle. [default: false, true]
Not display warning messages when there is no w2:header nor w2:body in the GridView in case of the setting of dynamic=true.
editModeEvent
Mouse action event to edit the cell data. [default: ondblclick, onclick, onsecondclick] (Options) "onclick" : Enters the editing mode upon the cell being clicked. "ondblclick" (Default): Enters the editing mode upon the cell being double-clicked. "onsecondclick": Enters the editing mode upon the cell being clicked second time or a key being pressed.
editModeEventIcon
Mouse action to edit cell data in the viewType="icon" column. [default: onclick, ondblclick] (Options) "onclick" (Default): Enters the editing mode upon the cell being clicked. "ondblclick": Enters the editing mode upon the icon being double-clicked. (!!!Warning!!!) In case the editModeEventIcon is enabled for both the gridView.column and the GridView, the setting of the gridView.column will be prior to that of the GridView.
enterKeyMove
Sets the focus-moving direction upon the end user's pressing the Enter key. [default:down, right, none, edit, editRight, editDown] (Options) "down" (Default) : Moves to the cell below upon the Enter key being pressed. "right" : Moves to the cell in the right side upon the Enter key being pressed. "none" : No action upon the Enter key being pressed. "edit" : Enters the cell-editing mode upon the Enter key being pressed. "editRight" : Enters the cell-editing mode upon the Enter key being initially pressed, and moves to the cell in the right side upon the Enter key being pressed again. Moves to the cell in the right side upon the Enter key being pressed in the cell-editing mode. "editDown" : Enters the cell-editing mode upon the Enter key being initially pressed, and moves to the cell below upon the Enter key being pressed again. Moves to the cell below upon the Enter key being pressed in the cell-editing mode.
escape
Decodes HTML escape characters as tags. (Options) "true" (Default) : Not convert into HTML Escape characters. "false" : Decodes HTML escape characters as tags.
euroMask
Masking value to be applied when the dataType is "euro" or when the changeCurrency API is used. [default: “”]
evenRowBackgroundColor
Background color of the even rows.
excludeDeletedRows
Excludes the deleted rows when calculating subtotal and total in the footer. [default: false, true] (Related Function) deleteRow(); deleteRows();
excludeModifiedRows
Excludes the rows of which status has been changed to “d” by modifyRowStatus API from subtotaling and totaling (in the foot) expressions. [default: false, true] (Related Function) modifyRowStatus();
fastScroll
Adds fast scrolling effects to vertical scrolling.
GridView rendered as allowed for the given time. For the part being rendered, a notification message will be displayed. (Options) "true" "false"
filterBoxvisibleRowNum
Number of the conditions to be displayed on the filtering condition list. (Related Property) groupbyFilterBox="true"
filterFocusMode
Whether to remove the focus or not on the selected cell or row in the body before the sorting event is triggered. (Options) “outfocus” : Removes the focus from the body, and sorts the data. "infocus" : Keeps the focus and sorts the data. "followfocus" : Sorts the currently focused data while keeping the focus to the currently focused item in the new sorting result. At this time, the scrollend event is not triggered.
filterShowAlways
Shows the filtering icon first when the width of the column with useFilter=“true” setting is small. [default: false, true]
fixedColumn
Column to fix. (Example) In order to fix the first column, set as fixedColumn="1".
fixedColumnNoMove
Allows moving (columnMove) of the column that is fixed by fixedColumn property. [default:false, true]
fixedColumnScrollHidden
Hides the scroll on the fixed columns.
fixedColumnWithHidden
Includes the hiddenColumn when calculating the position of the fixedColumn property. [default:true, false]
fixedRow
Rows to fix. (Example) In order to fix the first row, set as fixedRow="1".
focusDefaultColumn
When set as true, both the rowNum and the rowStatus columns can get the focus. [default:false, true] (Remarks) The rowNum column is displayed when rowNumVisible is "true". The rowStatus column is displayed when rowStatusVisible is "true".</div> </dd> <a class="anchor" id="focusFlow"></a> <dt class="ename">focusFlow</dt> <dd> <div class="edesc">Sets the focus-moving direction. [default: default, linear] <xmp class='js sample'>(Options) “default” (Default): Does not move any more at far-left, far-right, top, or bottom. "linear" : Moves to the next/previous row or column at far-left, far-right, top or bottom.
focusMode
The method of displaying the selected (or focused) cell. [default:cell, row, both, none] (Options) "cell" (Default) : Selects the cell. "row" : Selects the row. "both" : Selects both the cell and the row. "none" : Selects none.
focusMove
Allows focus moving through the key. [default: true, false, vertical, horizontal] (Options) "true" (Default) : Ignores the focus upon moving by the arrow keys. "false" : Prevent moving by the arrow keys. "vertical" : Allows moving only by Up/Down arrow keys. "horizontal" : Allows moving only by Right/Left arrow keys.
footerCaption
Content of the footer. [default: ""(null)]
footerCaption
caption of the grid footer
footerCaptionAuto
Automatically generates the footer text for the footerCaption property regardless of the captionAuto setting. [default: false, true] (Related Property) captionTitle footerCaption
(Example 1) captionTitle = "Yearly Revenues", footerCaptionAuto = "true" // footerCaption="Sum of Yearly Revenues" (Example 2) captionTitle = "Yearly Revenues", footerCaptionAuto = "" // "Yearly Revenus" created as the footer caption.
footerSummary
Summary of the footer contents. [default: "" (null)]
footerSummary
grid footer summary
footerSummaryAuto
Automatically generates footer in the footer summary regardless of the captionAuto setting. [default: ""(Empty string)] (Related Property) captionTitle footerSummary
(Example) captionTitle = "Yearly Revenues", footerSummaryAuto = "true" // summary="Sum of Yearly Revenues"
groupbyFilterBox
Displays the filtering conditions when using the groupby (filtering) feature.
The end user can select one of the filtering conditions from the list. (Options) "true": Display. "false" (Default) : Not display.
(Related Property) groupbyFilterBoxLocation : Location of the filter list box. filterBoxvisibleRowNum : Number of the filters to display.
groupbyFilterBoxFormatter
Formats the labels to be displayed on the filtering condition list (groupbyFilterBox).
Two parameters - data and isGroupby - are received. (Parameters) : Contains information about the filter to be added to the groupby filterbox. Has header and filter child objects. data.header: Header label of the column to filter data.filter : Object containing filtering conditions data.filter.operator : filter operator data.filter.value : filter value to compare (In case of multiple values, an array is provided.) data.filter.gate: filter conjunctive [undefined, and, or] isGroupby : true when groupby is applied, or false.
groupbyFilterBoxLocation
Location of the filtering condition box (groupbyFilterBox). (Options) "top" : Display at the top. “bottom” (Default): Displayed at the bottom.
(Related Property) groupbyFilterBox : Displays the filters.
groupbyMaxCount
Set the maximum number of the columns to which groupby can be applied.
groupbyZone
Uses groupby feature or not.
groupby is to group the same data within a same column.
groupbyZoneHeight
Height of groupbyZone.
groupbyZoneMessage
Message to display when the groupbyZone is in initial state.
hammerEnabled
Hammers the dbclick event in the mobile environment. Decides whether to handle as the press event of JS or not. [default: true, false]
hammerPressTime
Time to hold until the press event is triggered. (Unit: ms) [default: 251]
hideHeader
Hides the header. [default: false, true]
id
Component ID
The component ID is allocated as a global object.
The script can access each object through the component ID.
ignoreCellClick
Ignore cell clicking. (Options) "true": Ignore cell clicking. Ignores cell clicking and as a result cell clicking will not trigger the oncellclick event. "false" : Cell clicking will trigger the oncellclick event.
ignoreNonEditableCell
Ignores Tab or Enter key pressing when cell editing is not allowed.
ignoreNonEditableCellTabEnter
Allows moving between readOnly cells when the ignoreNonEditableCell is “true”.
ignoreToggleOnDisabled
Ignores toggle image clicking on a disabled cell upon drill-down.
initFixedHeightByRowNum
Initializes the GridView height based on the number of the rows of the initially rendered GridView.
Fixes the number of the rows to render on the page.
keepDefaultColumnWidth
Fixes rowNum and rowStatus columns when autoFit is used. [default: false, true] (Related Property) rowNumVisible="true" rowStatusVisible="width"
keyMoveEditMode
Immediately enters the editing mode upon the end user’s pressing Tab or Enter key moving the focus. [default: false, true] (Options) "true": Immediately enters the editing mode upon the end user’s pressing Tab or Enter key moving the focus. "false" (Default) : Pressing the Tab or Enter will move only the focus.
loadCount
Number of the remaining rows to trigger the onscrollend event.
When the specified number of rows remain after vertical scrolling, the onscrollend will be triggered.
If not set, the onscrollend event will be triggered every time the vertical scroll reaches the bottom. (Related Event) onscrollend
mergeCells
Merges adjacent cells of the same data in the same row or on the same column. (Options) "never" : Cancels automatic merge made by mergeCells. "bycol" : Merges the adjacent rows with the same data within the same column. "byrow" : Merge the cells with the same data within the same row. “bycolrec” : Conducts bycol and byrow for the unmerged cells. “byrowrec” : Conducts byrow and bycol for the unmerged cells. "byrestriccol" : Merges cells with the same data on the same column, and if the cells in the left column are merged, merges the rows. (Same as when there are n+1 columns, and the “n”th column is the upperColumn.) "byrestricrow" : Merge cells with the same data on the same row, and if the cells on the upper row are merges, merges the columns. (Same as when there are n+1 rows, and the “n”th row is the upperRow.)</div> </dd> <a class="anchor" id="mergeCellsFixedCols"></a> <dt class="ename">mergeCellsFixedCols</dt> <dd> <div class="edesc">Merges adjacent cells with the same data in the fixedColumn. <xmp class='js sample'>(Options) "never" : Cancels automatic merge made by mergeCells. "bycol" : Merges the adjacent rows with the same data within the same column. "byrow" : Merge the cells with the same data within the same row. “bycolrec” : Conducts bycol and byrow for the unmerged cells. “byrowrec” : Conducts byrow and bycol for the unmerged cells.
mergeCellsFixedRows
Merges adjacent cells with the same data in the fixedRow. (Options) "never" : Cancels automatic merge made by mergeCells. "bycol" : Merges the adjacent rows with the same data within the same column. "byrow" : Merge the cells with the same data within the same row. “bycolrec” : Conducts bycol and byrow for the unmerged cells. “byrowrec” : Conducts byrow and bycol for the unmerged cells.
mergeCol
Specify columns to apply the mergeCells property. (Example) mergeCells="byCol" mergeCol="col1,col3" // Cells with the same data in col1 and col3 columns are merged.
moveKeyEditMode
Enter the editing mode upon the end user’s pressing Up/Down key moving the focus. [default: false, true] (Options) "true": Enters the editing mode upon the end user’s pressing Up/Down keys moving the focus. "false" (Default) : Only moves the focus upon the end user’s pressing Up/Down keys.
moveKeyEditModeAll
Enter the editing mode upon the end user’s pressing Up, Down, Left, and Right key moving the focus. [default: false, true] (Options) "true": Enters the editing mode upon the end user’s pressing Up, Down, Left, and Right keys. "false" (Default) : Only moves the focus upon the end user’s pressing Up, Down, Left, and Right keys.
(Related Property) arrowMove="true" (Supported inputType) text, select, calendar, checkcombobox, secret, textarea (Remarks) Valid when the inputType is text, textarea, textImage, secret, or calendar. Pressing Right/Left keys at the first or last column will move to the next/previous column.
nextTabID
The ID of the component to be selected upon the end user’s pressing the Tab key.
noResultMessage
Message to display when there is no search result. (When there is 0 data in the DataList.) [default: No result message.]
noResultMessageClass
Class to apply to the noResultMessage. (When there is 0 data in the DataList.)
The message is displayed within the <div> tag. (!!!Warning!!!) For each in-line style, use !important in each style of the class.
noResultMessageStyle
Class to apply to the noResultMessage. (When there is 0 data in the DataList.)
Specified style will be used instead of the default style.
The message is displayed within the <div> tag.
In case the position and the display are not defined, the Engine will decide absolute and block values. (Basic Style) Define the following properties to keep the layout and to display the message. position: absolute; display: block; left: 40%; width: 20%; top: 40%; text-align:center;
noResultMessageVisible
Shows the message when there is no search result (0 data in the DataList). [default: true, false]
noSelect
Prevents cell text selection through mouse dragging (useCtrlKey="true") (useShiftKey="true").
(Options) "true" : Prevents cell text selection by the use of the mouse clicking or key pressing. "false" (Default) : Allows cell text selection by the use of the mouse clicking or key pressing.
numberMask
Masking value to be applied when the dataType is "number" or when the changeCurrency API is used. [default: “”]
oddEvenColorDisplay
Uses different colors for odd and even rows respectively. [default: true, false]
oddRowBackgroundColor
Background color of the odd rows.
overflowX
Displays the horizontal scrolling bar. [default: auto, hidden, scroll]
overflowY
Displays the vertical scrolling bar. [default: auto, hidden, scroll]
pasteOption
Pastes the data to the clip board through Ctrl (or cmd) + V. [default: "", focus]
preventAddRowOnPaste
Prevents adding of a new row upon pasting data from the clipboard through Ctrl (or cmd)+V. [default: false, true]
preventCopy
Prevents copying of the GridView data through Ctrl (or cmd) + C or Ctrl (or cmd) + X to the clip board. [default: false, true]
preventCopyColumn
Column ID to prevent copying of the data to the clipboard through Ctrl (or cmd) + C. [default: “”] (Example) preventCopyColumn = "col1,col2";
preventMultisort
Prevent multiple-sorting.
preventPaste
Prevents pasting of the GridView data from the clipboard through Ctrl (or cmd)+V. [default: false, true]
preventPasteColumn
Column ID to prevent pasting of the data to the clipboard through Ctrl (or cmd) + V. [default: “”] (Example) preventPasteColumn = "col1,col2";
readOnly
Allows reading only. [default: false, true]
In case the readOnly is set for the Body column, the setting of the Body column will be used.
The readOnly property can be selectively applied to GridView, column, row, cell through the use of the APIs. (Priorities) GridView &lt; column &lt; row &lt; cell However, the priorities of the column and the row depend on the readOnlyPriority of the GridView.
readOnlyBackgroundColor
Background color of the cell of which readOnly property is true. (Related Property) readOnly="true"
readOnlyBackgroundImg
Path of the cell background image of which readOnly property is true. (Related Property) readOnly="true"
readOnlyBackgroundImgCSS
Path of the cell background image of which readOnly property is true.
Prior to the readOnlyBackgroundImg. (Related Property) readOnly="true" readOnlyBackgroundImg
(Example) background: steelblue url("PathofImage") 10px 50% no-repeat;
readOnlyPriority
readOnlyTabIgnore
Ignores readOnly cell upon Tab key being pressed. [default: false, true] (Related Property) readOnly="true"
resize
Allows column width resizing through dragging. [default: true, false]
rowMouseOver
Displays the background color of the row hovered by the end user. [default: true, false]
rowMouseOverColor
Background color of the row upon the end user's hovering the mouse over the row.
rowNumBackgroundColor
Background color of the body when the rowNumVisible is true. (Related Property) rowNumVisible="true"
rowNumHeaderValue
Header text to be displayed in case of rowNumVisible="true". (Related Property) rowNumVisible="true"
rowNumLocaleRef
localeRef key to set in the rowNum column.
rowNumStatusResize
Allows resizing of the widths of rowNum and rosStatus columns. [default: false, true]
rowNumStatusUniqueId
Uses unique IDs when rowNum and rowStatus columns are used. [default: false, true]
To pass the W3C validator, set the property as true. (Options) "false" (Default) : The default is false. In default, the ID of the rowNum td will be _headerRowNumber, and the ID of the rowStatus td will be _headerStatusNumber. "true" (Recommended) : Use unique IDs in the rows.
rowNumVisible
Displays the row number of the DataList data bound with the GridView. [default: false, true]
rowNumWidth
Width of the rowNum column when rowNumVisible is "true".
rowStatusHeaderValue
Header text to be displayed in case of rowStatusVisible="true". (Related Property) rowStatusVisible="true"
rowStatusLocaleRef
localeRef to set in the rowStatus column.
rowStatusVisible
Displays the status of each row (add, modified, or deleted) through the use of icons. [default: false, true]
rowStatusWidth
Width of the rowStatus column when rowStatusVisible is "true".
rupeeMask
Masking value to be applied when the dataType is "rupee" or when the changeCurrency API is used. [default: “”]
scrollByColumn
Horizontally scrolls by column. [default: false, true]
scrollByColumnAdaptive
Scrolls by column in the adaptive mode. [default: false, true]
selectedCellColor
Background color of the selected cell.
selectedCellOverColor
Background color of the cell to be displayed upon the end user’s hovering the mouse over the cell.
If not specified, the rowMouseOverColor will be used.
selectedRowColor
Background color of the selected cell.
selectedRowOverColor
Background color of the row to be displayed upon the end user’s hovering the mouse over the cell.
If not specified, the rowMouseOverColor will be used.
senseReader
A mode to support web accessibility requirements. [default: false, true] (Options) "false" (Default) "true": Allows the end user to rotate through all cells using the Tab key.
(!!!Warning!!!) In case of inputType="text", "select", "radio", "checkbox", set embeddedInput="true" in order to render the Input (or Select, Radio, or CheckBox) within the cell. Sensed by the reader.
(Using the following properties is recommended.) focusMode="none" focusMove="false"
setCellInputTypeCustom
An option to dynamically change the inputType of the cell of which inputType is custom. (Cannot be used when the typeGetter is in use.)
showImageTooltip
Displays the tooltip when the inputType is "image". [default: false, true] (Options) "true": Displays the tooltip. "false" (Default) : Not to display the tooltip.
showSortableImage
Shows sorting images on the header of the sortable column. [default: false, true]
showSortableUseFilter
Displays the sortable and the useFilterList icons on the header when both the useFilterList and the showSortableImage properties are in use. [default: false, true] (Options) "true": Displays both the user-defined filter icon and the sorting icon. "false" (Default) : Displays only the sorting icon.
(Related Property) showSortableImage="true" sortable="true" Valid only when useFilterList="true".
sortable
Whether to support data sorting by the end user's clicking the header on the GridView component.
sortedIconPosition
Position to show the sorting icon. (Options) "right" "left"
sortEvent
Define the sorting events. [default: ondblclick, onclick]
Valid when sortable="true". (Options) "ondblclick" (Default): Double-clicking the header will sort the data. "onclick" : Clicking the header will sort the data.
(Related Property) sortable="true"
sortOrderReverse
Sorts the data in descending powers first upon user's clicking the header.
summary
Similar to the summary property of the table tag in HTML.
Generally used to comply with the web accessibility requirements.
summaryAuto
Automatically sets the header column name in the summary to support web accessibility.
summaryOnlyAuto
Sets the summary only with text without tags if the header title includes HTML. [default: false, true] (Options) "true": Sets the text only without the HTML tag as the summary. "false" (Default) : Sets the text and the HTML tag as the summary.
(Related Property) summaryAuto="true"
syncScroll
Scrolls down multiple GridViews at the same time.
Note that the GridViews must have a same number of the rows.
syncScrollId
ID of the GridView to synchronize scrolling.
tengeMask
Masking value to be applied when the dataType is "teng" or when the changeCurrency API is used. [default: “”]
titleAuto
Disable the component. [default: false, true]
For the header, inputType="text".
For the cell, inputType="text" (or link, checkbox, button, radio, select (tableRender = "ul"), or secret).
Generates the title of the cell. (Example) For the header, title="name1" and inputType="text". (1) When the cell data is "1". the automatically created cell title: "name1 1" (1) When the cell data is "", the automatically created cell title: "name1 text"
titleFormatter
Uses the user-define value as the title. [default: false, true]
For the header, inputType="text".
For the cell, inputType="text" (or link, checkbox, button, radio, select (tableRender = "ul"), or secret).
Uses the defined value as the title. (Supports web accessibility.)
tooltipDisplay
Displays hidden data as a tooltip when the data is not fully displayed. [default: false, true]
tooltipDisplayColumn
Sets the column name to display tooltip on certain columns. [default: false, true] (Example) tooltipDisplayColumn = "col1,col2";
tooltipFormatter
Name of the function to format the tooltip contents when the tooltipDisplay is “true”.
The user-defined function receives rowIndex, colIndex, label, and isOverflow, and returns a string.
tooltipFormatterHeader
Name of the user-defined function to format the tooltip contents when the tooltipDisplay is “true”.
The customized function receives colId and label, and returns the string data.
tooltipHeader
Provides multi-language support. [default: false, true]
Functions same as existing tooltip options such as tooltipDisplay and tooltipDisplayTime. (Related Property) tooltipDisplay = "true" (or) tooltipShowAlways="true"
tooltipHeaderShowAlways
Always shows the tooltip upon the end user’s hovering the mouse regardless of the text length. [default: false, true]
Always shows the tooltip on the header. Always show except when the data is blank (""). (Options) "true": Always show except when the data is blank (""). "false" (Default) : Not to display the tooltip in case the header text is not cut.
(Related Property) tooltipDisplay="true" tooltipFormatterHeader
tooltipPositionX
X coordinate of the tooltip. (Unit: px) [default: 20]
The left of the Body cell is the origin.
Supports expressions using the cellWidth (width) and the cellHeight (height). (Example) cellWidth/2 : The center of the Body cell is the origin of X axis.
tooltipPositionY
X coordinate of the tooltip. (Unit: px) [default: cellHeight+3]
The upper-left corner of the Body cell is the origin.
Supports expressions using the cellWidth (width) and the cellHeight (height). (Example) cellHeight : The end of the body cell is the origin of the Y axis.
tooltipShowAlways
Always shows the tooltip. [default: false, true]
In case of "true", the data will be always displayed on the tooltip unless the data is blank (“”).
tooltipShowAlwaysColumns
Columns to display tooltip always. [default: ""]
Always show except when the data is blank (""). (Example) tooltipShowAlwaysColumns = "col1,col2" // Tooltip always displayed in "col1" and "col2" columns.
useCtrlKey
Allows multiple column selection through the use of the Ctrl key. [default: true, false]
useCtrlOnMultisort
Allows selection of multiple columns using Ctrl key to sort multiple columns.
useFilterList
Displays the filter list. [default: false, true]
The first item on the list will be “User-defined Filter”.
Upon selection of the "User-defined Filter”, the user-defined filter pop-up will be displayed. Set on the entire GridView. (Options) “true”: Displays the filtering conditions including the "User-defined Filter”. "false" (Default) : Does not display the filtering conditions without the “User-defined Filter”.
(Related Property) Valid when the gridView.column) uses useFilter="true" setting.
useFilterListSync
Displays the filter done by setFilter(); or setColumnFilter(); function of the DataList. [default: false, true]
Set on the entire GridView. (Options) "true" : Displays the filter made by a DataList function such as setFilter(); or setColumnFilter();. "false" (Default) : Not display the filter set by a DataList function.
(Related Property) Valid only when useFilterList="true".
useLocale
Multilanguage support
Uses multi-language keys of the client to display label values in multiple languages.
(For more information, see the user guide.) (Options) "false" (Default) Does not support multi-language. "true" Supports multi-language through the use of the multi-language keys in the client.
userData1
User-defined property.
Use getUserData("userData3") to get the data. // Example getUserData("userData1");
userData2
User-defined property.
Use getUserData("userData3") to get the data. // Example getUserData("userData2");
userData3
User-defined property.
Use getUserData("userData3") to get the data. // Example getUserData("userData3");
useShiftKey
Whether to allow selection of multiple cells through the use of the Shift key.
visibleRowNum
Number of the rows to be displayed on the screen.
"all" is to display all rows without a scroll.
visibleRowNumFix
Automatically adjusts the initial height of the GridView according to the visibleRowNum or initFixedHeightByRowNum setting. [default: true, false]
wheelRows
Number of the rows changing upon the end user's clicking the vertical scrolling bar each time. [default: 3]
wheelStop
Prevents scrolling at the bottom of the GridView. [default: false]

Event Detail

onaftercolumnmove
Triggered right after a column moving.
Parameter
nametypedescription
infoObjectReturns an object containing startColumnID, startColumnIndex, endColumnID, and endColumnIndex. <Number> info.startColumnIndex : Index of the column to start moving (as displayed on the page) <String> info.startColumnID : ID of the column to start moving <Number> info.endColumnID : ID of the column at the end of the moving (the column located at the left of the column from which moving started.) <Number> info.endColumnIndex : Index of the column at the end of the moving (the column located at the left of the column from which moving started.)
onaftercolumnresize
Triggered right after column resizing.
Parameter
nametypedescription
infoObjectReturns an object containing colIndex, oldWidth, and newWidth. <Number> info.colIndex : Index of the column to resize <Number> info.oldWidth : Column width before resizing (unit: px) <Number> info.newWidth : Column width after resizing (unit: px)
onafteredit
Triggered upon the focus moving of the cell after editing is done.
Triggered after the oneditend.
Parameter
nametypedescription
rowNumberRow index of the cell
colNumberColumn index of the cell
valueStringInputted value in the cell
onbeforecolumnmove
Triggered right before column moving.
Parameter
nametypedescription
infoObjectReturns an object containing startColumnID, startColumnIndex, endColumnID, and endColumnIndex. <Number> info.startColumnIndex : Index of the column to start moving (as displayed on the page) <String> info.startColumnID : ID of the column to start moving <Number> info.endColumnID : ID of the column at the end of the moving (the column located at the left of the column from which moving started.) <Number> info.endColumnIndex : Index of the column at the end of the moving (the column located at the left of the column from which moving started.)
onbeforeedit
Triggered before entering into the cell editing mode.
Parameter
nametypedescription
rowNumberRow index of the cell
colNumberColumn index of the cell (Set colIdToColIndex as true in config.xml.)
valueStringInputted value in the cell
onbeforesort
Triggered right before column sorting. Returns the sorting status.
sortOrder="1" is for sorting in ascending power, and sortOrder="-1" is for sorting in descending power. When sortOrder is "0", no sorting will be made.
Parameter
nametypedescription
sortInfoObjectReturns an object containing headerId, bodyColId, and sortOrder. <Number> sortInfo.headerId : Header ID of the column to sort <Number> sortInfo.bodyColId : Body ID of the column to sort <Number> sortInfo.sortOrder : Ascending, Descending, Initializing
onblankclick
Triggered upon end user’s clicking empty part within the GridView.
Parameter
nametypedescription
eObjectevent object
onbodymouseout
Triggered when the mouse moves out of the GridView body.
Parameter
nametypedescription
infoObjectReturns all objects of the corresponding rowIndex and the colIndex. <Number> info.rowIndex : Row index of the cell moused over lastly. Returns displayRowIndex. (The displayRowIndex is the row index based on the current GridView display.) <Number> info.colIndex : Column index of the cell mouse over lastly
Sample
<script type="javascript" ev:event="onbodymouseout( info )"><![CDATA[ alert(info.rowIndex); alert(info.colIndex); ]]></script>
onbodymouseover
Triggered upon the end user's hovering the mouse over the body.
Parameter
nametypedescription
infoObjectReturns all objects of the corresponding rowIndex and the colIndex. <Number> info.rowIndex : Row index of the event-triggered cell. (The displayRowIndex is the row index calculated based on the current display.) <Number> info.colIndex : Column index of the event-triggered cell
Sample
<script type="javascript" ev:event="onbodymouseover( info )"><![CDATA[ alert(info.rowIndex); alert(info.colIndex); // 마우스가 오버된 셀의 rowIndex와 colIndex가 alert됨. ]]></script>
oncellclick
Triggered upon the end user's clicking the cell.
Parameter
nametypedescription
rowNumberRow index of the cell
colNumberColumn index of the cell
colIdStringColumn ID of the clicked cell
oncelldblclick
Triggered upon cell being double-clicked.
Parameter
nametypedescription
rowNumberRow index of the cell
colNumberColumn index of the cell
colIdStringColumn ID of the clicked cell
oncellindexchange
Triggered upon the end user's selecting a cell and changing the cell through the use of an arrow key, mouse clicking, or a method.
Parameter
nametypedescription
rowNumberRow index of the currently selected cell
colNumberColumn index of the currently selected cell
oldRowNumberRow index of the previous cell
oldColNumberColumn index of the previous cell
oncolumnindexchange
Triggered upon the end user's selecting a cell and changing the column through the use of an arrow key, mouse clicking, or a method.
Parameter
nametypedescription
colNumberColumn index of the currently selected cell
oldColNumberOld column index
oncolumnwidthchange
Triggered upon a change in the column length.
Parameter
nametypedescription
infoObjectReturns an object containing columnIndex, columnID, oldWidth, and newWidth. <Number> info.columnIndex : Index of the column with a changed width <String> info.columnID : Id of the column with a changed width <Number> info.oldWidth : Old width <Number> info.newWidth : New width
oncustomcopy
Define an event to replace the copy event of the GridView.
However, to replace the basic copy event, the corresponding event must return false.
Parameter
nametypedescription
eObjectEvent object
oncustompaste
Define an event that will replace the paste event of the GridView.
However, to replace the basic paste event, the corresponding event must return false.
Parameter
nametypedescription
eObjectEvent object
ondatadragover
Triggered upon data being moved over another Gridview when the dataDragDrop is “true”.
The event is triggered in a data-overlapped component.
Parameter
nametypedescription
fromIdStringID of the GridView from which data is being dragged.
fromRowIndexNumberIndex of the row from which dragging started
ondatadragstart
Triggered upon data dragging when the dataDragDrop is “true”.
The event is triggered in the component where dragging starts.
Parameter
nametypedescription
rowIndexNumberIndex of the row to drag
ondatadrop
Triggered upon the data being dropped on another GridView when the dataDragDrop is “true”.
The event is triggered in a component where dragged data is dropped.
Parameter
nametypedescription
infoObjectDropped data information <Number> info.fromId : ID of the GridView from which data dragging started. <Number> info.fromRowIndex : rowIndex of the GridView from which data dragging started. <Number> info.toRowIndex : rowIndex of the GridView to which the data is being dropped
ondateselect
Triggered upon selection of a date when the inputType is “calendar”.
Parameter
nametypedescription
rowNumberRow index of the cell being edited
colNumberColumn index of the cell being edited
dateStrStringSelected date
dateObjDateDate object of the selected date
Sample
// Parameters upon the end user's selecting 2002-Apr-15. row : 2 col : 1 dateStr : "20020415" (String object) dateObj : Mon Apr 15 2002 00:00:00 GMT+0900 (Date object)
oneditdblclick
Triggered upon the end user’s double-clicking the cell being edited.
Valid when the inputType is text, textImage, drilldown, or secret.
Parameter
nametypedescription
rowNumberRow index of the double-clicked cell
colNumberColumn index of the double-clicked cell
colIdStringColumn ID of the clicked cell
oneditend
Triggered upon the end user's finishing editing the cell data. Triggered before the onafteredit.
Parameter
nametypedescription
rowNumberRow number of the cell
colNumberColumn number of the cell
valueStringInputted value
oneditkeydown
Triggered upon the end user’s pressing the key while a cell is being edited.
For Korean characters (2 bytes for each character), the event will be triggered upon completion of the character in Opera and Firefox.
Parameter
nametypedescription
infoObjectReturns all objects of the corresponding rowIndex and the colIndex. <Number> info.rowIndex : Row index of the event-triggered cell. (The displayRowIndex is the row index calculated based on the current display.) <Number> info.colIndex : Column index of the event-triggered cell
Sample
<script ev:event="oneditkeydown( info )"><![CDATA[ alert(info.rowIndex + "," + info.colIndex); // 행의 값과 열의 값이 alert됨. ]]></script>
oneditkeyup
Triggered upon the end user's releasing a key off the keyboard after pressing the key.
JSON object containing rowIndex, colIndex, oldValue, newValue, keyCode, and inputType is received.
Valid when the inputType is [text, textarea, textImage, secret, or calendar].
Parameter
nametypedescription
infoJSONReturns JSON containing rowIndex, colIndex, oldValue, newValue, keyCode, and inputType. <Number> info.rowIndex : Row index of the cell in which the event is triggered. <Number> info.colIndex : Column index of the cell in which the event is triggered. <String> info.colID : Column ID of the cell in which the event is triggered. <String> info.oldValue : Old input value before the key input <String> info.newValue : New input value after the key input
info.inputType : InputType of the cell in which the event was triggered <Number> info.keyCode : Key code
Sample
<w2:gridView id="gridView1" ev:oneditkeyup="scwin.gridView1_oneditkeyup" dataList="dataList1"> ... </w2:gridView> scwin.gridView1_oneditkeyup = function(info) { var logStr = "rowIndex=" + info.rowIndex + ", colIndex=" + info.colIndex + ", colID=" + info.colID + ", inputType=" + info.inputType; logStr += ", oldValue=" + info.oldValue + ", newValue=" + info.newValue + ", keyCode=" + info.keyCode; WebSquare.logger.printLog(logStr); console.log(logStr); }
onfilereadend
Triggered after an Excel file is uploaded to the GridView component.
Parameter
nametypedescription
valueStringName of the uploaded file
Sample
<script ev:event="onfilereadend( value )"><![CDATA[ //gridView에 test.xls을 이용하여 엑셀 업로드 시 //value 예시 ) test.xls ]]></script>
onfooterclick
Triggered upon the footer being clicked.
Parameter
nametypedescription
footerIdStringID of the clicked footer
onheaderclick
Triggered upon the header being clicked.
Parameter
nametypedescription
headerIdStringID of the clicked header
onheaderdblclick
Triggered upon the end user's double-clicking the header.
Parameter
nametypedescription
headerIdStringID of the double-clicked header
onkeydown
Triggered upon the end user's pressing a key on the keyboard.
Parameter
nametypedescription
eObjectEvent object
onkeyup
Triggered upon the end user's releasing a key off the keyboard after pressing the key.
Parameter
nametypedescription
eObjectEvent object
onmonthselect
Triggered upon selection of a date when the inputType is “calendar”.
Parameter
nametypedescription
rowNumberRow index of the cell being edited
colNumberColumn index of the cell being edited
dateObjDateDate object of the selected date
Sample
// Parameters upon the end user's selecting 2002-Apr. row : 2 col : 1 dateObj : {"oldValue":"200204","newValue":"200204"}
onrightbuttonclick
Triggered upon the end user's right-clicking the cell in the body part.
Parameter
nametypedescription
rowNumberRow index of the cell
colNumberColumn index of the cell
onrowindexchange
Triggered upon the end user's selecting a cell and changing the row of the selected cell through the use of an arrow key, mouse clicking, or a method.
Parameter
nametypedescription
rowNumberRow index of the currently selected cell
oldRowNumberIndex of the previous row
onrownumclick
Triggered upon the rowNum column being clicked.
Parameter
nametypedescription
rowNumberRow index of the cell
onrowstatusclick
Triggered upon the rowStatus column being clicked.
Parameter
nametypedescription
rowNumberRow index of the cell
onscrollend
Triggered when the vertical scrolling reaches the bottom.
onscrollstart
Triggered when the vertical scrolling reaches the top.
onscrollx
Triggered upon the end user's horizontal scrolling.
onscrolly
Triggered upon the end user's vertical scrolling.
onsort
Triggered upon a change in the sorting method by clicking or double-clicking on the sorted header.
onsubtotalclick
Triggered upon clicking of the subtotal.
Parameter
nametypedescription
infoJSONJSON containing colID, startRowIndex, endRowIndex, and element <String> info.colID : columnID Of the subtotal column with clicking <Number> info.startRowIndex : rowIndex of the subtotal row with clicking <Number> info.endRowIndex : Last rowIndex among the subtotal rows with clicking (rowIndex of the row right above the clicked subtotal) <Object> info.element : 클릭이 발생한 dom객체
onsubtotaldblclick
Triggered upon double-clicking of the subtotal.
Parameter
nametypedescription
infoJSONJSON containing colID, startRowIndex, endRowIndex, and element <String> info.colID : columnID Of the subtotal column with double-clicking <Number> info.startRowIndex : rowIndex of the subtotal row with double-clicking <Number> info.endRowIndex : rowInde of the last row among the subtotal rows with double-clicking (rowIndex of the row right above the double-cilcked subtotal) <Object> info.element : 더블클릭이 발생한 dom객체
ontextimageclick
Triggered when the image of which inputType is textImage is clicked.
Parameter
nametypedescription
rowNumberRow number of the clicked cell
colNumberColumn number of the clicked cell
ontoggleclick
Triggered upon clicking of the toggling button when the inputType is drilldown.
Parameter
nametypedescription
isCollapsedBooleanCollapsing or folding
rowIndexNumberrowIndex of the clicked cell
onviewchange
Triggered when the value on the list is changed through keyboard input or mouse clicking.
In case the change was made by a script, the event will not be triggered. (Similar to the native onchange event.)
Parameter
nametypedescription
infoObjectReturns an object containing oldValue, newValue, rowIndex, and colIndex. <Number> info.rowIndex : Row index of the event-triggered cell. (The displayRowIndex is the row index calculated based on the current display.) <Number> info.colIndex : Column index of the event-triggered cell <String> info.oldValue : Old value of the cell before the event <String> info.newValue : New value of the cell after the event
Sample
<script ev:event="onviewchange( info )"><![CDATA[ var targetRow = info.rowIndex; var targetColumn = info.columnIndex; var oldValue = info.oldValue; var newValue = info.newValue; ]]></script>
onyearselect
Triggered upon selection of a date when the inputType is “calendar”.
Parameter
nametypedescription
rowNumberRow index of the cell being edited
colNumberColumn index of the cell being edited
dateObjDateDate object of the selected date
Sample
* |// Parameters upon the end user’s selecting 2002.
* |row : 2
* |col : 1
* |dateObj : {"oldValue":2020,"newValue":2002}

Method Detail

advancedExcelDownload( options , infoArr )
Saves the grid data as an Excel file. (Supported for JDK 1.5 and higher versions.)
Parameter
nametyperequireddescription
optionsObjectYOptions to download GridView data (stored in JSON format) as an Excel file
File information <String:Y> options.fileName : [default: excel.xls] Name of the file to download. Mandatory. <String:N> options.sheetName : [default: sheet] Excel sheet name. Options related to download request <Number:N> options.timeout : [default: N/A] Maximum standby time. (Unit: millisecond) In case no response is received within the timeout, a download fail will occur. <Number:N> options.checkInterval : [default: 1000] Response checking interval. (Unit: ms) <Function:N> options.onSuccessCallback : [default: N/A] Callback function to be executed upon a success. <Function:N> options.onFailureCallback : [default: N/A] Callback function upon a failure. <String:N> options.lazyInfoArr : [default: false] infoArr display sequence. ("false" is to display first, and "true" is to display at the last.) <String:N> options.decimal : [default: N/A] "auto" is not to apply the displayFormat when the dataType is “number” or “bigDecimal” but to internally calculate the decimal point for the format. Options related to the data to download <String:N> options.type : [default: 1] Data to use. When the inputType of the GridView column is "select", "autoComplete", or "checkcombobox". 0: Use the value. 1: Use the label. 2: Depending on the displayMode setting in the column, "value delim label" or "label delim value" will be used. <String:N> options.convertIndex : [default: N/A] When type is 0 or 1, downloads certain columns with the type being 1 or 0. For example, when the type is 1 and “0,2” is given, the column of indices of 0 and 2 can be downloaded with the type being 0. <String:N> options.removeColumns : [default: N/A] Column number to remove from the Excel file (Use comma for multiple inputs.) <String:N> options.removeHeaderRows : [default: N/A] Row index of the header to remove from the Excel file. (Use comma for multiple inputs.) <String:N> options.foldColumns : [default: N/A] Columns to fold in the Excel file. (Use comma for multiple inputs.) <String:N> options.useHeaderCheckBoxLabel : [default: false] Displays the value of the checkbox instead of the checked status. ("true" is to display the value of the header column, and "false" is to display the checked status (true/false).) <String:N> options.separator : [default: ,] Data separator required for data transmission to the server. <Number:N> options.subTotalScale : [default: -1] Sets the decimal point for the subTotal average. <String:N> options.subTotalRoundingMode : [default: N/A] Rounding mode for subTotal average. ("CEILING","FLOOR","HALF_UP") <String:N> options.useDataFormat : [default: “”] "true" is to display the data format on the Excel file according to the dataType. dataType="text" will display “text”, and dataType="number" or "bigDecimal" will display “number”. <String:N> options.indent : [default: 0] Blank count for the indent incase of datatype=”drilldown”. Options for the Excel file <String:N> options.rowHeight : [default: N/A] Cell height (unit: pixel) <String:N> options.pwd : [default: N/A] Sets the password for the downloaded Excel file. Conditions: (1) All passwords must be BASE64-encoded before transmission. (2) In websquare.xml, <encrypt tempDir> must be set. (3) Upgrade to POI 3.10. <String:N> options.maxCellCount : [default: N/A] Maximum number of the cells in the Excel file to be downloaded. (Example: "1000" : When there are more than 1000 cells, the request is not directly sent to the server.) <String:N> options.maxRowCount : [default: N/A] Maximum number of the cells in the Excel file to be downloaded. (Example: "1000" : When there are more than 1000 cells, the request is not directly sent to the server.) Options for the style of the Excel file <String:N> options.displayGridlines : [default: false] Whether to display gridline on the Excel sheet. <Number:N> options.startRowIndex : [default: 0] Row index from which the GridView data starts in the Excel file (including the header.) <Number:N> options.startColumnIndex : [default: 0] Column index from which the GridView data starts in the Excel file (including the header.) <String:N> options.useStyle : [default: false] Whether to apply the style not including CSS to the excel (such as background and font). <String:N> options.freezePane : [default: ""] Coordinates and coordinate offset to freeze the pane (Example) freezePane="3,4" Fix to 3 on X and 4 on Y. freezePane="0,1,0,5" Fix to 0 on X and 5 on Y from 0 on X and 1 on Y. <String:N> options.autoSizeColumn : [default: false] Whether to automatically adjust the width or not. Options for the style of the Excel file - Header <String:N> options.headerColor : [default: #33CCCC] Header color in the Excel file for the GridView. <String:N> options.headerFontName : [default: N/A] Header font name in the Excel file for the GridView. <String:N> options.headerFontSize : [default: 10] Header font size in the Excel file for the GridView. <String:N> options.headerFontColor : [default: N/A] Header font color in the Excel file <String:N> options.headerFontBold : [default: "false"] Makes the header bold in the excel file. Options for the style of the Excel file - Body <String:N> options.bodyColor : [default: #FFFFFF] Body color in the Excel file for the GridView. <String:N> options.bodyFontName : [default: N/A] Body font in the Excel file for the GridView. <String:N> options.bodyFontSize : [default: 10] Body font size in the Excel file for the GridView. <String:N> options.bodyFontColor : [default: N/A] Body font color in the Excel file for the GridView. Options for the style of the Excel file - SubTotal <String:N> options.subTotalColor : [default: #CCFFCC] Subtotal color in the Excel file for the GridView. <String:N> options.subTotalFontName : [default: N/A] Subtotal font in the Excel file for the GridView. <String:N> options.subTotalFontSize : [default: 10] Subtotal font size in the Excel file for the GridView. <String:N> options.subTotalFontColor : [default: N/A] Subtotal font color in the Excel file for the GridView. Options for the style of the Excel file - Footer <String:N> options.footerColor : [default: #008000] Footer color <String:N> options.footerFontName : [default: N/A] Footer font in the Excel file. <String:N> options.footerFontSize : [default: 10] Font size of the footer <String:N> options.footerFontColor : [default: N/A] Footer font color in the Excel file. Options for the style of the Excel file - Even/Odd rows. <String:N> options.oddRowBackgroundColor : [default: N/A] Background color of the odd rows <String:N> options.evenRowBackgroundColor : [default: N/A] Background color of the even rows Options for row number display. <String:N> options.rowNumVisible : [default: false] Hides or displays the row numbers. <String:N> options.rowNumHeaderValue : [default: N/A] Output of the header when the rowNumVisible is true. Options for the style of the Excel file - Header <String:N> options.rowNumHeaderColor : [default: N/A] Output of the header when the rowNumVisible is true. <String:N> options.rowNumHeaderFontName : [default: N/A] Header font of the row number column when the rowNumVisible is true. <String:N> options.rowNumHeaderFontSize : [default: N/A] Header font size of the row number column when the rowNumVisible is true. <String:N> options.rowNumHeaderFontColor : [default: N/A] Header font color of the row number column in case of rowNumVisible="true". Options for the style of the Excel file - Body <String:N> options.rowNumBodyColor : [default: N/A] Body background color of the row number column in case of rowNumVisible=”true”. <String:N> options.rowNumBodyFontName : [default: N/A] Body font of the row number column when the rowNumVisible is true. <String:N> options.rowNumBodyFontSize : [default: N/A] Body font size of the row number column when the rowNumVisible is true. <String:N> options.rowNumBodyFontColor : [default: N/A] Body font color of the row number column in case of rowNumVisible=”true”. Options for the style of the Excel file - Footer <String:N> options.rowNumFooterColor : [default: N/A] Footer background color of the row number column in case of rowNumVisible=”true”. <String:N> options.rowNumFooterFontName : [default: N/A] Footer font of the row number column when the rowNumVisible is true. <String:N> options.rowNumFooterFontSize : [default: N/A] Footer font size of the row number column when the rowNumVisible is true. <String:N> options.rowNumFooterFontColor : [default: N/A] Footer font color of the row number column in case of rowNumVisible=”true”. Options for the style of the Excel file - Subtotal <String:N> options.rowNumSubTotalColor : [default: N/A] Subtotal background color of the row number column in case of rowNumVisible=”true”. <String:N> options.rowNumSubTotalFontName : [default: N/A] Subtotal font of the row number column when the rowNumVisible is true. <String:N> options.rowNumSubTotalFontSize : [default: N/A] Subtotal font size of the row number column when the rowNumVisible is true. <String:N> options.rowNumSubTotalFontColor : [default: N/A] Subtotal font color of the row number column in case of rowNumVisible=”true”. Options for the process window <xmp class='js description'><Boolean:N> options.showProcess : [default: true] Whether to show the process or not. <Boolean:N> options.showConfirm : [default: false] Displays or hides the downloading confirmation window. ("true" requires the user’s clicking the Window button to start downloading. For the massStorage, "true" is set as default.) Options related to downloading of large-volume data <Boolean:N> options.massStorage : [default: true] Whether to allow massive volume data or not. (When this option is true and showConfirm is false, a reliable site checking option will be displayed on the IE.) <String:N> options.dataProvider : [default: N/A] Provider package to process large-volume data and the user data. <String:N> options.splitProvider : [default: N/A] Provider package to split large-volume data for efficient processing. <Boolean:N> options.numberToText : [default: false] Keeps the symbols included in the format such as comma when downloading data from a column for which numberExtraction is set as "true" and dataType as "number". <String:N> options.providerRequestXml : [default: N/A] XML string for internal uses by the provider <String:N> options.userDataXml : [default: N/A] Reserved for the developers to send data when developing server modules. Options for line break. <Boolean:N> options.bodyWordwrap : [default: false] Applies or cancels line breaks in the downloaded file. <Boolean:N> options.subtotalWordwrap : [default: false] Applies or cancels line breaks in the subtotal of the downloaded file. <Boolean:N> options.footerWordwrap : [default: false] Applies or cancels line breaks in the footer of the downloaded file. Options for display <String:N> options.useHeader : [default: true] Displays header. (“true” is to display, and “false” is not to display.) <String:N> options.useSubTotal : [default: false] Displays the SubTotal. (true to display, and false not to display.) Supports avg, sum, min, max, targetColValue, and number when an expression is used. <String:N> options.useFooter : Displays the footer upon download. [default: true] ("true" is to display, and "false" is not to display.) Options for cell merges <String:N> options.colMerge : [default: false] Whether to merge the columns for which colMerge has been executed for display. <String:N> options.colMergeValue : [default: false] Fills in the data in every cell upon being un-merged in the Excel. ("true" is to fill in the data in every un-merged cell, and "false" is to display only in the first row or column.) <String:N> options.colMergeTextAlign : [default: center] textAlign setting for the merged columns (bottom, center, or top) <String:N> options.mergeCell : [default: false] Maintains cell merges made by mergeCell API in the downloaded Excel file. Options for column moving. <String:N> options.columnMove : [default: false] Download the currently displayed GridView with columns being moved. (Set true to download as displayed.) <String:N> options.columnOrder : [default: N/A] Sets the sequence of the columns in the downloaded Excel file. (Example) 0, 3, 2, 1 <String:N> options.columnMoveWithFooter : [default: N/A] Downloads the file with both the footer and the body columns are being moved. Options for filtering. <String:N> options.headerAutoFilter : [default: false] Applies the filter to the hader. <String:N> options.filterRowIndex : [default: -1] Row index of the header to which the filter is applied. Printing <Object:N> options.printSet Print-related settings (saved in JSON format) <String:N> options.printSet.fitToPage : [default: false] Fits to the page when printing. <String:N> options.printSet.landScape : [default: false] Landscape printing <String:N> options.printSet.fitWidth : [default: 1] Paper width when printing <String:N> options.printSet.fitHeight : [default: 1] Paper height when printing <String:N> options.printSet.scale : [default: 100] Scale. fitToPage must be false, when a scale is defined. <String:N> options.printSet.pageSize : [default: A4] Page Size (Example: "A3", "A4", "A5", "B4") Valid when fitToPage: true. ETC <String:N> options.useEuroLocale : [default: false] Applies Euro locale. (Use . instead of , and vice versa.) <String:N> options.optionParam : [default: N/A] Value to be sent as the HashMap parameter for the user-defined class when the DRM is in use. For the key, use "optionParam".
infoArrObjectNAn array of GridView information to show it in another cell
<Number:N> infoArr.rowIndex : Row index to display text <Number:N> infoArr.colIndex : Column index to display contents <Number:N> infoArr.rowSpan : Number of the rows to merge <Number:N> infoArr.colSpan : Number of columns to merge <String:N> infoArr.text : Text to display <String:N> infoArr.textAlign : Alignment (left, center, right) <String:N> infoArr.fontSize : font size (Example: "20px") <String:N> infoArr.fontName : font name <String:N> infoArr.color : font color (Example) "red" <String:N> infoArr.fontWeight : font weight (Example) "bold" <String:N> infoArr.drawBorder : cell border (Example) true <String:N> infoArr.borderColor : border color (Example) "#FF0000", "red" <String:N> infoArr.borderWidth : border width ( "thin", "medium", "thick" ) <String:N> infoArr.wordWrap : Line breaks in the cell (Example: "true") <String:N> infoArr.bgColor : Background color of the cell (Example: "red")
Sample
// Download as an Excel without options specified options. var excelOpt = {}; // Downloading options for the Excel file excelOpt.fileName = "excelData.xls"; // The extension "xlsx" can be also used. gridView1.advancedExcelDownload( excelOpt );
advancedExcelUpload( options )
Reads an Excel file, and sets the read data in the GridView. (Supported for JDK 1.5 or higher.)
The Excel file must be of Excel 97 or a higher version. (Excel 5.0/7.0 not supported.)
Parameter
nametyperequireddescription
optionsObjectYExcel downloading options for the grid data saved in JSON format
Options for file uploading <String:N> options.popupUrl : URL of the popup to be called upon uploading <String:N> options.delim : Data delimiter for uploading (default: , ) <String:N> options.status : [default: R] Initial status of the uploaded data. The default is R. <String:N> options.pwd : Password to the encrypted Excel file. Options for the data to upload. <String:N> options.type : [default: 0] Data to use. When the inputType of the GridView column is "select", "autoComplete", or "checkcombobox". 0: Use the value. 1: Use the label. 2: Depending on the displayMode setting in the column, "value delim label" or "label delim value" will be used. <Number:N> options.sheetNo : [default: 0] Sheet number with the GridView data in the Excel file <Number:N> options.sheetName : [default: N/A] Name of the Excel sheet to upload to GridView. (SheetName is prior to the SheetNo.) <Boolean:N> options.activeSheet : [default: false] Interface to connect with the WGear. Uploads the active sheets. <Number:N> options.startRowIndex : [default: 0] Row index from which the GridView data starts in the Excel file (including the header.) <Number:N> options.startColumnIndex: [default: 0] Row index (including the header) from which the grid data starts in the Excel file <Number:N> options.endColumnIndex : [default: 0] Column index at which the grid data ends in the Excel file (If the Excel file has fewer columns than the grid columns, sets the grid columns.) <String:N> options.append : [default: 0] Whether to append the data from the Excel file to the grid or not. (1 is to append, and 0 is to delete the current grid data and insert the Excel file data.) <String:N> options.hidden : [default: 0] An integer to decide whether to include hidden columns in the Excel file. (0 is to insert null data in the hidden column, and 1 is to insert the hidden data of the Excel file in the grid.) <String:N> options.fillHidden : [default: 0] An integer to decide whether to insert null data to the hidden column in the grid. (1 is not to insert, and 0 is to insert the null data. If the hidden is 0, the fillHidden will not be valid.) <String:N> options.skipSpace : [default: 0] Skips the blank space. (1 is to skip, and 0 is to include.) <String:N> options.useMaxByteLength : [default: false] Uploads data as long as the maxByteLength not including those defined by the ignoreChar property. <String:N> options.byteCheckEncoding : [default: EUC-KR] Encoding for byte processing when the useMaxByteLength is set. In case of EUC-KR, 2-byte processing will be used, and in case of UTF-8, 3-byte processing will be used. (The default is EUC-KR.) <String:N> options.dateFormat : [default: yyyy-MM-dd] Format to apply when the cell format of the Excel is date. The default is "yyyy-MM-dd". <String:N> options.decimal : [default: 4] If the cell data is in decimal, specify the last decimal point. (Default: 4) (Example: When the value is 3, the forth decimal point value will be rounded off to the third point and the finally displayed value will have three decimal points.) Options for file uploading <String:N> options.headerExist : [default: 0] Whether the grid data contains the header in the Excel file (1 is when there is the header, and 0 is when there is not.) <String:N> options.footerExist : [default: 1] Whether the grid data contains the footer in the Excel file (1 is when there is the footer, and 0 is when there is not. The default is 1, and if there is not footer in the grid, no footer will be created in the Excel file.) Options for column setting. <Array:N> options.insertColumns : Not receives Radio and Checkbox columns from the Excel file, but uses customized setting for the upload. (Data Structure: [ { columnIndex:1, columnValue:"1" } ] ) <String:N> options.removeColumns : [default: N/A] If not saved, column index will be specified. (Multiple column indices are separated by comma.) Upload popup window <String:N> options.useModalDisable : [default: false] Disables the component in the parent window when the upload popup is activated. <String:N> options.features Style information in string to be applied when the Upload is displayed. If not specified, the Upload will be displayed in the basic style. ETC <String:N> options.optionParam : [default: N/A] Value to be sent as the HashMap parameter for the user-defined class when the DRM is in use. For the key, use "optionParam". <String:N> options.cellDataConvertor : [default: ""] Full package name of the class in which the user can edit the column value. (Inherit AbstractCellDataProvider class before writing and write the convertValue method.
Sample
// Upload an Excel file without options specified. gridView1.advancedExcelUpload( {} ); // Send an empty object when options are not specified to avoid errors.
changeCurrency( columnID , dataType , displayFormat , delimiter , decimalDelimiter )
Dynamically changes the monetary unit in the cell displayed on the column basis.
Valid when the dataType is "number", "tenge", "rupee", or "euro". (Options for gridView.column) dataType="number" dataType="tenge" dataType="rupee" dataType="euro"
Parameter
nametyperequireddescription
columnIDStringYID of the column to which the monetary unit is to be applied
dataTypeStringYMonetary unit to apply. (number, euro, rupee, tenge)
displayFormatStringNdisplayFormat for the column
delimiterStringNDelimiter
decimalDelimiterStringNDecimal point delimeter
Sample
gridView1.changeCurrency("standardAmt", "euro", "#.###,00"); The column ID is "standardAmt" and the cell value is "1234". Then, "1.234,00" will be displayed on the GridView. Set the following option in gridView1. euroMask="#.###,00" Call the following. gridView1.changeCurrency("standardAmt", "euro"); The column ID is "standardAmt" and the cell value is "1234". Then, "1.234,00" will be displayed on the GridView.
checkAll( colIndex , dataValue )
Selects or unselects all rows with checkboxes.
Parameter
nametyperequireddescription
colIndexStringYColumn ID or index of the checkbox
dataValueStringYChecking status (true/false, treuValue/falseValue, or 1/0). (If the value type is not specified, 1 will be for checked and 0 will be for unchecked.)
Checked: true, 1, and trueValue, Unchecked: false, 0, and fasleValue
clearAutoFit( )
Removes the autoFit property.
Cancels autoFit.
Sample
// (Example) gridView1.clearAutoFit();
clearGroupby( )
Cancels the groupBy setting.
clearRowVisible( )
Shows all rows hidden by the setRowVisible API. (Related Function) setRowVisible();
Sample
// (Example) // Display all rows hidden by setRowVisible API. gridView1.clearRowVisible();
drillTo( rowIndex )
Opens all rows to drill-down the row of the specified rowIndex.
Parameter
nametyperequireddescription
rowIndexNumberYRow index to display
getAllDisplayData( )
Returns the currently displayed data as a one-dimensional array. (displayFormat-applied data.)
Ignores the filter. For the filtered data, use getAllVisibleData.
Return
typedescription
ArrayOne-dimensional array containing the data
getAllDisplayJSON( )
Returns the currently displayed data as JSON data. (displayFormat-applied data.)
Ignores the filter and returns the entire data as JSON. Also ignores sorting when filtered.
Related function: getAllVisibleJSON (Return the filtering result as JSON.)
Similar function: getAllDisplayData (Return the entire data as the one-dimensional array), getAllDisplayXML (Return the entire data as XML.)
Return
typedescription
JSONJSON data
Sample
gridView1.getAllDisplayJSON = function () {return JSON;}
getAllDisplayXML( )
Returns the currently displayed data as XML data. (displayFormat-applied data.)
Ignores the filter. For the filtered data, use getAllVisibleXML.
Return
typedescription
XMLXML data
getAllFocusedIndex( )
Returns rowIndex and colIndex of the selected cells.
Mostly used when multiple cells are selected through the use of the Ctrl key.
Return
typedescription
ArrayJSON array containing rowIndex and colIndex of the selected cells
Sample
// Multiple cells are selected through the use of the Ctrl key. gridView1.getAllFocusedIndex(); // (Return) [ {col: 1, row: 2}, {col: 0, row: 4} ]
getAllFocusedRowIndex( )
Returns rowIndex of the focused cells selected by the Ctrl key.
Return
typedescription
ArrayArray of the rowIndex values of the focused cells
Sample
// Multiple cells are selected through the use of the Ctrl key. gridView1.getAllFocusedRowIndex(); // (Return) [ 0 , 1 ]
getAllVisibleData( )
Returns the currently displayed data as a one-dimensional array (being filtered).
Return
typedescription
ArrayOne-dimensional array containing the data
Sample
// Two columns and four rows of data are set in the DataList. gridView1.getAllVisibleData(); // (Return) ["Chris", "19930516", "John", "19780207", "Jason", "19930817", "Hanna", "19820301"]
getAllVisibleJSON( )
Returns the currently displayed data as JSON data. (displayFormat-applied data.)
If the data is filtered, returns the filtered data as JSON.
Return
typedescription
JSONJSON data
Sample
gridView1.getAllVisibleJSON = function () {return JSON;}
getAllVisibleXML( )
Returns the currently displayed data as an XML (being filtered).
Return
typedescription
XMLXML data
getAncestorRowIndexArray( rowIndex )
Returns the rowIndex of all parents of the specified row to support drill-down.
Parameter
nametyperequireddescription
rowIndexNumberYIndex of the row to check the parents
Return
typedescription
ArrayOne-dimensional array containing rowIndex
getBottomRowIndex( )
Returns rowIndex of the lowest row on the currently visible GridView component.
In case no row is rendered, "-1" will be returned.
Return
typedescription
NumberrowIndex of the bottom row
Sample
// Total 10 rows are set and four rows are displayed on the screen. // When total 10 rows of data are set and only four rows are visible (or when the height of the grid is too small to display 10 rows and only four rows are displayed) // Do the following: gridView1.getBottomRowIndex(); // (Return) 3
getCellBackgroundColor( rowIndex , colIndex )
Returns the background color of the cell of the corresponding rowIndex and the corresponding colIndex.
If no BackgroundColor is specified, an empty string ("") will be returned.
Parameter
nametyperequireddescription
rowIndexNumberYRow index to return the background color
colIndexString||NumberYColumn index or ID to return the background color
Return
typedescription
StringBackground color of the specified row
getCellChecked( rowIndex , colIndex )
Returns whether the cell of the corresponding rowIndex and the colIndex is checked or not.
Parameter
nametyperequireddescription
rowIndexNumberYRow index of the cell
colIndexNumber||StringYColumn index or ID of the cell
Return
typedescription
BooleanChecking status of the cell
getCellClass( rowIndex , colIndex )
Returns the name of the user class dynamically applied to the Grid cells.
Parameter
nametyperequireddescription
rowIndexNumberYRow number of the cell
colIndexNumberYRow number or column ID of the cell
Return
typedescription
String:YUser-defined class applied to the cell
getCellColor( rowIndex , colIndex )
Returns the Text color of the cell of the corresponding colIndex and the rowIndex.
If the Text color is not specified, an empty string will be returned.
Parameter
nametyperequireddescription
rowIndexNumberYRow index to return the text color
colIndexString||NumberYColumn index or ID to return the text color
Return
typedescription
StringText color of the cell
getCellDisabled( rowIndex , colIndex )
Returns the value of the disabled property of the cell of the corresponding colIndex and the rowIndex.
If not specified, an empty string will be returned.
Parameter
nametyperequireddescription
rowIndexNumberYRow index to get the disabled property value
colIndexString||NumberYColumn index or ID to get the disabled property value
Return
typedescription
BooleanIf not specified, an empty string will be returned.
getCellDisplayData( rowIndex , colIndex )
Returns the displayed data of the cell of the corresponding rowIndex and the colIndex (with displayFormat being applied).
Formatted data by displayFormat and so on.
Parameter
nametyperequireddescription
rowIndexNumberYRow index of the cell
colIndexString||NumberYColumn index or ID of the cell
Return
typedescription
StringData of the cell of the corresponding rowIndex and the colIndex
getCellPosition( row , colIndex , propertyName )
Returns the position of the cell (top or left).
Parameter
nametyperequireddescription
rowNumberYRow index of the cell (The index of the top cell on the current grid is considered as 0 regardless of vertical scrolling position.)
colIndexString||NumberYColumn index or ID of the cell
propertyNameStringY[top, left] Position of the cell to return
Return
typedescription
NumberPosition of the cell(top or left)
getCellReadOnly( rowIndex , colIndex )
Returns the value of the readOnly property of the cell of the corresponding colIndex and the rowIndex.
If not specified, empty string will be returned.
Parameter
nametyperequireddescription
rowIndexNumberYRow index to get the readOnly setting
colIndexString||NumberYColumn index or ID to get the readOnly setting
Return
typedescription
BooleanThe current value of the readOnly property
getCellSize( row , colIndex , sizeName )
Returns the cell size (width or height).
Parameter
nametyperequireddescription
rowNumberYRow index of the cell
colIndexString||NumberYColumn index or ID of the cell
sizeNameStringY[width, height] Name of the size to return
Return
typedescription
NumberSize of the cell (width or height)
Sample
// Three columns and two rows are set in the GridView component. // Getting the width of name column on the first row. var tmpCellWidth = gridView1.getCellSize(0,"name","width"); // (Return) 154 // Getting the height of the second column on the first row var tmpCellHeight = gridView1.getCellSize(0,1,"height"); // (Return) 20
getCheckedData( colIndex )
Returns the data of the checked row as an array when the column is of the corresponding colIndex and is a Radio or CheckBox component. If the column is not a Checkbox component, an empty array will be returned.
Parameter
nametyperequireddescription
colIndexNumber||StringYColumn index or ID
Return
typedescription
ArrayTwo-dimensional array containing the data
Sample
// The GridView has checkbox, name and birthday columns, and the ID of the checkbox column is "chk". var tmpRs = gridView1.getCheckedData("chk"); // (Return) [["1","Patrick Kim","19780207"],["1","Ray Park","19930817"],["1","Christina Park","19820301"]]
getCheckedIndex( colIndex )
Returns the index of the checked row as an array when the column is of the corresponding colIndex and the inputType property of the column is Radio or Checkbox.
Parameter
nametyperequireddescription
colIndexNumber||StringYColumn Index or ID
Return
typedescription
ArrayOne-dimensional array containing row indices
Sample
// The GridView has checkbox, name and birthday columns, and the ID of the checkbox column is "chk". var tmpRs = gridView1.getCheckedIndex("chk"); // (Return) [1,2,3]
getCheckedJSON( colIndex )
Returns the JSON data of the checked row as an array when the column of the corresponding colIndex is a Radio or Checkbox.
If the column is not a Checkbox component, an empty array will be returned.
Parameter
nametyperequireddescription
colIndexNumber||StringYColumn index or ID
Return
typedescription
ArrayOne-dimensional array containing JSON data
Sample
// The GridView has checkbox, name and birthday columns, and the ID of the checkbox column is "chk". var tmpRs = gridView1.getCheckedJSON("chk"); // (Return) [{"name":"Patrick Kim","birthday":"19780207","chk":"1","rowStatus":"U"},{"name":"Ray Park","birthday":"19930817","chk":"1","rowStatus":"U"},{"name":"Christina Park","birthday":"19820301","chk":"1","rowStatus":"U"}]
getCheckedXML( colIndex )
Returns the data of the checked row as an XML when the column of the corresponding colIndex is a Radio or CheckBox.
Parameter
nametyperequireddescription
colIndexNumber||StringYColumn index or ID
Return
typedescription
XMLXML Data
Sample
// The GridView has checkbox, name and birthday columns, and the ID of the checkbox column is "chk". var tmpRs = gridView1.getCheckedData("chk"); // (Return Example) <list> <map status="1" statusValue="U" id="1"> <chk>1</chk> <name>John</name> <birthday>19780207</birthday> </map> <map status="1" statusValue="U" id="2"> <chk>1</chk> <name>Jason</name> <birthday>19930817</birthday> </map> </list>
getChildrenRowIndexArray( rowIndex )
Returns the rowIndex of the children (one-depth below) of the row of the corresponding rowIndex as an array when drilling-down is enabled.
Parameter
nametyperequireddescription
rowIndexNumberYRow index to get the child
Return
typedescription
ArrayOne-dimensional array containing rowIndex
getColIdByHeaderId( headerId )
Returns the columnId of the body corresponding to the columnId of the header.
Parameter
nametyperequireddescription
headerIdStringYHeader ID
Return
typedescription
StringcolumnId of the body
getColumnBackgroundColor( colIndex )
Returns the background color of the column of the corresponding colIndex.
If not specified, an empty string will be returned.
Parameter
nametyperequireddescription
colIndexString||NumberYColumn index or ID to return the background color
Return
typedescription
StringBackground color of the column
getColumnColor( colIndex )
Returns the Text color of the column of the corresponding colIndex.
If not specified, an empty string will be returned.
Parameter
nametyperequireddescription
colIndexString||NumberYColumn index or ID to return the text color
Return
typedescription
StringText color of the column
getColumnDataListInfo( colIndex )
Returns the dataList bound with the column of the specified colIndex.
When the inputType of the GridView column is "select", "autoComplete", or "checkcombobox".
Parameter
nametyperequireddescription
colIndexNumberYColumn index
Return
typedescription
Object:YdataList id
getColumnDisabled( colIndex )
Returns the value of the disabled property of the row of the corresponding colIndex.
If not specified, an empty string will be returned.
Parameter
nametyperequireddescription
colIndexString||NumberYColumn index or ID to get the disabled property value
Return
typedescription
BooleanSetting of the disabled
getColumnID( colIndex )
Returns the value of the disabled property of the column of the corresponding colIndex.
Parameter
nametyperequireddescription
colIndexNumberYColumn index
Return
typedescription
StringColumn ID
getColumnIdListMultiRow( )
Returns all column IDs of the GridView as two-dimensional array data.
The rowIndex of each multiRow is allocated to the first dimension.
두 번째 차원에는 각 multiRow에 해당하는 column의 ID가 배열 형태로 할당됨.
In case of a single row, two-dimensional data will be returned with the size of the first dimension being 1.
Return
typedescription
ArrayReturns all column IDs of the GridView as two-dimensional array data.
Sample
// Case1 : There are two multiRows with the first row on col1 and col2 and with the second row on col3 and col4. gridView1.getMultiRowIndex(); // Return: [["col1","col2"], ["col3,col4"]] // Case 2: Single row on col1, col2, and col3. gridView1.getMultiRowIndex(); // Result: [["col1","col2","col3"]]
getColumnIndex( colIndex )
Receives the column ID, and returns the corresponding column index.
Parameter
nametyperequireddescription
colIndexStringYColumn id
Return
typedescription
NumberColumn index
getColumnNodeSet( colIndex )
Returns the nodeset of the column when the inputType = "select" or "autoComplete".
Pairs with setColumnNodeSet API.
Parameter
nametyperequireddescription
colIndexString||NumberYColumn ID or index
Return
typedescription
ObjectObject containing the nodeset of the column of the corresponding itemsetObj colIndex.
The object contains nodeset, label, and value.
Sample
var itemsetObj = gridView.getColumnNodeSet("col1"); var nodeset = itemsetObj.nodeset; var label = itemsetObj.label; var value = itemsetObj.value;
getColumnOrder( byName )
Returns the current sequence of the columns as an array. Returns an array of column index in default. When byName is true, an array containing column ID will be returned.
Parameter
nametyperequireddescription
byNameBooleanN[defulat:false, true] Whether to use the column ID instead of column index in the column order
Return
typedescription
ArrayAn array containing the order of the current column
getColumnReadOnly( colIndex )
Returns the value of the readOnly property of the column of the corresponding colIndex.
If not specified, empty string will be returned.
Parameter
nametyperequireddescription
colIndexString||NumberYColumn index or ID
Return
typedescription
BooleanCurrent value of the readOnly
getColumnType( colIndex )
Returns the inpuType of the specified column.
Parameter
nametyperequireddescription
colIndexString||NumberYcolumn id or index
Return
typedescription
StringinputType of the column
getColumnVisible( colIndex )
Returns the visible status of the column of the corresponding colIndex.
Parameter
nametyperequireddescription
colIndexNumber||StringYColumn index or ID to return the visible status
Return
typedescription
BooleanVisible status of the column
getDataDragDrop( )
Returns the dataDragDrop setting.
Return
typedescription
BooleandataDragDrop
Sample
gridView1.getDataDragDrop(); // Returns the current dataDragDrop setting.
getDataLength( )
[deprecated] Use getRowCount() instead. The number of the rows is returned.
Return
typedescription
numberNumber of the rows
getDataList( )
Returns the Id of the currently bound DataList. (Property of the DataList)
Return
typedescription
StringData ID
getDataListInfo( )
Returns the dataList bound with the component.
Return
typedescription
ObjectReturns nodeset, label, and value id as an object.
Sample
// Example gridView1.getDataListInfo();
getDataType( colID )
Returns the dataType of the column.
Parameter
nametyperequireddescription
colIDStringYColumn ID
Return
typedescription
StringdataType of the column
getDescendantRowIndexArray( rowIndex )
Returns rowIndex of all children of the specified row to support drill-down.
Parameter
nametyperequireddescription
rowIndexNumberYIndex of the row to check the children
Return
typedescription
ArrayOne-dimensional array containing rowIndex
getDisabled( type , rowIndex , colIndex )
Returns the value of the disabled property according to the type. (Description of the types) “all” : Checks the disabled property for the grid, rows, columns, and cells, and returns the disabled setting of the cell. “grid” : Returns the disabled setting of the entire GridView. "row" : Returns the disabled setting of the row. Functions same as getRowDisabled. Returns false if the disabled property is not enabled for the row although the property is enabled for the entire GridView. "column" : Returns the disabled setting of the column. Functions same as getColumnDisabled. Returns false if the disabled property is not enabled for the column although the property is enabled for the entire GridView. "cell" : Returns the disabled setting of the corresponding cell. Functions same as getCellDisabled API. Returns false if the disabled property is not enabled for the row or column of the cell although the property is enabled for the entire GridView.
Parameter
nametyperequireddescription
typeStringY[default:grid, row, column, cell, all] Type to get the disabled setting
rowIndexNumberYRow index to get the disabled property value
colIndexNumber||StringYColumn index or ID to get the disabled property value
Return
typedescription
BooleanReturns the value of the disabled property according to the type.
getFixedColumnLastIndex( includeDefaultColumn )
Returns the most right column index among the fixed columns.
Parameter
nametyperequireddescription
includeDefaultColumnbooleanYWhether to include rowNum and rowStatus columns. The default is to include.
Return
typedescription
NumberIndex of the most right column
getFixedRightColumnLastIndex( )
Returns the most right column index among the fixedrightColum columns.
Return
typedescription
NumberIndex of the most right column among the fixedRightColumns.
getFixedRow( )
Returns the horizontally fixing location when the GridView is horizontally fixed. For the fist row, returns "1".
getFocusedColumnID( )
Returns the ID of the column of the currently focused cell.
Return
typedescription
StringColumn ID of the currently focused cell
getFocusedColumnIndex( )
Returns the colIndex of the currently focused cell.
Return
typedescription
NumbercolIndex of the currently focused cell
getFocusedRowIndex( )
Returns the rowIndex of the currently focused cell.
Return
typedescription
NumberrowIndex of the currently focused cell
getFocusedRowStatus( )
Returns the status of the row in which the currently focused cell exists in status string. (Status) Initial Status: "R" Updated: "U" Inserted: "C" Deleted: "D" Inserted and Deleted: "V"
Return
typedescription
StringReturns the status of the row in which the currently focused cell exists in status string.
Initial Status: "R" Updated: "U" Inserted: "C" Deleted: "D" Inserted and Deleted: "V"
getFooterData( footerId , display )
Returns the footerId of the footer.
Returns the calculation result when the inputType is "expression".
Parameter
nametyperequireddescription
footerIdString||NumberYfooter id or index
displayStringN[displayData] Returns the formatted value for the displayData.
Return
typedescription
stringCorresponding footer
getFooterStyle( footerId , style )
Gets the style properties of the footer of the corresponding footerId.
Parameter
nametyperequireddescription
footerIdNumber||StringYGrid column index or ID
styleStringYStyle property
getFormattedHeaderValue( headerId , value )
Returns the header value formatted by the dispalyFormat.
Parameter
nametyperequireddescription
headerIdStringYHeader ID
valueStringYValue to format
Return
typedescription
StringFormatted value for the header
getGridReadOnly( )
Returns the readOnly property or the entire GridView.
Return
typedescription
BooleanreadOnly setting of the GridView
getHeaderBackgroundColor( headerId )
Returns the background color of the header cell.
Parameter
nametyperequireddescription
headerIdStringYheader cell ID
Return
typedescription
StringBackground color of the header cell
getHeaderClass( headerId )
Returns the name of the user class dynamically applied to the header cell of the Grid.
Parameter
nametyperequireddescription
headerIdNumberYheader cell ID
Return
typedescription
String:YUser-defined class applied to the cell
getHeaderColor( headerId )
Gets the Text color of the header cell.
Parameter
nametyperequireddescription
headerIdStringYheader cell ID
Return
typedescription
StringText color of the header cell
getHeaderID( header )
Returns the header ID through the header index.
Parameter
nametyperequireddescription
headerNumberYindex
Return
typedescription
getHeaderIndex( header )
Gets the header index through the header ID.
Parameter
nametyperequireddescription
headerStringYid
Return
typedescription
getHeaderPosition( headerId , propertyName )
Returns the position of the header cell (top or left).
Parameter
nametyperequireddescription
headerIdStringYHeader ID
propertyNameStringY[top, left] Name of the position information to return
Return
typedescription
NumberPosition of the header
getHeaderSize( headerId , sizeName )
Returns the size of the header cell (width or height).
Parameter
nametyperequireddescription
headerIdStringYHeader ID
sizeNameStringY[width, height] Name of the size information to return
Return
typedescription
NumberHeader size
getHeaderValue( headerId )
Returns the value of the header.
Parameter
nametyperequireddescription
headerIdStringYHeader ID
Return
typedescription
Stringheader value
getMaxLength( colIndex )
Returns the maxLength of the column.
Parameter
nametyperequireddescription
colIndexNumber||StringYColumn Index or ID
Return
typedescription
NumbermaxLength
Sample
gridView1.getMaxLength("a"); // Return the maxLength of the column of which ID is "a".
getMerged( rowIndex , colIndex )
Returns the merging state of the specified cell.
Parameter
nametyperequireddescription
rowIndexNumberYRow index of the cell to check the merging status
colIndexNumberYColumn index of the cell to check the merging status
Sample
gridView1.getMerged(0, 0); // Returns the merging state of (0, 0).
getOpenStatus( rowIndex )
Returns whether the row of the corresponding rowIndex can be drilled down in a Boolean value when the drilling-down is enabled for the entire GridView.
Parameter
nametyperequireddescription
rowIndexNumberYRow index to get openStatus
Return
typedescription
Boolean[true, false] Opening status of drilling-down
getOverflowX( )
Returns the setting of the overflowX property.
Return
typedescription
String[default:auto, hidden, scroll] Current value of the overflowX property
getOverflowY( )
Returns the setting of the overflowY property.
Return
typedescription
String[default:auto, hidden, scroll] Current value of the overflowY property
getParentRowIndex( rowIndex )
Returns the rowIndex of the parent row of the row of the corresponding rowIndex when drilling-down is allowed.
Parameter
nametyperequireddescription
rowIndexNumberYIndex of the row to get the parent
Return
typedescription
NumberrowIndex of the parent row
getReadOnly( type , rowIndex , colIndex )
Returns the value of the readOnly property depending on the type. (Description of the types) “grid” : Returns the readOnly setting for the entire GridView. "row" : Returns the readOnly setting for the row. Functions same as getRowReadOnly. Returns false if the readOnly is not set for the row although the readOnly is set for the entire GridView. "column" : Returns the readOnly setting for the column. Functions same as getColumnReadOnly. Returns false if the readOnly is not set for the column although the readOnly is set for the entire GridView. "cell" : Returns the readOnly setting for the cell. Functions same as getCellReadOnly. Returns false if the readOnly is not set for the cell of the column or row although the readOnly is set for the entire GridView. “all” : Checks the readOnly setting for the GridView, rows, columns, and cells, and returns the readOnly setting for the cell.</div> <!--만일 해당 Method 가 파라미터가 있는 경우 table 테그를 이용해서 보여준다.--> <table id="ptable"> <caption>Parameter</caption> <tr> <td class="header1">name</td><td class="header2">type</td><td class="header2">required</td><td class="header3">description</td> </tr> <tr> <td class="necessary">type</td><td class="row">String</td><td class="row">Y</td><td class="row">[default:grid, row, column, cell, all] Type to get the readOnly setting</td> </tr> <tr> <td class="necessary">rowIndex</td><td class="row">Number</td><td class="row">Y</td><td class="row">Row index or ID to get the readOnly setting</td> </tr> <tr> <td class="necessary">colIndex</td><td class="row">Number||String</td><td class="row">Y</td><td class="row">Column index or ID to get the readOnly setting</td> </tr> </table> <!--만일 해당 Method 에 return 값이 있는 경우 table 테그를 이용해서 보여준다.--> <table id="ptable"> <caption>Return</caption> <tr> <td class="header1">type</td><td class="header2">description</td> </tr> <tr> <td class="row">Boolean</td><td class="row">The current readOnly setting</td> </tr> </table> <div class="pdesc"></div> </dd> <a class="anchor" id="getRealRowIndex"></a> <dt class="apiname">getRealRowIndex( rowIndex ) </dt> <dd> <div class="pdesc">Returns the rowIndex of the actual data based on the rowIndex displayed on the screen when drilling-down is enabled.</div> <!--만일 해당 Method 가 파라미터가 있는 경우 table 테그를 이용해서 보여준다.--> <table id="ptable"> <caption>Parameter</caption> <tr> <td class="header1">name</td><td class="header2">type</td><td class="header2">required</td><td class="header3">description</td> </tr> <tr> <td class="necessary">rowIndex</td><td class="row">Number</td><td class="row">Y</td><td class="row">Index of the currently displayed row</td> </tr> </table> <!--만일 해당 Method 에 return 값이 있는 경우 table 테그를 이용해서 보여준다.--> <table id="ptable"> <caption>Return</caption> <tr> <td class="header1">type</td><td class="header2">description</td> </tr> <tr> <td class="row">Number</td><td class="row">Actual index of the row</td> </tr> </table> <div class="pdesc"></div> </dd> <a class="anchor" id="getRowBackgroundColor"></a> <dt class="apiname">getRowBackgroundColor( rowIndex ) </dt> <dd> <div class="pdesc">Returns the background color of the row of the corresponding rowIndex.</div> <!--만일 해당 Method 가 파라미터가 있는 경우 table 테그를 이용해서 보여준다.--> <table id="ptable"> <caption>Parameter</caption> <tr> <td class="header1">name</td><td class="header2">type</td><td class="header2">required</td><td class="header3">description</td> </tr> <tr> <td class="necessary">rowIndex</td><td class="row">Number</td><td class="row">Y</td><td class="row">Index of the row to get the background color</td> </tr> </table> <!--만일 해당 Method 에 return 값이 있는 경우 table 테그를 이용해서 보여준다.--> <table id="ptable"> <caption>Return</caption> <tr> <td class="header1">type</td><td class="header2">description</td> </tr> <tr> <td class="row">String</td><td class="row">Background color of the row</td> </tr> </table> <div class="pdesc"></div> </dd> <a class="anchor" id="getRowColor"></a> <dt class="apiname">getRowColor( rowIndex ) </dt> <dd> <div class="pdesc">Returns the Text color of the row of the corresponding rowIndex.</div> <!--만일 해당 Method 가 파라미터가 있는 경우 table 테그를 이용해서 보여준다.--> <table id="ptable"> <caption>Parameter</caption> <tr> <td class="header1">name</td><td class="header2">type</td><td class="header2">required</td><td class="header3">description</td> </tr> <tr> <td class="necessary">rowIndex</td><td class="row">Number</td><td class="row">Y</td><td class="row">Index of the row to get the Text color</td> </tr> </table> <!--만일 해당 Method 에 return 값이 있는 경우 table 테그를 이용해서 보여준다.--> <table id="ptable"> <caption>Return</caption> <tr> <td class="header1">type</td><td class="header2">description</td> </tr> <tr> <td class="row">String</td><td class="row">Text color of the row</td> </tr> </table> <div class="pdesc"></div> </dd> <a class="anchor" id="getRowDisabled"></a> <dt class="apiname">getRowDisabled( rowIndex ) </dt> <dd> <div class="pdesc">Returns the disabled setting of the specified row.</div> <!--만일 해당 Method 가 파라미터가 있는 경우 table 테그를 이용해서 보여준다.--> <table id="ptable"> <caption>Parameter</caption> <tr> <td class="header1">name</td><td class="header2">type</td><td class="header2">required</td><td class="header3">description</td> </tr> <tr> <td class="necessary">rowIndex</td><td class="row">Number</td><td class="row">Y</td><td class="row">Row index to get the disabled setting</td> </tr> </table> <!--만일 해당 Method 에 return 값이 있는 경우 table 테그를 이용해서 보여준다.--> <table id="ptable"> <caption>Return</caption> <tr> <td class="header1">type</td><td class="header2">description</td> </tr> <tr> <td class="row">Boolean</td><td class="row">disabled setting of the row</td> </tr> </table> <div class="pdesc"></div> </dd> <a class="anchor" id="getRowNumVisible"></a> <dt class="apiname">getRowNumVisible( ) </dt> <dd> <div class="pdesc">Returns the option values of the rowNumVisible.</div> <!--만일 해당 Method 가 파라미터가 있는 경우 table 테그를 이용해서 보여준다.--> <!--만일 해당 Method 에 return 값이 있는 경우 table 테그를 이용해서 보여준다.--> <table id="ptable"> <caption>Return</caption> <tr> <td class="header1">type</td><td class="header2">description</td> </tr> <tr> <td class="row">Boolean</td><td class="row">Settings of the rowNumVisible API</td> </tr> </table> <div class="pdesc"></div> </dd> <a class="anchor" id="getRowReadOnly"></a> <dt class="apiname">getRowReadOnly( rowIndex ) </dt> <dd> <div class="pdesc">Returns the value of the readOnly property of the row of the corresponding rowIndex.</div> <!--만일 해당 Method 가 파라미터가 있는 경우 table 테그를 이용해서 보여준다.--> <table id="ptable"> <caption>Parameter</caption> <tr> <td class="header1">name</td><td class="header2">type</td><td class="header2">required</td><td class="header3">description</td> </tr> <tr> <td class="necessary">rowIndex</td><td class="row">Number</td><td class="row">Y</td><td class="row">Row index to get the readOnly setting</td> </tr> </table> <!--만일 해당 Method 에 return 값이 있는 경우 table 테그를 이용해서 보여준다.--> <table id="ptable"> <caption>Return</caption> <tr> <td class="header1">type</td><td class="header2">description</td> </tr> <tr> <td class="row">Boolean</td><td class="row">If not specified, null data will be returned.</td> </tr> </table> <div class="pdesc"></div> </dd> <a class="anchor" id="getRowVisible"></a> <dt class="apiname">getRowVisible( rowIndex ) </dt> <dd> <div class="pdesc">Hides or shows specified rows.</div> <!--만일 해당 Method 가 파라미터가 있는 경우 table 테그를 이용해서 보여준다.--> <table id="ptable"> <caption>Parameter</caption> <tr> <td class="header1">name</td><td class="header2">type</td><td class="header2">required</td><td class="header3">description</td> </tr> <tr> <td class="necessary">rowIndex</td><td class="row">Number</td><td class="row">Y</td><td class="row">Index of the row to check the hidden status.</td> </tr> </table> <!--만일 해당 Method 에 return 값이 있는 경우 table 테그를 이용해서 보여준다.--> <table id="ptable"> <caption>Return</caption> <tr> <td class="header1">type</td><td class="header2">description</td> </tr> <tr> <td class="row">Boolean</td><td class="row">Visibility of the row. Returns false when hidden, or true when visible.</td> </tr> </table> <div class="caption_sample">Sample</div> <div class="pdesc"><xmp class='js sample'>gridView1.getRowVisible(30); // Returns the visibility of the 30th row.
getSortableArr( )
Returns the sortable status of the header columns as an array.
Return
typedescription
BooleanSortable status of each column
getSortableStatus( )
Returns header information as an array in the sequence of the sorted columns.
Returns an empty array when there is no sorted column.
Each object in the returned array contains colID, dataType, and sortOrder.
sortOrder="1" is for sorting in ascending orders, and sortableOrder="-1"is for descending orders.
Return
typedescription
ObjectSorted header information
// Columns of name, birthDate, and sex are defined and all sortable. Multi-sorted in the order of birthDate and name. var tmpArr = gridView1.getSortableStatus(); // (Return) [ {colID:"birthDate", dataType:"text", sortOrder:"1"}, {colID:"name", dataType:"text", sortOrder:"-1"}]
getTopRowIndex( )
Returns the rowIndex of the top row on the current screen.
In case no data is displayed on the GridView, "-1" will be returned.
Return
typedescription
NumberrowIndex of the top row
getTotalCol( )
Gets the total number of the columns (not including rowNum and rowStatus.)
Return
typedescription
NumberTotal number of the columns (not including rowNum and rowStatus)
getTotalHeaderCol( options )
Returns the visible status of the column of the corresponding colIndex.
Parameter
nametyperequireddescription
optionsObjectNOptions to get the number of the header columns.
<Boolean:N> options.mergedColumn : [default: false] Returns the number of the columns considering the merged header columns. <Boolean:N> options.defaultColumn : [default: false] Returns the number of the columns considering rowNum and rowStatus columns.
Return
typedescription
NumberNumber of header columnS
getTotalRow( )
Gets the total number of the rows.
Return
typedescription
NumberTotal number of the rows
getUncheckedData( colIndex )
Returns the data of the unchecked row as an array when the column of the corresponding colIndex is a Radio or CheckBox.
Parameter
nametyperequireddescription
colIndexNumber||StringYColumn index or ID to inspect the checking status
Return
typedescription
ArrayTwo-dimensional array containing row data
Sample
// checkbox, name, and birthday are defined in the GridView, and inputType of the column is "checkbox" and the ID of column is "chk". var tmpRs = gridView1.getUncheckedData("chk"); // ID of "checkbox" column is "chk". // (Return) [["0","Chris","19930516"],["0","John","19780207"],["0","Jason","19930817"]]
getUncheckedIndex( colIndex )
Returns the index of the unchecked row as an array when the inputType of the column of the corresponding colIndex has a Radio or CheckBox component.
Parameter
nametyperequireddescription
colIndexNumber||StringYColumn index or ID
Return
typedescription
ArrayOne-dimensional array containing row indices
Sample
// checkbox, name, and birthday are defined in the GridView, and inputType of the column is "checkbox" and the ID of column is "chk". gridView1.getUncheckedIndex("chk"); // ID of "checkbox" column is "chk". // (Return) [0,2,3]
getUncheckedJSON( colIndex )
Converts the data of the unchecked row into JSON data and returns as an array when the column of the corresponding colIndex is radio or checkbox.
Parameter
nametyperequireddescription
colIndexNumber||StringYIndex or ID of the column to check whether the input of the column is checkbox or not
Return
typedescription
ArrayOne-dimensional array containing JSON data of the row
// checkbox, name, and birthday are defined in the GridView, and inputType of the column is "checkbox" and the ID of column is "chk". var tmpRs = gridView1.getUncheckedJSON("chk"); // he ID of Checkbox column is chk. // (Return) [{"name":"IYOU","birthday":"19930516","chk":"0","rowStatus":"R"},{"name":"Patrick Kim","birthday":"19780207","chk":"0","rowStatus":"R"}]
getUncheckedXML( colIndex )
Returns the data of the unchecked row as an XML when the inputType of the column of the corresponding colIndex is radio or checkbox.
Parameter
nametyperequireddescription
colIndexNumber||StringYColumn Index or ID
Return
typedescription
XMLXML Data
Sample
// checkbox, name, and birthday are defined in the GridView, and inputType of the column is "checkbox" and the ID of column is "chk". var tmpRs = gridView1.getUncheckedXML("chk"); // The ID of Checkbox column is chk. // (Return) <list> <map status="0" statusValue="R" id="0"> <chk>0</chk> <name>Chris</name> <birthday>19930516</birthday> </map> <map status="0" statusValue="R" id="1"> <chk>0</chk> <name>John</name> <birthday>19780207</birthday> </map> </list>
getVisibleColData( colIndex )
Returns the currently displayed (filtered or sorted) data of the column of the corresponding colIndex as an array.
Parameter
nametyperequireddescription
colIndexNumber||StringYColumn index or ID to get the data
Return
typedescription
ArrayAn array of column data of the corresponding colIndex
getVisibleRowNum( )
Returns the number of the visible rows.
Not including subTotal and footer.
If four rows and a scroll bar are displayed on the GridView where 10 rows have been set, 4 will be returned.
Return
typedescription
NumberNumber of the currently visible rows
groupby( Options )
Groups two or more columns and displays only the grouping result (statistical data).
Cannot be used with the columnMove property at the same time.
Parameter
nametyperequireddescription
OptionsObjectNGrouping option
<Boolean:N> options.closeGroup : Hiding of the grouping result. <Boolean:N> options.rowNumHeader : rowNumVisible="true" is to display the total count on the header. <Boolean:N> options.rowNumFooter : rowNumVisible="true" is to display the total count on the footer. <Boolean:N> options.rowStatusHeader : rowStatusVisible="true" is to display the total count on the header. <Boolean:N> options.rowStatusFooter : rowStatusVisible="true" is to display the total count on the footer. <Object:N> options.groupbyHeader : Decides the way to display the total count on the header. <Object:N> options.groupbyFooter : Decides the way to display the total count on the footer. <Array:N> options.sortIndex : column index to sort <Array:N> options.sortOrder : 1 is to sort in ascending powers, and -1 is in descending powers. <Boolean:N> options.hideHeader : Hiding status of the result <Boolean:N> options.hideFooter : Hiding status of the result
Sample
var options = { sortIndex: [2], sortOrder: [1], hideHeader: false, hideFooter: true, groupbyHeader: { depth_0: [{colSpan:"3", value: "Daily Total"}, {inputType: "expression", expression: " SUM('complete')", className:"aaa"}] } }; gridView1.groupby(options);
hasChild( rowIndex )
Returns whether the row of the corresponding rowIndex has a child row or not when drilling-down is enabled.
Parameter
nametyperequireddescription
rowIndexNumberYrowIndex of the row to check whether it has child rows or not
Return
typedescription
BooleanWhether there are child rows or not
hideGroupbyZone( )
Hides the groupbyZone area.
initGrid( )
Deletes the entire date and the filtering conditions and initializes the column information (such as the nodeset of the SelectBox component) and returns the data as a one-dimensional array.
Return
typedescription
arrayOne-dimensional array containing the entire data
isEditing( )
Returns the current editing status of the GridView.
Return
typedescription
BooleanEditing status
mergeByCol( options )
Merges repetitive data cells within the same column. (Vertical merging)
Parameter
nametyperequireddescription
optionsObjectNMerge settings
<Boolean:N> options.noDraw Not update the GridView. (To be used for performance when merging several times.) <Boolean:N> options.keepMerge Keeps the previous merging. <Boolean:N> options.fixedRows Limits the row area to the fixedRow area. <Boolean:N> options.fixedCols Limits the column area to the fixedColumn area.
mergeByColRec( options )
Executes mergeByCol and mergeByRow for the cells not merged.
The vertical merging is prior.
Parameter
nametyperequireddescription
optionsJSONNMerge settings
<Boolean:N> options.noDraw Not update the GridView. (To be used for performance when merging several times.) <Boolean:N> options.keepMerge Keeps the previous merging. <Boolean:N> options.fixedRows Limits the row area to the fixedRow area. <Boolean:N> options.fixedCols Limits the column area to the fixedColumn area.
mergeByRestriCol( options )
Merges the rows when the same data is repeated within the column and the column on the left is merged.
Among n+1 columns, column n is defined as the upperColumn.
Parameter
nametyperequireddescription
optionsJSONNMerge settings
<Boolean:N> options.noDraw Not update the GridView. (To be used for performance when merging several times.) <Boolean:N> options.keepMerge Keeps the previous merging.
mergeByRestricRow( options )
Merges the rows when the same data is repeated within the same row and the upper row is merged.
Among n+1 rows, row n is defined as the upperRow.
Parameter
nametyperequireddescription
optionsJSONNMerge settings
<Boolean:N> options.noDraw Not update the GridView. (To be used for performance when merging several times.) <Boolean:N> options.keepMerge Keeps the previous merging.
mergeByRow( options )
Merge the cells with the same data within the same row. (Horizontal merging)
Parameter
nametyperequireddescription
optionsJSONNMerge settings
<Boolean:N> options.noDraw Not update the GridView. (To be used for performance when merging several times.) <Boolean:N> options.keepMerge Keeps the previous merging. <Boolean:N> options.fixedRows Limits the row area to the fixedRow area. <Boolean:N> options.fixedCols Limits the column area to the fixedColumn area.
mergeByRowRec( options )
Executes mergeByRow and mergeByCol for the cells not merged.
The horizontal merging is prior.
Parameter
nametyperequireddescription
optionsJSONNMerge settings
<Boolean:N> options.noDraw Not update the GridView. (To be used for performance when merging several times.) <Boolean:N> options.keepMerge Keeps the previous merging. <Boolean:N> options.fixedRows Limits the row area to the fixedRow area. <Boolean:N> options.fixedCols Limits the column area to the fixedColumn area.
mergeCell( mergeInfo )
Dynamically merges cells.
Parameter
nametyperequireddescription
mergeInfoJSONYObject containing information of the cell to merge (rowIndex, colIndex, colSpan, and rowSpan)
<Number:Y> mergeInfo.rowIndex Coordinates of the merging starting point (Row index) (Input the index of the far-left top cell when merging multiple cells.) <Number:Y> mergeInfo.colIndex Coordinates of the merging starting point (Column index) <Number:Y> mergeInfo.colSpan Number of the columns to merge <Number:Y> mergeInfo.rowSpan Number of the rows to merge
Sample
gridView1.mergeCell({"rowIndex" : 3, "colIndex" : 2, "colSpan" : 2, "rowSpan" : 2}); // Execution Result: The cell at (3,2) will be merged at the size of 2*2. // In other words, cells of (3,2), (3,3), (4,2), and (4,3) will be merged, and all the merged cell will have the data of cell (3,2).
mergeCells( mergeOptionStr , options )
Merges adjacent cells of the same data in the same row or on the same column.
Parameter
nametyperequireddescription
mergeOptionStrStringYSet the automatic merging method. Options are as follows:
never: Unmerges cells that have been automatically merged by mergeCells. bycol : Merges the adjacent rows with the same data within the same column. byrow : Merges the adjacent columns with the same data within the same row. “bycolrec” : Conducts bycol and byrow for the unmerged cells. “byrowrec” : Conducts byrow and bycol for the unmerged cells.
optionsJSONNMerge settings
<Boolean:N> options.noDraw Not update the GridView. (To be used for performance when merging several times.) <Boolean:N> options.keepMerge Keeps the previous merging. <Boolean:N> options.fixedRows Limits the row area to the fixedRow area. <Boolean:N> options.fixedCols Limits the column area to the fixedColumn area.
mergeCellsFixedCols( mergeOptionStr , options )
Executes mergeCells within the fixedColumn area.
Parameter
nametyperequireddescription
mergeOptionStrStringYSet the automatic merging method. Options are as follows:
never: Unmerges cells that have been automatically merged by mergeCells. bycol : Merges the adjacent rows with the same data within the same column. byrow : Merges the adjacent columns with the same data within the same row. “bycolrec” : Conducts bycol and byrow for the unmerged cells. “byrowrec” : Conducts byrow and bycol for the unmerged cells.
optionsJSONNMerge settings
<Boolean:N> options.noDraw Not update the GridView. (To be used for performance when merging several times.) <Boolean:N> options.keepMerge Keeps the previous merging. Calling this API will force-set the keepMerge property as “true”. <Boolean:N> options.fixedRows Limits the row area to the fixedRow area. <Boolean:N> options.fixedCols LImits the columm area to the fixedColumn area. Calling this API willl fore-set the fixedCols property as “true”.
mergeCellsFixedRows( mergeOptionStr , options )
Executes mergeCells within the fixedRow area.
Parameter
nametyperequireddescription
mergeOptionStrStringYSet the automatic merging method. Options are as follows:
never: Unmerges cells that have been automatically merged by mergeCells. bycol : Merges the adjacent rows with the same data within the same column. byrow : Merges the adjacent columns with the same data within the same row. “bycolrec” : Conducts bycol and byrow for the unmerged cells. “byrowrec” : Conducts byrow and bycol for the unmerged cells.
optionsJSONNMerge settings
<Boolean:N> options.noDraw Not update the GridView. (To be used for performance when merging several times.) <Boolean:N> options.keepMerge Keeps the previous merging. Calling this API will force-set the keepMerge property as “true”. <Boolean:N> options.fixedRows Limits the row area to the fixedRow area. Calling this API will force-set the fixedRows property as true. <Boolean:N> options.fixedCols Limits the column area to the fixedColumn area.
mergeClear( )
Unmerges all cynamically merged cells.
Clears only the cells dynamically merged by mergeCell or mergeCells.
mergeCol( colIndex , flag )
Excludes a certain column from automatic merging based on the data.
Parameter
nametyperequireddescription
colIndexNumberYTarget column to decide whether to use the automatic merging function or not.
flagBooleanY
Sample
grid1.mergeCol(1, false); // Exclude the second column from data-based merging. grid1.mergeByCol(); // Execute mergeByCol on the columns except the second column.
mergeFocusedCell( )
Merges only the currently focused cells.
Sample
Conduct the following while cells of (6,6), (6,7), (7,6), and (7,7) are focused. gridView1.mergeFocusedCell(); // Execution Result: The cell of (6,6) will be merged at the size of 2*2. // In other words, cells of (6,6), (6,7), (7,6), and (7,7) are merged. Then, all merged cells will have the data of cell (6,6).
mergeRow( rowIndex , flag )
Excludes a certain row from automatic merging based on the data.
Parameter
nametyperequireddescription
rowIndexNumberYTarget row to decide whether to use the automatic merging feature or not.
flagBooleanY
Sample
grid1.mergeRow(1, false); // Exclude the second row from the data-based merging. grid1.mergeByRow(); // Execute mergeByRow for the rows except the second row.
mergeSplitFocusedCell( )
Splits the currently focused cell merged.
Sample
Conduct the following while the merged cells of (6,6), (6,7), (7,6), and (7,7) are currently focused. gridView1.mergeFocusedCell(); // Execution Result: Split into (6,6), (6,7), (7,6), and (7,7).
modifyCheckedStatus( colIndex , status )
Changes the status codes of all checked rows when the inputType of the specified column is checkbox.
Parameter
nametyperequireddescription
colIndexStringYColumn index or ID to inspect the checked status
statusStringY[R,C,U,D,V] New status code
Sample
// checkbox and name columns are defined and two rows are set on the GridView. The id of the checkbox column is "chk". // The checkbox of the first row is checked, and the checkbox of the second row is not checked. // Change status of all checked columns into D through the use of modifyChecked Status and the checkbox column IDs. gridView1.modifyCheckedStatus("chk","D"); // Get the status of the first row. (When the checkbox is checked.) var tmpRs1 = gridView1.getRowStatus(0); // (Return) "D" // Get the status of the second row. (When the checkbox is not checked.) var tmpRs2 = gridView1.getRowStatus(1); // (Return) "R" // No modification made in the row.
modifyUncheckStatus( col , status )
Changes the status codes of unchecked rows when the inputType of the specified column is checkbox.
Parameter
nametyperequireddescription
colStringYColumn index or ID to check the unchecked status
statusStringY[R,C,U,D,V] New status code
Sample
// checkbox and name columns are defined and two rows are set on the GridView. The id of the checkbox column is "chk". // The checkbox of the first row is checked, and the checkbox of the second row is not checked. // Change status of all unchecked columns into D through the use of modifyCheckedStatus and checkbox column IDs. gridView1.modifyUncheckedStatus("chk","D"); // Get the status of the first row. (When the checkbox is checked.) var tmpRs1 = gridView1.getRowStatus(0); // (Return) "R" // No modification made in the row. // Get the status of the second row. (When the checkbox is not checked.) var tmpRs2 = gridView1.getRowStatus(1); // (Return) "D"
moveFooterColumn( fromIdx , toIdx )
Moves the footer column from fromIdx to toIdx.
Parameter
nametyperequireddescription
fromIdxStringYFooter column ID or index to move
toIdxStringYFooter column ID or index in the destination
Sample
gridView1.moveFooterColumn("column5, "column2"); // Result: column5 is moved to the left of column2 or before column2.
readCSV( options )
Reads a CSV file and sets the grid data. (Supported for JDK 1.5 and higher versions.)
Parameter
nametyperequireddescription
optionsJSONYUploading options for a CSV file to a JSON GridView
Options for file uploading <String:N> options.popupUrl URL of the popup to be called upon uploading <String:N> options.status [default: R] Initial status of the uploaded data. The default is R. Options for the data. <String:N> options.type [default: 1, 0] Data to use. When the inputType of the GridView column is "select", "autoComplete", or "checkcombobox". 0: Use the value. 1: Use the label. 2: Depending on the displayMode setting in the column, "value delim label" or "label delim value" will be used. <String:N> options.header [default: 1, 0] Whether to include GridView headers (“0” is to ignore header rows, and “1” is to skip as many as header rows.) <String:N> options.delim [default: ','] Data delimiter in the CSV file <String:N> options.escapeChar Characters to remove from the CSV data ( ex) '\'' <Number:N> options.startRowIndex [default: 0] Index of the row in the CSV file from where the grid data starts, The header setting will be ignored when the startRowIndex is specified. <String:N> options.append [default: 0, 1] Whether to append the data from the CSV file to the grid or not. (1 is to append, and 0 is to delete the current data and insert the CSV file data.) <String:N> options.skipSpace [default: 1, 0] Whether the data includes expression column data. (1 is to include, and 0 is not. The default is 1.) <String:N> options.ignoreSpan [default: 0, 1] Whether to ignore spanning or not. (“0” is to view the merged columns as one column, and “1” is to read each of the merged columns.) Options for the hidden columns <Number:N> options.hidden [default: 0, 1] Whether to save hidden columns or not. (“0” is not to save, and “1” is to save.) <String:N> options.fillHidden [default: 0, 1] An integer to decide whether to enter empty data to the hidden columns. (“1” is not to enter, and “0” is to consider the hidden column is not saved in the CSV file and to enter empty value. If hidden is “0”, fillHidden will not be valid.) Options for the upload window. <String:N> options.useModalDisable : [default: false] Disables the component in the parent window when the upload popup is activated. Other options <String:N> options.optionParam [default: N/A] Value to be sent as the HashMap parameter for the user-defined class when the DRM is in use. For the key, use "optionParam".
Sample
var options = { type: "1", delim: ",", escapeChar: "'", startRowIndex: 1, append: "0", hidden: "0", fillHidden: "0", skipSpace: "1" }; gridView1.readCSV(options); // Give an empty object as a parameter when no option is specified. gridView1.readCSV({});
redrawColumn( colIndex , valid )
Resets the specified column. (Reset.)
Parameter
nametyperequireddescription
colIndexString||NumberYColumn ID or index
validBooleanN[default:true, false] Processes the data based on the cell value when the inputType is “select”.
refreshCell( rowIndex , colIndex )
Refreshes the cell of the corresponding index.
Parameter
nametyperequireddescription
rowIndexNumberYRow index
colIndexNumberYColumn index
refreshColumn( colIndex )
Refreshes the column of the specified index.
Parameter
nametyperequireddescription
colIndexNumberYColumn index
refreshColumnItemset( col )
Valid only when the inputType is Select. Updates the itemset of the specified column.
Parameter
nametyperequireddescription
colStringYColumn ID or index to update
refreshRow( rowIndex )
Refreshes the row of the specified index.
Parameter
nametyperequireddescription
rowIndexNumberYRow index
removeCellClass( rowIndex , colIndex )
Removes the user-defined class from the Grid cell.
Parameter
nametyperequireddescription
rowIndexNumberYRow number of the cell
colIndexNumberYRow number or column ID of the cell
removeFocusedCell( )
Removes focus from all (selected) cells.
removeFocusedMultiCell( startRow , startCol , endRow , endCol )
Removes focuses from the cells within the specified rectangular area.
Parameter
nametyperequireddescription
startRowNumberYRow index of the focusing-starting point. rowIndex at the upper-left corner.
startColNumberYColumn index of the unfocusing-starting point. colIndex at the upper-left corner of the area
endRowNumberYRow index of the unfocusing-ending point rowIndex of the lower-right corner of the area
endColNumberYColumn index of the unfocusing-ending point colIndex of the lower-right corner of the area
Sample
gridView1.removeFocusedMultiCell(3,2,4,3); // Execution Result: (3,2), (3,3), (4,2), and (4,3) cells will be unfocused. Unfocused cells will remain the same.
removeHeaderClass( headerId , class )
Removes the user class applied to the header cell of the Grid.
Parameter
nametyperequireddescription
headerIdNumberYheader cell ID
classStringYClass to remove.
saveCSV( options )
Saves the data as a CSV file. (Supported for JDK 1.5 and higher versions.)
Parameter
nametyperequireddescription
optionsJSONYDownloading options for the JSON data grid as a CSV file
Options for file downloading <String:N> options.fileName [default: csvfile.csv] Default file name upon displaying of the file selection dialog <String:N> options.delim [default: ';'] Data delimiter in the CSV file Options related to the data to download <String:N> options.type [default: 1, 0] Data to use. When the inputType of the GridView column is "select", "autoComplete", or "checkcombobox". 0: Use the value. 1: Use the label. 2: Depending on the displayMode setting in the column, "value delim label" or "label delim value" will be used. <String:N> options.removeColumns [default: N/A] If not saved, column index will be specified. (Multiple column indices are separated by comma.) <String:N> options.header [default: 1, 0] Whether to save the GridView headers. (0 is not to save, and 1 is to save.) <Number:N> options.hidden [default: 0, 1] Whether to save the hidden columns of the GridView. (0 is not to save, and 1 is to save.) <String:N> options.checkButton [default: 1, 0] Whether to hide the control columns of the GridView (such as Check, Radio, and Button). (0 is to hide, and 1 is to save.) <Array:N> options.saveList [default: /A] Array of the column IDs to save in top priority regardless of hidden status <String:N> options.aposPrefixOnNum [default: 0, 1] ADds ‘ (apos) when the dataType is number and the length is in 12 digits. (0 is not to add apos and 1 is to add.) <String:N> options.removeQuotation [default: 0, 1] Removes the “,” included in the value. (0 is not to delete, 1 is to delete.) <String:N> options.removeNewLine [default: 1, 0] 1, 0] Deletion status when the value includes \r\n. (“0” is not to delete, and “1” is to delete.) Options for column moving. <String:N> options.columnMove [default: false] Download the currently displayed GridView with columns being moved. (Set true to download as displayed.) <String:N> options.columnOrder [default: N/A] Sets the sequence of the columns in the downloaded CSV file. (Example) 0, 3, 2, 1 Options for drill-down and merges <String:N> options.spanAll [default: false] Unfolds all items when the drilldown is enabled for the GridView. (true is to span all, and false is to display only visible items.) <String:N> options.ignoreSpan [default: 0, 1] Ignores the span and fill in the data. (“0” is not to save, and “1” is to save.) Other options <String:N> options.optionParam [default: N/A] Value to be sent as the HashMap parameter for the user-defined class when the DRM is in use. For the key, use "optionParam".
Sample
// Specify columns to save. var colArr = []; colArr[0] = "name"; colArr[1] = "corp"; // Download options var options = { fileName: "saveCSV.csv", type: "1", delim: ";", saveList: colArr }; gridView1.saveCSV(options); // Give an empty object as a parameter when no option is specified. gridView1.saveCSV({});
setAutoFit( options )
Sets the autoFit property.
Automatically changes the column sizes to fit to the size of the GridView.
options.type : autoFit setting (“lastColumn” is to adjust only the width of the last column, and “allColumn” is to evenly adjust of the widths of all columns.)
Parameter
nametyperequireddescription
optionsObjectNsetAutoFit options for the JSON data grid
<String:N> options.type : autoFit setting (lastColumn is to adjust only the width of the last column, and allColumn is to evenly adjust of the widths of all columns.) <Number:N> options.minWidth : Minimum width of the GridView in pixels (Not valid when autoFit is lastColumn.)
Sample
var options = { type : "allColumn", minWidth : 480 } gridView1.setAutoFit( options ); If the width of the GridView is smaller than 480 pixels, the sum of the the widths of the columns will be fixed to 480 pixels and each column width will be adjusted to 480 pixels. If the width of the GridView is larger than 480 pixels, the width of each column will be accordingly adjusted to the width of the GridView.
setBottomRowIndex( bottomRowIndex )
Sets the row of the corresponding bottomRowIndex to the bottom of the currently displayed area of the GridView component. (Moves the vertical scroll bar.)
Moves the vertical scroll bar.
Parameter
nametyperequireddescription
bottomRowIndexNumberYrowIndex of the bottom
setCaption( htmlStr )
Defines the HTML caption property or the GridView component. (The GridView is a table.)
Parameter
nametyperequireddescription
htmlStrStringYCaption text. Supports both Text and HTML tag strings.
setCaptionAuto( captionTitle )
Sets the captionTitle as the table title. (Related Property) captionTitle captionAuto
Parameter
nametyperequireddescription
captionTitleStringNNew value to set in the captionTitle property
Sample
// Example gridView1.setCaptionAuto("new title");
setCellAllowChar( rowIndex , colIndex , allowChar )
Changes the setting of the allowChar property of a certain cell. (Valid when the inputType="custom".)
Parameter
nametyperequireddescription
rowIndexNumberYIndex of the cell to change
colIndexNumberYIndex of the column to change
allowCharStringYallowChar to set
setCellBackgroundColor( rowIndex , colIndex , color )
Sets the background color of the cell of the corresponding rowIndex and the colIndex.
Parameter
nametyperequireddescription
rowIndexNumberYRow index to set the background color
colIndexNumber||StringYColumn index or ID to set the background color
colorStringYBackground color
setCellChecked( rowIndex , colIndex , flag )
Selects or unselects the cell in inputType="checkbox" or "radio" column.
Parameter
nametyperequireddescription
rowIndexNumberYRow index of the cell
colIndexString||NumberYColumn ID or index of the cell
flagBooleanY[true,false] Whether the cell is checked or no
setCellClass( rowIndex , colIndex , className )
Dynamically applied the user class to the Grid cell.
Parameter
nametyperequireddescription
rowIndexNumberYRow number of the cell
colIndexNumberYRow number or column ID of the cell
classNameStringYClass to apply to td
setCellColor( rowIndex , colIndex , color )
Sets the Text color of the cell of the corresponding rowIndex and the colIndex.
Parameter
nametyperequireddescription
rowIndexNumberYRow index or ID to set the text color
colIndexNumber||StringYColumn index to set the text color
colorStringYText color
setCellCustomFormatter( rowIndex , colIndex , formatter )
Changes the setting of the customFormatter property of a certain cell. (Valid when the inputType is "custom".)
Parameter
nametyperequireddescription
rowIndexNumberYIndex of the cell to change
colIndexNumberYIndex of the column to change
formatterStringYName of the new customFormatter
setCellDataType( rowIndex , colIndex , dataType )
Changes the setting of the dataType property of a certain cell. (Valid when the inputType="custom".)
Parameter
nametyperequireddescription
rowIndexNumberYIndex of the cell to change
colIndexNumberYIndex of the column to change
dataTypeStringYdataType to set
setCellDisabled( rowIndex , colIndex , disabled )
Sets the value of the disabled property of the cell of the corresponding colIndex and the rowIndex.
Parameter
nametyperequireddescription
rowIndexNumberYRow index to set the disabled property
colIndexNumber||StringYColumn index or ID to set the disabled property
disabledBooleanY[true,false] Setting of the disabled property
setCellDisableEdit( rowIndex , colIndex , onoff )
Changes the disableEdit property when the inputType=“custom” cell is autoComplete. (Valid when the inputType is “custom”.)
Parameter
nametyperequireddescription
rowIndexNumberYIndex of the cell to change
colIndexNumberYIndex of the column to change
onoffStringYdisableEdit property
setCellDisplayFormat( rowIndex , colIndex , displayFormat )
Changes the setting of the displayFormat property of a certain cell. (Valid when the inputType="custom".)
Parameter
nametyperequireddescription
rowIndexNumberYIndex of the cell to change
colIndexNumberYIndex of the column to change
displayFormatStringYdisplayFormat to set
setCellDisplayFormatter( rowIndex , colIndex , formatter )
Changes the setting of the displayFormatter property of a certain cell. (Valid when the inputType is "custom".)
Parameter
nametyperequireddescription
rowIndexNumberYIndex of the cell to change
colIndexNumberYIndex of the column to change
formatterStringYName of the new displayFormatter
setCellInputType( rowIndex , colIndex , info )
Sets the inputType of the cell of the specified rowIndex and the colIndex.
Valid for inputType="custom".
Add setCellInputTypeCustom="true" setting to the GridView.
Parameter
nametyperequireddescription
rowIndexNumberYRow index of the cell
colIndexStringYColumn index or ID of the cell
infoObjectYinputType information saved in JSON format
<String:N> info.id : cell id <String:Y> info.inputType : inputType to save <String:N> info.options : inputType options <String:N> info.itemSet : Object containing nodeset information <String:N> info.itemSet.nodeset : DataList ID. Must start with "data:". <String:N> info.itemSet.label : Column ID to set as the label. <String:N> info.itemSet.value : Column ID to set as the value.
Sample
var info = { inputType : "select", options : { selectedData : false, viewType: "icon", chooseOption: true }, itemSet : { nodeset: "data:dataList1", label: "label", value: "value" } } gridView1.setCellInputType(0, "a", info); // Changes the inputType of the cell which is on the first row and colmn "a" into select.
setCellMaxLength( rowIndex , colIndex , maxLength )
Changes the setting of the maxLength property of a certain cell. (Valid when the inputType="custom".)
Parameter
nametyperequireddescription
rowIndexNumberYIndex of the cell to change
colIndexNumberYIndex of the column to change
maxLengthNumber||StringYmaxLength to set
setCellReadOnly( rowIndex , colIndex , readOnly )
Sets the value of the readOnly property of the cell of the corresponding colIndex and the rowIndex.
Parameter
nametyperequireddescription
rowIndexNumberYRow index or ID to set the readOnly property
colIndexNumber||StringYColumn index to set the readOnly property
readOnlyBooleanY[true,false] The value of the readOnly property
setColumnBackgroundColor( colIndex , color )
Sets the background color of the column of the corresponding colIndex.
Parameter
nametyperequireddescription
colIndexNumber||StringYColumn index or ID to set the background color
colorStringYBackground color
setColumnChooseOption( colIndex , chooseOptionValue , chooseOptionLabel )
Changes the value and the label of the chooseOption property of the SelectBox when the inputType is select in the gridView column.
Parameter
nametyperequireddescription
colIndexNumberYgridView column index
chooseOptionValueStringYNew chooseOption value to set
chooseOptionLabelStringYNew chooseOption label to set
Sample
gridView1.setColumnChooseOption(1,"","-Choose-");
setColumnColor( colIndex , color )
Sets the Text color in the column of the corresponding colIndex.
Parameter
nametyperequireddescription
colIndexNumber||StringYColumn index to set the text color
colorStringYText color
setColumnDisabled( colIndex , disabled )
Sets the disabled property for all rows of the corresponding colIndex.
Parameter
nametyperequireddescription
colIndexNumber||StringYColumn index or ID to set the disabled property
disabledBooleanY[true, false] Setting of the disabled property
setColumnDisableEdit( rowIndex , onoff )
Changes the disableEdit property of the inputType=“autoComplete” column.
Parameter
nametyperequireddescription
rowIndexNumberYIndex of the cell to change
onoffStringYdisableEdit property
setColumnDisplayFormat( colIndex , displayFormat )
Sets the value of the displayFormat property of the column. Replaces the existing setDisplayFormat API.
displayFormat is applied according to the dataType of the column defined in the DataList.
Parameter
nametyperequireddescription
colIndexNumber||StringYColumn Index or ID
displayFormatStringYdisplayFormat for the column
Sample
// The colum ID Of the birth date is “birthday”. // The dataType of the birthday column is “date”. // Change the displayFormat of the "birthday" column into dd-MM yyyy. gridView1.setDisplayFormat("birthday","dd-MM yyyy"); // (Display) Data "19831231" will be displayed as "31-12 1983".
setColumnDisplayFormatter( colIndex , displayFormatter )
Sets the value of the displayFormatter property of the column.
Replaces the existing setDisplayFormatter API.
Parameter
nametyperequireddescription
colIndexNumber||StringYColumn Index or ID
displayFormatterStringYName of the function to apply to the displayFormatter
setColumnGridItemset( colIndex , obj )
Dynamically changes the gridViewItemset when inputType = "select" and gridViewItemset are used.
Parameter
nametyperequireddescription
colIndexNumber||StringYColumn index or id
objJSON||XMLYObject containing the gridViewItemset to be newly created. JSON or XML object.
<String> obj.nodeset : ID of the dataList to newly set. Add "data:" prefix. <String> obj.label : ID of the column to set as label. <String> obj.value : ID of the column to set as value. <Number> obj.width : Width of the gridViewItemset to newly set. <Number> obj.height : Height of the gridViewItemset to newly set. <Array> obj.item : Send the settings of each column to newly as as JSON array data.
Sample
var obj = { "nodeset" : "data:dataList2", "label" : "col1", "value" : "col2", "width" : 400, "height" : 300, "item" : [{"ref" : "col1", "header" : "label"},{"ref" : "col2", "header" : "value"},{"ref" : "col3", "header" : "dummy"}] }; gridView1.setColumnGridItemset("col1", obj);
setColumnIoFormat( colIndex , ioFormat , dateMast )
Sets the ioFormat property of the column.
Valid when the dataType is date.
Parameter
nametyperequireddescription
colIndexNumber||StringYColumn Index or ID
ioFormatStringYioFormat to set
dateMastStringNNew dateMask(displayFormat)
setColumnNodeSet( colIndex , nodeset , label , value )
Sets the nodeset of the column for which an itemset can be set.
When the inputType of the GridView column is "select", "autoComplete", or "checkcombobox".
Parameter
nametyperequireddescription
colIndexNumberYIndex or ID of the column to set the nodeset
nodesetStringNNode to set. Define the dataList ID following data: prefix.
labelStringNNew label. Column ID of the datalist
valueStringNNew value. Column ID of the dataList
setColumnOrder( columnOrderArray )
Rearranges the order of the columns based on the given array. The columns not specified by the parameter will be put after the columns specified by parameters.
Parameter
nametyperequireddescription
columnOrderArrayArrayYArray of the column orders (by column index or column ID)
Sample
// The GridView has following column IDs. // name, gender, age, and birthday // Change the orders of "age" and "gender" columns. gridView1.setColumnOrder(["age","gender"]); // The columns will be in an order of "age", "gender", "name", and "birthday".
setColumnReadOnly( colIndex , readOnly )
Sets the value of the readOnly property or the column of the corresponding colIndex.
Parameter
nametyperequireddescription
colIndexNumber||StringYColumn index or ID to set the readonly
readOnlyBooleanY[true, false] Setting of the readonly property
setColumnVisible( colIndex , colVisibleFlag )
Hides or displays the column.
Parameter
nametyperequireddescription
colIndexNumber||StringYColumn index or ID to set the hidden property
colVisibleFlagBooleanY[true, false] visibility
"true" : Displays the column. "false" : Hides.
setColumnVisibleColumn( gridColumnId , visibleColumnId , visibleColumnFalseValue )
Hides some of the selection item list of the selected GridView column.
When the inputType of the GridView column is "select", "autoComplete", or "checkcombobox".
Same as setVisibleColumn method of Select, AutoComplete, Radio, CheckBox, and CheckComboBox.
(See description of visibleColumn, visibleColumnFalseValue, and setVisibleColumn APIs of corresponding components.)
Parameter
nametyperequireddescription
gridColumnIdNumber||StringYgridView column index or ID.
visibleColumnIdStringYDataList column ID bound with the visibleColumnId. (The column has the value that specifies whether to hide or not.)
visibleColumnFalseValueStringNValue that indicates to hide.
Sample
// When the inputType of the GridView column is "select", "autoComplete", or "checkcombobox". // The Status column is bound with the DataList. The Type column in the DataList contains values that specify whether to hide or not.) // Do the following: gridView1.setColumnVisibleColumn("Status", "Type", false); // Execution Result: // The rows in the DataList of which Type column has “false” value will not be displayed as selection items on the Status column of gridView1.
setColumnWidth( colIndex , size )
Changes the width of the column.
Parameter
nametyperequireddescription
colIndexString||NumberYColumn index or ID to change the width
sizeNumberYWidth of the column to set (in pixels)
setCustomFormatter( colIndex , customFormatter )
Sets the customFormatter setting of the column.
Parameter
nametyperequireddescription
colIndexNumber||StringYColumn Index or ID
customFormatterStringYName of the function to use as the customFormatter
setDataDragDrop( onoff )
Changes the dataDragDrop setting of the Grid.
Parameter
nametyperequireddescription
onoffBooleanY[true,false] Whether to allow dataDragDrop or not.
Sample
gridView1.setDataDragDrop(false); // Set the dataDragDrop as false.
setDataType( colIndex , dataType )
Sets the dataType of the column.
Valid when the dataType is "number", "tenge", "rupee", or "euro". (Options for gridView.column) dataType="text" dataType="number" dataType="float"
Parameter
nametyperequireddescription
colIndexNumber||StringYColumn Index or ID
dataTypeStringYdataType of the column to set
setDisabled( type , rowIndex , colIndex , disableFlag )
Sets the disabled property according to the type.
Parameter
nametyperequireddescription
typeStringY[grid, row, column, cell] Type to set the disabled property
rowIndexNumberYRow index or ID to set the disable property
colIndexNumber||StringYColumn index or ID to set the disabled property
disableFlagBooleanYSetting of the disabled property
Sample
// Name, gender and age are defined on the GridView, and column IDs are name, gender, and age respectively. // Disable the entire GridView. gridView1.setDisabled("grid",true); // Disable the first row of the GridView. gridView1.setDisabled("row",0,true); // Disable the "name" column of the GridView. gridView1.setDisabled("column","name",true); // Disable the "age" column on the first row of the GridView. gridView1.setDisabled("cell",0,"age",true);
setDrillDownDragDrop( value )
Sets drag-n-drop in the drill-down column.
Set dataDragDrop="true" in the GridView which contains drillDown column,
and set in setDrillDownDragDrop function.
Drill-down and drag-n-drop will operate.
Parameter
nametyperequireddescription
valueBooleanYSupports drilldown and drag-and-drop in the GridView including drilldown columns.
Sample
gridView1.setDrillDownDragDrop(true); // Execution Result: Data can be dragged-and-dropped.
setFixedColumn( fixedColNum )
Fixes the column.
Parameter
nametyperequireddescription
fixedColNumNumberYThe number of the columns to fix from the far left. For example, to fix the first column, enter 1.
Sample
// Set the first column vertically. gridView1.setFixedColumn(1); // Set the third column vertically. gridView1.setFixedColumn(3);
setFixedRightColumn( count )
Dynamically sets the number of the columns to set to the right (fixedRightColun). (Related Property) fixedRightColumn (Number of the columns to fix on the right)
Parameter
nametyperequireddescription
countNumberYNumber of the columns to fix from the most right. “2” is to fix two columns.
Sample
// Dynamically fix two most right columns. gridView1.setFixedRightColumn(2); // Unfix the columns. gridView1.setFixedRightColumn(0);
setFocusedCell( rowIndex , colIndex , editMode )
Focuses (or selects) the cell and moves to the cell.
Parameter
nametyperequireddescription
rowIndexNumberYRow index of the cell to move the focus to
colIndexNumber||StringYColumn index or ID of the cell to move the focus to
editModeBooleanY[default:false, true] Enter the editMode.
setFocusedHeaderObj( headerId )
Sets the focus to the header when the inputType is an object such as selectbox or checkbox, not Text.
Parameter
nametyperequireddescription
headerIdStringYHeader ID
setFocusedMultiCell( startRow , startCol , endRow , endCol )
Focuses the cells within the specified rectangular area.
Parameter
nametyperequireddescription
startRowNumberYRow index of the focusing-staring point rowIndex of the upper-left corner of the focusing area
startColNumberYColumn index of the focusing-starting area colIndex of the top-left corner of the focusing area
endRowNumberYRow Index of the focusing-ending point rowIndex of the lower-right corner of the focusing area
endColNumberYColumn index of the focusing-ending point colIndex of the lower-right corner of the focusing area
Sample
gridView1.setFocusedMultiCell(3,2,4,3); // Execution Result: (3,2), (3,3), (4,2), and (4,3) cells will be focused.
setFooterCaption( htmlStr )
Sets the innerHTML for the footer table caption.
Parameter
nametyperequireddescription
htmlStrStringYinnerHTML value for the caption
setFooterData( footerId , data )
Sets the data in the footer when the inputType of the footer is Text.
Parameter
nametyperequireddescription
footerIdNumber||StringYFooter index or id
dataStringYFooter contents
setFooterDisplayFormat( footerId , displayFormat )
Sets the displayFormat of the footer.
Note that the displayFormat depends on the dataType.
Parameter
nametyperequireddescription
footerIdNumber||StringYColumn Index or ID
displayFormatStringYdisplayFormat for the column
setFooterStyle( footerId , style , value )
Sets the style of the footer cell.
Parameter
nametyperequireddescription
footerIdString||NumberYFooter cell ID or index(Set rowNum with "$rowNum", and rowStatus with "$rowStatus".)
styleStringYName of the CSS property
valueStringYValue of the CSS property
setFooterSummary( str )
Sets the summary for the footer table.
Parameter
nametyperequireddescription
strStringYString to be set as the summary
setFooterValue( footerId , data )
Sets the data value in the footer when the inputType of the footer is text.
Parameter
nametyperequireddescription
footerIdString||NumberYFooter id or index
dataStringYFooter contents
setGridHeight( height )
Sets the height of the GridView.
Parameter
nametyperequireddescription
heightNumberYHeight to set (Unit: pixels)
setGridReadOnly( readOnly )
Enables the readOnly for the entire GridView.
Parameter
nametyperequireddescription
readOnlyBooleanY[true, false] Setting of the readOnly property
setGridSize( width , height )
Sets the height and the width of the GridView component.
Parameter
nametyperequireddescription
widthNumberYWidth to set in pixel
heightNumberYHeight to set in pixels
setGridWidth( width )
Sets the width of the GridView.
Parameter
nametyperequireddescription
widthNumberYWidth to set in pixels
setHeaderBackgroundColor( headerId , color )
Sets the background color of the header cell.
Parameter
nametyperequireddescription
headerIdString||NumberYheader cell id or index
colorStringYBackground color
setHeaderClass( headerId , className )
Dynamically applies the user class to the header cell of the Grid.
Parameter
nametyperequireddescription
headerIdNumberYheader cell ID
classNameStringYClass to apply to td
setHeaderColor( headerId , color )
Sets the Text color of the header cell.
Parameter
nametyperequireddescription
headerIdString||NumberYheader cell id or index
colorStringYtext color
setHeaderDisabled( headerId , disabled )
Sets the disabled property or the header.
Parameter
nametyperequireddescription
headerIdNumber||StringYheader index or id
disabledBooleanY[true, false] disabled status of the header
setHeaderHide( hide )
Hides or displays the header.
Parameter
nametyperequireddescription
hideBooleanY[true, false] hidden status of the header
setHeaderNodeSet( headerId , nodeset , label , value )
Valid when the inputType of the header is select. Sets the nodeSet of the list.
Parameter
nametyperequireddescription
headerIdStringYHeader ID
nodesetStringNNode to set. Define the dataList ID following data: prefix.
labelStringNNew label. Column ID of the datalist
valueStringNNew value. Column ID of the dataList
Sample
// A DataList and a GridView are defined as shown below. //DataList - The ID is "dc_gendercode". "disp" column contains the labels and "code" column contains the values. // GridView - The inputType of the header column is "select", and the header ID is "hGender". // Change the selectbox list of the "hGender" header in the GridView. gridView1.setHeaderNodeSet("data:dc_genderCode","disp","code");
setHeaderSortImage( headerId , orderNum , sortOrd )
Sets the sorting image of the header. Data sorting must be made by the sorting method of the Datalist.
Parameter
nametyperequireddescription
headerIdStringYHeader ID
orderNumNumberN[default: -1, 1, 0] Shows the sorting status.
"1" : Sorted in ascending power. "-1" : Sorted in descending power. "0" : Not sorted.
sortOrdNumberN[default:0] Sorting priority in case of multi-sorting. For lower compaitibility. [Default: 0]
setHeaderStyle( headerId , style , value )
Sets the style for the header cell of the corresponding headerId in the GridView.
Parameter
nametyperequireddescription
headerIdString||NumberYHeader cell ID or index (Set rowNum with "$rowNum", and rowStatus with "$rowStatus".)
styleStringYName of the CSS property
valueStringYValue of the CSS property
setHeaderValue( headerId , value , useFormat )
Sets the value formatted by the displayFormat in the header.
The displayed text will be changed in case of inputType="text".
Related Property: displayFormat
Parameter
nametyperequireddescription
headerIdStringYHeader ID
valueStringYHeader value
useFormatBooleanNSets the value formatted by the displayFormat in the header. (Default: false)
setImageSrc( colIndex , src )
Dynamically changes the image when the inputType is textimage.
Parameter
nametyperequireddescription
colIndexNumber||StringYColumn Index or ID
srcStringYImage URL to apply to the column of the specified colIndex
setMaxLength( colIndex , len )
Sets the maxLength of the GridView column.
Parameter
nametyperequireddescription
colIndexNumber||StringYColumn Index or ID
lennumberYmaxLength to apply to the column
Sample
// Example gridView1.setMaxLength("a", 5); // Change maxLength of column "a" into 5.
setNoResultMessage( message )
Sets the message to display when there is no data in the GridView component.
Parameter
nametyperequireddescription
messageStringYMessage to display when there is no data
setNoResultMessageVisible( visible )
Dynamically sets the noResultMessageVisible.
Parameter
nametyperequireddescription
visibleBooleanY[true,false] Value of the noResultMessageVisible
setReadOnly( type , rowIndex , colIndex , readOnlyFlag )
Controls the "readOnly" property.
Parameter
nametyperequireddescription
typeStringY[grid, row, column, cell] Type to set the readOnly property
rowIndexNumberYRow index or ID to set the readOnly property
colIndexNumber||StringYColumn index or ID to set the readonly
readOnlyFlagBooleanY[true, false] readOnly setting
Sample
// Name, gender and age are defined on the GridView, and column IDs are name, gender, and age respectively. // Enable "readOnly" for the entire GridView. gridView1.setReadOnly("grid", true); // Enable "readOnly" for the first row of the entire GridView. gridView1.setReadOnly("row",0,true); // Enable "readOnly" for the "name" column of the entire GridView. gridView1.setReadOnly("column","name",true); // Enable "readOnly" for the "age" column on the first row of the entire GridView. gridView1.setReadOnly("cell",0,"age",true);
setRowBackgroundColor( rowIndex , color )
Sets the background color of the row of the corresponding rowIndex.
Parameter
nametyperequireddescription
rowIndexNumberYRow index
colorStringYBackground color
setRowColor( rowIndex , color )
Sets the Text color of the row of the corresponding rowIndex.
Parameter
nametyperequireddescription
rowIndexNumberYRow index
colorStringYText color
setRowDisabled( rowIndex , disableFlag )
Sets the disabled property of the row of the corresponding rowIndex.
Parameter
nametyperequireddescription
rowIndexNumberYRow index to set the disabled property
disableFlagBooleanY[true, false] disabled status
setRowNumColumnWidth( size )
Changes the width of the rowNum column.
Parameter
nametyperequireddescription
sizeNumberYWidth of the column in pixels
setRowReadOnly( rowIndex , readOnly )
Sets the readOnly property for the row of the corresponding rowIndex.
Parameter
nametyperequireddescription
rowIndexNumberYRow index or ID to set the readOnly property
readOnlyBooleanY[true, false] readOnly setting
setRowStatusColumnWidth( size )
Changes the width of the rowStatus column.
Parameter
nametyperequireddescription
sizeNumberYNew column width in pixels
setRowVisible( rowIndex , flag )
Hides/Unhides certain rows.
Hidden rows can be unhidden by clearRowVisible();. (Related Function) clearRowVisible();
Parameter
nametyperequireddescription
rowIndexNumberYIndex of the row to set the hidden status
flagBooleanYDisplay of the row.
"true" Displays the row. "false" Hides the row.
Sample
// (Example) // Hide the 30th row. gridView1.setRowVisible(30, false);
setScrollLeft( left )
Moves the horizontal scroll as much as specified. (Unit: px)
Parameter
nametyperequireddescription
leftNumberYscrollLeft for the horizontal scrolling.
setScrollTop( top )
Sets the top style of the div that covers the vertical scroll of the GridView same with the specified top style.
Parameter
nametyperequireddescription
topNumberYtop setting in the new style to set
setStartRowNumber( rowIndex )
Sets the index of the starting row displayed on the rowNum column.
Index value. Setting “10” will be starting fro “11” on the screen.
Valid when rowNumVisible="true".
Parameter
nametyperequireddescription
rowIndexNumberYIndex of the starting row
Sample
// The rowNumVisible is "true" in the GridView. gridView1.setStartRowNumber(10); // (Display) The rowNum starts which previously was displayed from 1 will start from 11.
setStyleAll( styleObj )
Sets the GridView style.
Parameter
nametyperequireddescription
styleObjJSONYObject containing detailed style settings
<String:Y> styleObj.styleName Name of the style to set. (Example) "background-color" <String:Y> styleObj.styleValue Style value to set <String:Y> styleObj.type Area to apply the style. ["row", "column", "cell"] <String:N> styleObj.target Target to apply the style. ["fixed", "data", "all"] The default is "all". "fixed" is for the fixed area and "data" is for an unfixed area. <Number:N> styleObj.rowIndex Row index to apply the style. Mandatory when the type is type "row" or "cell". <Number:N> styleObj.colIndex Column index to apply the style. Mandatory when the type is "column" or "cell".
Sample
<w2:gridView id='gridView1' fixedColumn='4'/> There are eight columns. var styleObj = {"styleName" : "background-color", "styleValue" : "red", "type" : "row", "target" : "data", "rowIndex" : 5} gridView1.setStyleAll(styleObj); // Execution Result: On the row (5), unfixed area containing cells of (5,4), (5,5), (5,6) and (5,7) will have a red background color.
setSubtotalVisible( flag )
Hides or unhides the subtotal.
Parameter
nametyperequireddescription
flagBooleanYDisplays the subtotal.
false : Hides the subtotal. true : Hides or unhides the subtotal.
Sample
// Hides the subtotal. gridView1.setSubtotalVisible(false); // Unhides the subtotal. gridView1.setSubtotalVisible(true);
setSummary( str )
Sets the HTML summary property or the GridView component.
Parameter
nametyperequireddescription
strStringYString for the summary property
setTopRowIndex( topRowIndex , noEvent , autoFocus )
Moves the vertical scroll bar in a way that the row of the corresponding topRowIndex is displayed on the first row.
Parameter
nametyperequireddescription
topRowIndexNumberYrowIndex of the top row
noEventBooleanNReturns true in order to avoid onscrollend when the scroll reaches at the end.
autoFocusBooleanNMoves the focus to (0, 0) on the current display after API execution.
setUseFilter( colId , flag )
Dynamically changes the useFilter setting of the specified header in the GridView.
Parameter
nametyperequireddescription
colIdStringYColumn ID (of the header or body)
flagBooleanYBoolean to set the useFilter as true or false.
Return
typedescription
BooleanReturns true if the useFilter property is changed, or returns false.
setUseFilterList( flag )
Dynamically controls the useFilterList setting of the GridView.
Parameter
nametyperequireddescription
flagBooleanYBoolean to set the useFilterList property as true or false.
showChooseOption( colIndex , chooseOption )
Sets the chooseOption of the SelectBox when the inputType of the gridView column is select.
Parameter
nametyperequireddescription
colIndexNumberYgridView column index
chooseOptionBooleanYSetting (true/false)
Sample
gridView1.showChooseOption(1,true);
showCustomFilter2( headerID )
Displays the “Use-defined Filter” popup for the end user.
Parameter
nametyperequireddescription
headerIDStringYHeader ID of the column to apply the user-defined filter
showCustomFilterReset( )
Shows the button to initialize the user-defined filter.
true: Display the initialization button.
false (Default): Not display.
showGroupbyZone( )
Shows the groupbyZone area (which was previously hidden by hideGroupbyZone.)
spanAll( openFlag )
Spans or unspans the entire data of the GridView component when drilling-down is enabled.
Spans the data to the depth if the corresponding parameter is given.
Parameter
nametyperequireddescription
openFlagBoolean||NumberY[true, false] Spanning status. If a number is entered, the data of the correpsonding depth will be spanned.
Sample
gridView1.spanAll(true); // Span all data. gridView1.spanAll(2); // Span all 2-depth data.
toggle( rowIndex )
Enables toggling on the row of the corresponding rowIndex when drilling-down is enabled. (Opened for a closed row, and closed for an opened row.)
Opens the closed rows, and vice versa.
Parameter
nametyperequireddescription
rowIndexNumberYrealRowIndex of the row to toggle