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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Is there a simple way to add selected cells

Thread ID:





39348 Jan 5,2006 03:55 AM UTC Jan 10,2006 04:58 PM UTC WinForms 7
Tags: GridControl
Asked On January 5, 2006 03:55 AM UTC

Like Excel, I want to have a status bar that shows accumulates the total of any cells with numbers selected. Is there a sample or suggestion how to do this? Thanks

Administrator [Syncfusion]
Replied On January 5, 2006 03:05 PM UTC

Hi, You can use SelectionsChanged event and the formula engine to show the accumulate total of any selected cell in a status bar. Here is a sample. Regards, Calvin.


Replied On January 6, 2006 04:10 AM UTC

Thank you.

Replied On January 6, 2006 04:10 AM UTC

Thank you.

Replied On January 6, 2006 04:51 AM UTC

Actually, this has a problems. First, if you click on the cells with ctrl + clcik and have non-contigous selection, it doesn''t work. I tried getSelectedCells but it returns a string like "A3:A6;A9" which can''t be used by the formula engine. How do I have the GridRangeInfoList parsed properly so I can either manually count them ot have the engine do it?

Administrator [Syncfusion]
Replied On January 6, 2006 11:17 AM UTC

Hi, Here is a sample which parses the GridRangeInfoList and show the accumulate total of any selected cell in a status bar. Regards, Calvin.


Replied On January 6, 2006 06:02 PM UTC

Thanks. That got me started. BTW, One interesting bug - the grid doesn''t distinguish between what is being selected versus unselected veesus selected more than once. So if you click on one cell, then crtl+click click anotehr then crtl+click thr original cell, it will add them to the total more than once.

Administrator [Syncfusion]
Replied On January 10, 2006 04:58 PM UTC

Hi, Sorry for the inconvenient caused and the delay in replying. Here is an workaround which uses a custom MouseController to deselect a cell. Regards, Calvin.



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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon 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.Close Icon