We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Accessing the Grid Grouping Summary Cells.

Thread ID:

Created:

Updated:

Platform:

Replies:

131785 Nov 6,2009 03:55 PM Jul 27,2017 12:12 PM JavaScript 5
loading
Tags: ejGrid
Tobias O''Leary
Asked On November 6, 2009 03:55 PM

Hi Syncfusion,

Is there a way accessing the summary cells directly to change their values and avoid using the grid engines way of creating summaries, where an object is created for each row and then combined?

I've seen significant speed improvements if I don't use summaries, so if I can get our database to calculate the summaries and fill the cell in directly it would make the display of the grid much faster.

I would like to use the group level and category text and summary descriptor to access the summary cell.

-Tobias

Rajadurai C [Syncfusion]
Replied On November 9, 2009 07:18 AM

Hi Tobias,

Thanks for your interest in Syncfusion Products.

Using summaries in gridgroupingcontrol, would not have any peformance hit. If you would like to access the summary cell or set value to the summary cell, you can handle the QueryCellStyleInfo event.

if (e.TableCellIdentity.TableCellType == GridTableCellType.SummaryFieldCell)
{
// This line will display/extract the value from the matched cell
MessageBox.Show(e.Style.CellValue.ToString());

// This line will allow the setting of new value for the matched cell
e.Style.CellValue = "200";
}

In this event, you can access the specific element and handle the necessary modifications in it accordingly.

Regards,
Rajadurai

Tobias O''Leary
Replied On November 11, 2009 07:36 AM

Thanks for the reply. I'll try that out.

Rajadurai C [Syncfusion]
Replied On November 11, 2009 10:34 PM

Hi Tobias,

Thanks for your update.

Regards,
Rajadurai

Hussain
Replied On July 26, 2017 08:08 AM

is it possible to do the same thing with ejgrid for javascript/angularjs


Thavasianand Sankaranarayanan [Syncfusion]
Replied On July 27, 2017 12:12 PM

Hi Tobias, 

We have analyzed your query and we suspect that you want to use custom summary in ejGrid control. 

Refer the below code example. 


    <div id="Grid" ej-grid e-datasource="data" e-allowpaging="true" e-showsummary="true" e-summaryrows="summary"> 
        <div e-columns> 
         ---------- 
           <div e-column e-field="Freight" e-headertext="Freight" e-textalign="left" e-format="{0:c2}" e-width="90"></div> 
            ----------                     
 
   </div> 
    <script> 
        angular.module('listCtrl', ['ejangular']) 
        .controller('PhoneListCtrl', function ($scope) { 
            $scope.data = window.gridData; 
            $scope.summary = [{ 
                title: "Currency", 
                summaryColumns: [{ 
                    summaryType: ej.Grid.SummaryType.Custom, 
 
                    customSummaryValue: currency, 
 
                    displayColumn: "Freight", 
                    format: "{0:c2}" 
                }] 
            }] 
        }); 
        function currency() { 
            //to get grid instance 
            var gridObj = $("#Grid").ejGrid("instance"); 
            //ej.sum is aggreagte to add datas of freight from datasource 
             
            return ej.sum(gridObj.model.dataSource(), "Freight"); 
        } 
    </script> 


We have prepared a JsPlayground sample in the following link. 


Refer the help documentation. 


If we misunderstood your query then please get back to us. 

Regards, 
Thavasianand S. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;