Recalculate While Editing

In this demo, the DataGrid recalculates summaries when you edit data. To enable this feature, the recalculateWhileEditing option is set to true. You can add, delete, or update rows to change the summaries.

Prev Demo Next Demo

Was this demo helpful?

Thank you!

Send Feedback

Thank you!
We appreciate your feedback.

jQuery

AngularJS

Angular

Vue

React

ASP.NET MVC

ASP.NET Core

Copy to CodeSandBox

Apply

Reset

import React from 'react'; import DataGrid, { Column, Editing, Summary, TotalItem } from 'devextreme-react/data-grid'; import service from './data.js'; class App extends React.Component { constructor(props) { super(props); this.orders = service.getOrders(); } render() { return ( <React.Fragment> <DataGrid id={'gridContainer'} dataSource={this.orders} keyExpr={'ID'} repaintChangesOnly={true} showBorders={true}> <Editing mode={'batch'} allowAdding={true} allowUpdating={true} allowDeleting={true}> </Editing> <Column dataField={'OrderNumber'} width={130} caption={'Invoice Number'} /> <Column dataField={'OrderDate'} dataType={'date'} /> <Column dataField={'Employee'} /> <Column dataField={'CustomerStoreCity'} caption={'City'} /> <Column dataField={'CustomerStoreState'} caption={'State'} /> <Column dataField={'SaleAmount'} alignment={'right'} format={'currency'} editorOptions={{ format: 'currency' }} /> <Summary recalculateWhileEditing={true}> <TotalItem column={'OrderNumber'} summaryType={'count'} /> <TotalItem column={'SaleAmount'} summaryType={'sum'} valueFormat={'currency'} /> </Summary> </DataGrid> </React.Fragment> ); } } export default App;

import React from 'react'; import ReactDOM from 'react-dom'; import App from './App.js'; ReactDOM.render( <App />, document.getElementById('app') );

<!DOCTYPE html> <html> <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=1.0" /> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/18.2.7/css/dx.common.css" /> <link rel="dx-theme" data-theme="generic.light" href="https://cdn3.devexpress.com/jslib/18.2.7/css/dx.light.css" /> <link rel="stylesheet" type ="text/css" href ="styles.css" /> <script src="https://unpkg.com/core-js@2.4.1/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.js'); </script> </head> <body class="dx-viewport"> <div class="demo-container"> <div id="app"></div> </div> </body> </html>

#gridContainer { height: 440px; }

System.config({ transpiler: 'plugin-babel', paths: { 'npm:': 'https://unpkg.com/' }, defaultExtension: 'js', map: { 'react': 'npm:react@16/umd/react.development.js', 'react-dom': 'npm:react-dom@16/umd/react-dom.development.js', 'prop-types': 'npm:prop-types/prop-types.js', 'devextreme': 'npm:devextreme@18.2', 'devextreme-react': 'npm:devextreme-react@18.2', 'jszip': 'npm:jszip@3.1.3/dist/jszip.min.js', 'quill': 'npm:quill@1.3.6/dist/quill.js', // SystemJS plugins 'plugin-babel': 'npm:systemjs-plugin-babel@0/plugin-babel.js', 'systemjs-babel-build': 'npm:systemjs-plugin-babel@0/systemjs-babel-browser.js' }, packages: { 'devextreme': { defaultExtension: 'js' }, 'devextreme-react': { main: 'index.js' } }, babelOptions: { sourceMaps: false, stage0: true, react: true } });