Calculating CellValues of Selected Row and Column | Infragistics Forums

State See Verified Answer
Replies 5 replies
Subscribers 5 subscribers
Views 1009378 views
Users 0 members are here

703

Calculating CellValues of Selected Row and Column

Amit Ranjan posted over 14 years ago

I have multiple columns in my grid, in which there are 7 columns which are editable. These are for days from Sun-Sat. All fields are double type. I am having a footer in which i am displaying total of a day columnwise. What i am doing right now is on CellExitEdit event of grid, i want to calculate the value of the column and row. But i am not able to get the actual logic (actually not able to determine current cell value and current column ) , how to do it. Now this total will be displayed in the footer of there respective column. But here too unable to display the text in footer. Footer Template is is attached text file. Attached is my XAML in xaml.txt For Setting up the text to footer i am using dgTimeSheet.Columns.DataColumn("FriHrs").FooterText = "abc" I am using VB as a language

40030

Offline Stephen Zaharuk posted over 14 years ago in reply to Priyanka

Hi,

In Cell ExitingEditMode, just look at e.Cell.Row.Data.

You can then cast the Data property as the object your row represents, and do whatever calculations you need based on your properties.

-SteveZ
Cancel
Reply

Verify Answer

Cancel
490

Priyanka posted over 14 years ago in reply to Amit Ranjan

Hi ,

can you please send an example of Calculating CellValues of Selected Row.

I want to do row wise calculation after exiting a cell.(ie)CellExitingEditMode

I have populated the grid dynamically using reflection.

I am not able to find out other cell values of the selected row when I edit a single cell value of the selected row in CellExitingEditMode function.

Thanks
Cancel
Reply

Verify Answer

Cancel
703

Amit Ranjan posted over 14 years ago in reply to Stephen Zaharuk

I know about the column summaries but the user wants on change of the value , the change in footer will be automatically updated. Also i am having a row wise calculation , Anyways all issues solved. Thanks
Cancel
Reply

Verify Answer

Cancel
40030

Verified Answer
Offline Stephen Zaharuk posted over 14 years ago

Hi Amit,

In 9.2 we introduced Column Summaries. That does exactly this. You should take a look at this feature.

Hope this helps.

-SteveZ
Cancel
Reply

Reject Answer

Cancel
703

Verified Answer
Amit Ranjan posted over 14 years ago

Also there is one more problem whenever i post Codes in this forum, after posting they become invisible.
Cancel
Reply

Reject Answer

Cancel