DevExtreme v24.1 is now available.

Explore our newest features/capabilities and share your thoughts with us.

Your search did not match any results.

Vue Data Grid - Custom Editors

Different editors can be used to edit cell values in grid columns. The default editor depends on the column configuration. The dependency is illustrated in the editorOptions object's description (this object is used to customize the default editor). In this demo, the SelectBox component is the Status column's default editor, and the editorOptions object is used to specify the component's itemTemplate.

Backend API
<template> <DxDataGrid :data-source="tasks" :show-borders="true" @row-inserted="onRowInserted" > <DxPaging :enabled="true" :page-size="15" /> <DxHeaderFilter :visible="true"/> <DxSearchPanel :visible="true"/> <DxEditing :allow-updating="true" :allow-adding="true" mode="cell" /> <DxColumn :width="150" :allow-sorting="false" data-field="Owner" edit-cell-template="dropDownBoxEditor" > <DxLookup :data-source="employees" display-expr="FullName" value-expr="ID" /> <DxRequiredRule/> </DxColumn> <DxColumn :width="200" :allow-sorting="false" :cell-template="cellTemplate" :calculate-filter-expression="calculateFilterExpression" data-field="AssignedEmployee" caption="Assignees" edit-cell-template="tagBoxEditor" > <DxLookup :data-source="employees" value-expr="ID" display-expr="FullName" /> <DxRequiredRule/> </DxColumn> <DxColumn data-field="Subject"> <DxRequiredRule/> </DxColumn> <DxColumn :editor-options="{ itemTemplate: 'statusTemplate' }" data-field="Status" width="200" > <DxLookup :data-source="statuses" display-expr="name" value-expr="id" /> <DxRequiredRule/> </DxColumn> <template #statusTemplate="{ data }"> <span v-if="data == null">(All)</span> <div v-else> <img :src="'../../../../images/icons/status-' + data.id + '.svg'" class="status-icon middle" > <span class="middle">{{ data.name }}</span> </div> </template> <template #dropDownBoxEditor="{ data: cellInfo }"> <EmployeeDropDownBoxComponent :value="cellInfo.value" :on-value-changed="cellInfo.setValue" :data-source="employees" /> </template> <template #tagBoxEditor="{ data: cellInfo }"> <EmployeeTagBoxComponent :cell-info="cellInfo" :data-source="employees" :data-grid-component="cellInfo.component" /> </template> </DxDataGrid> </template> <script setup lang="ts"> import { DxDataGrid, DxPaging, DxHeaderFilter, DxSearchPanel, DxEditing, DxColumn, DxLookup, DxRequiredRule, DxDataGridTypes, } from 'devextreme-vue/data-grid'; import { createStore } from 'devextreme-aspnet-data-nojquery'; import EmployeeDropDownBoxComponent from './EmployeeDropDownBoxComponent.vue'; import EmployeeTagBoxComponent from './EmployeeTagBoxComponent.vue'; import { statuses, Task } from './data.ts'; const url = 'https://js.devexpress.com/Demos/Mvc/api/CustomEditors'; const employees = createStore({ key: 'ID', loadUrl: `${url}/Employees`, onBeforeSend(method, ajaxOptions) { ajaxOptions.xhrFields = { withCredentials: true }; }, }); const tasks = createStore({ key: 'ID', loadUrl: `${url}/Tasks`, updateUrl: `${url}/UpdateTask`, insertUrl: `${url}/InsertTask`, onBeforeSend(method, ajaxOptions) { ajaxOptions.xhrFields = { withCredentials: true }; }, }); const cellTemplate = (container: HTMLElement, options: DxDataGridTypes.ColumnCellTemplateData) => { const noBreakSpace = '\u00A0'; const assignees = (options.value || []).map( (assigneeId: number) => options.column!.lookup!.calculateCellValue!(assigneeId), ); const text = assignees.join(', '); container.textContent = text || noBreakSpace; container.title = text; }; const onRowInserted = (e: DxDataGridTypes.RowInsertedEvent) => { e.component.navigateToRow(e.key); }; function calculateFilterExpression( column: DxDataGridTypes.Column, filterValue: any, selectedFilterOperations: string | null, target: string, ) { if (target === 'search' && typeof filterValue === 'string') { return [column.dataField, 'contains', filterValue]; } return (rowData: Task) => (rowData.AssignedEmployee || []).includes(filterValue); } </script> <style> .status-icon { height: 16px; width: 16px; display: inline-block; margin-right: 8px; } .middle { vertical-align: middle; } </style>
<template> <DxDropDownBox ref="dropDownBoxRef" :drop-down-options="dropDownOptions" :input-attr="{ 'aria-label': 'Owner' }" :data-source="dataSource" v-model:value="currentValue" display-expr="FullName" value-expr="ID" content-template="contentTemplate" > <template #contentTemplate="{}"> <DxDataGrid :data-source="dataSource" :remote-operations="true" :height="250" :selected-row-keys="[currentValue]" :hover-state-enabled="true" :on-selection-changed="onSelectionChanged" :focused-row-enabled="true" :focused-row-key="currentValue" > <DxColumn data-field="FullName"/> <DxColumn data-field="Title"/> <DxColumn data-field="Department"/> <DxPaging :enabled="true" :page-size="10" /> <DxScrolling mode="virtual"/> <DxSelection mode="single"/> </DxDataGrid> </template> </DxDropDownBox> </template> <script setup lang="ts"> import { ref } from 'vue'; import { DxDataGrid, DxPaging, DxSelection, DxScrolling, DxColumn, DxDataGridTypes, } from 'devextreme-vue/data-grid'; import DxDropDownBox, { DxDropDownBoxTypes } from 'devextreme-vue/drop-down-box'; import CustomStore from 'devextreme/data/custom_store'; const props = defineProps<{ value: number, // eslint-disable-next-line no-unused-vars onValueChanged(value: number): void, dataSource: CustomStore, }>(); const currentValue = ref(props.value); const dropDownBoxRef = ref<DxDropDownBox | null>(null); const dropDownOptions: DxDropDownBoxTypes.Properties['dropDownOptions'] = { width: 500 }; const onSelectionChanged = (e: DxDataGridTypes.SelectionChangedEvent) => { currentValue.value = e.selectedRowKeys[0]; props.onValueChanged(currentValue.value); if (e.selectedRowKeys.length > 0) { dropDownBoxRef.value!.instance!.close(); } }; </script>
<template> <DxTagBox :data-source="dataSource" v-model:value="currentValue" :show-selection-controls="true" :input-attr="{ 'aria-label': 'Name' }" :max-displayed-tags="3" :show-multi-tag-only="false" :on-value-changed="onValueChanged" :on-selection-changed="onSelectionChanged" :search-enabled="true" value-expr="ID" display-expr="FullName" apply-value-mode="useButtons" /> </template> <script setup lang="ts"> import { ref } from 'vue'; import { DxDataGrid, DxDataGridTypes } from 'devextreme-vue/data-grid'; import DxTagBox, { DxTagBoxTypes } from 'devextreme-vue/tag-box'; import CustomStore from 'devextreme/data/custom_store'; const props = defineProps<{ cellInfo: DxDataGridTypes.ColumnEditCellTemplateData, dataSource: CustomStore, dataGridComponent: DxDataGrid['instance'], }>(); const currentValue = ref(props.cellInfo.value); const onSelectionChanged = () => { props.dataGridComponent.updateDimensions(); }; const onValueChanged = (e: DxTagBoxTypes.ValueChangedEvent) => { props.cellInfo.setValue(e.value); }; </script>
window.exports = window.exports || {}; window.config = { transpiler: 'plugin-babel', meta: { '*.vue': { loader: 'vue-loader', }, '*.ts': { loader: 'demo-ts-loader', }, '*.svg': { loader: 'svg-loader', }, 'devextreme/time_zone_utils.js': { 'esModule': true, }, 'devextreme/localization.js': { 'esModule': true, }, 'devextreme/viz/palette.js': { 'esModule': true, }, 'devextreme-aspnet-data-nojquery': { 'esModule': true, }, }, paths: { 'root:': '../../../../', 'npm:': 'https://unpkg.com/', }, map: { 'vue': 'npm:vue@3.2.47/dist/vue.esm-browser.js', 'vue-loader': 'npm:dx-systemjs-vue-browser@1.1.1/index.js', 'demo-ts-loader': 'root:utils/demo-ts-loader.js', 'svg-loader': 'root:utils/svg-loader.js', 'devextreme-aspnet-data-nojquery': 'npm:devextreme-aspnet-data-nojquery@3.0.0/index.js', 'mitt': 'npm:mitt/dist/mitt.umd.js', 'rrule': 'npm:rrule@2.6.4/dist/es5/rrule.js', 'luxon': 'npm:luxon@1.28.1/build/global/luxon.min.js', 'es6-object-assign': 'npm:es6-object-assign@1.1.0', 'devextreme': 'npm:devextreme@24.1.6/cjs', 'devextreme-vue': 'npm:devextreme-vue@24.1.6/cjs', 'jszip': 'npm:jszip@3.10.1/dist/jszip.min.js', 'devextreme-quill': 'npm:devextreme-quill@1.7.1/dist/dx-quill.min.js', 'devexpress-diagram': 'npm:devexpress-diagram@2.2.11/dist/dx-diagram.js', 'devexpress-gantt': 'npm:devexpress-gantt@4.1.56/dist/dx-gantt.js', '@devextreme/runtime': 'npm:@devextreme/runtime@3.0.13', 'inferno': 'npm:inferno@7.4.11/dist/inferno.min.js', 'inferno-compat': 'npm:inferno-compat/dist/inferno-compat.min.js', 'inferno-create-element': 'npm:inferno-create-element@7.4.11/dist/inferno-create-element.min.js', 'inferno-dom': 'npm:inferno-dom/dist/inferno-dom.min.js', 'inferno-hydrate': 'npm:inferno-hydrate@7.4.11/dist/inferno-hydrate.min.js', 'inferno-clone-vnode': 'npm:inferno-clone-vnode/dist/inferno-clone-vnode.min.js', 'inferno-create-class': 'npm:inferno-create-class/dist/inferno-create-class.min.js', 'inferno-extras': 'npm:inferno-extras/dist/inferno-extras.min.js', 'plugin-babel': 'npm:systemjs-plugin-babel@0.0.25/plugin-babel.js', 'systemjs-babel-build': 'npm:systemjs-plugin-babel@0.0.25/systemjs-babel-browser.js', // Prettier 'prettier/standalone': 'npm:prettier@2.8.8/standalone.js', 'prettier/parser-html': 'npm:prettier@2.8.8/parser-html.js', }, packages: { 'devextreme-vue': { main: 'index.js', }, 'devextreme': { defaultExtension: 'js', }, 'devextreme/events/utils': { main: 'index', }, 'devextreme/events': { main: 'index', }, 'es6-object-assign': { main: './index.js', defaultExtension: 'js', }, }, packageConfigPaths: [ 'npm:@devextreme/*/package.json', 'npm:@devextreme/runtime@3.0.13/inferno/package.json', ], babelOptions: { sourceMaps: false, stage0: true, }, }; System.config(window.config);
export type Task = { ID: number; Subject: string; Status: number; Owner: number; AssignedEmployee: number[]; OrderIndex: number; Priority: number; }; export type Employee = { ID: number; FullName: string; Department: string; Title: string; }; export type Status = { id: number; name: string; }; export const statuses: Status[] = [{ id: 1, name: 'Not Started', }, { id: 2, name: 'In Progress', }, { id: 3, name: 'Deferred', }, { id: 4, name: 'Need Assistance', }, { id: 5, name: 'Completed', }];
import { createApp } from 'vue'; import App from './App.vue'; createApp(App).mount('#app');
<!DOCTYPE html> <html lang="en"> <head> <title>DevExtreme Demo</title> <meta http-equiv="X-UA-Compatible" content="IE=edge" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=5.0" /> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/24.1.6/css/dx.light.css" /> <script type="module"> import * as vueCompilerSFC from "https://unpkg.com/@vue/compiler-sfc@3.4.16/dist/compiler-sfc.esm-browser.js"; window.vueCompilerSFC = vueCompilerSFC; </script> <script src="https://unpkg.com/typescript@4.9.5/lib/typescript.js"></script> <script src="https://unpkg.com/core-js@2.6.12/client/shim.min.js"></script> <script src="https://unpkg.com/systemjs@0.21.3/dist/system.js"></script> <script type="text/javascript" src="config.js"></script> <script type="text/javascript"> System.import("./index.ts"); </script> </head> <body class="dx-viewport"> <div class="demo-container"> <div id="app" /> </div> </body> </html>

If the default editor is unsuitable, you can replace it with a custom editor. For this, implement an editCellTemplate that allows you to configure the replacement editor's appearance and behavior. To change the cell value and, optionally, the displayed value after the editor's value is changed, use the setValue() method of the editCellTemplate. In this demo, the default editors in the Owner and Assignees columns are replaced with the DropDownBox and TagBox components.