Is there a simple way to add selected cells

[va]

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]

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

[va]

Thank you.

[va]

Thank you.

[va]

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]

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

[va]

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]

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