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

Flex components are data driven, so you should modify the data provider of the grid.

Answer 2

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.

Answer 3

@Wade Mueller I'm confused about what is supposed to be someColumnData. Sorry I'm a total newbie to Adobe Flex/Actionscript!

Answer 4

What if you want to edit specific individual cells, eg I want to to keep running totals of some cells in other cells, IE: as a user edits I update whole columns.

Surely their must be a way to walk the array and get Column4.row6 = something.