Which version of Flex are you using? That might be fixed in more recent versions.
Alex Harui Flex SDK Developer Adobe Systems Inc.<http://www.adobe.com/> Blog: http://blogs.adobe.com/aharui From: flexcoders@yahoogroups.com [mailto:flexcod...@yahoogroups.com] On Behalf Of flexcoder2008 Sent: Friday, December 18, 2009 11:02 AM To: flexcoders@yahoogroups.com Subject: [flexcoders] Re: Flex datagrid with Excel-like behaviour Hi Alex, Yes, I am using that to block particular cells from being edited. When I click on a cell, this event fires and I can check the dataProvider to determine if this is a cell that should be non-editable and successfully prevent the cell from being editable by calling event.preventDefault. The problem is if I am in an editable cell and then hit tab. If the next cell should be non-editable, this event fires, and I call event.preventDefault but the cell still becomes editable and the itemEditor displays. This only happens when tabbing to a cell that should be non-editable. It doesn't happen when you click on the cell. --- In flexcoders@yahoogroups.com<mailto:flexcoders%40yahoogroups.com>, Alex Harui <aha...@...> wrote: > > ITEM_EDIT_BEGINNING event can be used to block editing of a cell. > > I have a DataGrid Footer example on my blog. > > Alex Harui > Flex SDK Developer > Adobe Systems Inc.<http://www.adobe.com/> > Blog: http://blogs.adobe.com/aharui > > From: flexcoders@yahoogroups.com<mailto:flexcoders%40yahoogroups.com> > [mailto:flexcoders@yahoogroups.com<mailto:flexcoders%40yahoogroups.com>] On > Behalf Of flexcoder2008 > Sent: Friday, December 18, 2009 9:44 AM > To: flexcoders@yahoogroups.com<mailto:flexcoders%40yahoogroups.com> > Subject: [flexcoders] Flex datagrid with Excel-like behaviour > > > > In my application I am trying to create an Excel-type spreadsheet using a > DataGrid. I need the ability to "lock" certain cells so that they are not > editable. I need to be able to tab between editable cells (this is the > default behaviour) when navigating between cells, but be able to skip over > locked (non-editable) cells. This should work both with Tab and alt-Tab to go > backwards. > > As with a spreadsheet too - I need to be able to total columns. > > I am particularly having trouble getting the tab key functionality working. > > Has anyone else attempted something like this or can they point me in the > direction of an existing component that may have this functionality? > > Thanks >