Flex 4 How do I access a specific cell by index?

Question

I would like to edit a cell by the row and column indexes so essentially do the following:

advDataGrid[2][3] = "Dogs"

so that I am setting the data grid row 2 and column 3 to Dogs. I cannot for the life of me figure out how to do this!

Side note: I need this because I am trying to allow the user to copy a section of an excel file to a section of an AdvancedDataGrid like Google Docs does. I am using this idea to do it: http://mannu.livejournal.com/348299.html

Thanks! Any help will be greatly appreciated!

Answer 1

In general you want to operate on the dataProvider rather than the presentation (AdvancedDataGrid). So in your case, I would get the item associated with the specified row from your dataProvider and modify whichever element is specified to "Dogs". So something like this: adg.dataProvider[row].someColumnData = "Dogs"

EDIT: "someColumnData" refers to whatever property you have set for the column to display. So when you defined your AdvancedDataGrid's columns, you set the 4th column to use the "someColumnData" property of the items in your dataProvider, and you want to change the value in the 4th column, then you'd set it as described above. Hope that clarifies things.