Is there a simple way to add selected cells

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

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.

Forum_39348.zip

Thank you.

Thank you.

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?

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

Forum_393480.zip

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.

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.

Forum_39348_WA4.zip