Once last question...
I am editing directly on the datagrid....I need the changes to reflect
immediately..whats happens now is that the change is reflected only
when I click on another column...
On Sep 11, 8:44 am, jeroen <[EMAIL PROTECTED]> wrote:
> you guys are awesome thanks for all your help
>
> On Sep 10, 8:52 pm, Aasim <[EMAIL PROTECTED]> wrote:
>
> > You can write a labelfunction in this way
>
> > private function
> > labelFunction(value:object,column:dataGridColumn):String{
> > //value would contain data for the entire row
> > //var 1 and var2 would be your properties on the arraycollection of
> > the datagrid
>
> > return value.var1 + ' -- ' + value.var2;
>
> > //instead of appending string...you can also do multiplication,other
> > math functions on the values and return the value as a string
>
> > }
>
> > Just assign the labelFunction name to the labelfunction property on
> > the datagird
>
> > -Aasim
>
> > On Sep 10, 3:47 pm, jeroen <[EMAIL PROTECTED]> wrote:
>
> > > Thanks guys for the responses....are they any samples of a
> > > labelfunctin?
>
> > > On Sep 10, 12:00 pm, Aasim <[EMAIL PROTECTED]> wrote:
>
> > > > I guess using a labelFunction would be easier approach, also it would
> > > > be more dynamic approach.
> > > > Say if the data is changing regularly you do not have to run the
> > > > entire loop again for computation.
>
> > > > -Aasim
>
> > > > On Sep 10, 12:50 pm, "Venkat Viswanathan" <[EMAIL PROTECTED]>
> > > > wrote:
>
> > > > > Hi,
>
> > > > > See this code. This is a working sample of how you can use
> > > > > calculations:
>
> > > > > <?xml version="1.0" encoding="utf-8"?>
> > > > > <mx:Application xmlns:mx="http://www.adobe.com/2006/mxml"
> > > > > layout="vertical"
> > > > > creationComplete="init()">
> > > > > <mx:Script>
> > > > > <![CDATA[
> > > > > import mx.collections.ArrayCollection;
> > > > > [Bindable] private var marksCollection:ArrayCollection =
> > > > > new
> > > > > ArrayCollection();
>
> > > > > private function init():void{
>
> > > > > marksCollection.addItem({"Maths":84,"Science":90,"English":75});
>
> > > > > marksCollection.addItem({"Maths":82,"Science":89,"English":71});
>
> > > > > marksCollection.addItem({"Maths":78,"Science":80,"English":65});
>
> > > > > marksCollection.addItem({"Maths":65,"Science":60,"English":52});
>
> > > > > marksCollection.addItem({"Maths":98,"Science":99,"English":91});
>
> > > > > marksCollection.addItem({"Maths":90,"Science":92,"English":87});
> > > > > }
>
> > > > > private function calc():void{
> > > > > for each (var item:Object in marksCollection){
> > > > > var total:Number = item.Maths + item.Science +
> > > > > item.English;
> > > > > var perc:Number = Math.round((total/300)*100);
> > > > > item.Total = total;
> > > > > item.Percentage = perc + "%";
> > > > > }
> > > > > marksCollection.refresh();
> > > > > }
> > > > > ]]>
> > > > > </mx:Script>
> > > > > <mx:Button label="Calculate" click="calc()"/>
> > > > > <mx:DataGrid width="100%" height="100%"
> > > > > dataProvider="{marksCollection}">
> > > > > <mx:columns>
> > > > > <mx:DataGridColumn dataField="Maths" headerText="Maths"/>
> > > > > <mx:DataGridColumn dataField="Science"
> > > > > headerText="Science"/>
> > > > > <mx:DataGridColumn dataField="English"
> > > > > headerText="English"/>
> > > > > <mx:DataGridColumn dataField="Total" headerText="Total"/>
> > > > > <mx:DataGridColumn dataField="Percentage"
> > > > > headerText="Percentage"/>
> > > > > </mx:columns>
> > > > > </mx:DataGrid>
>
> > > > > </mx:Application>
>
> > > > > Regards,
> > > > > Venkatwww.venkatv.com
>
> > > > > On Wed, Sep 10, 2008 at 12:58 PM, jeroen <[EMAIL PROTECTED]> wrote:
>
> > > > > > Thanks for the reply....appreciate it
>
> > > > > > Do you a sample array collection for loop....?
>
> > > > > > On Sep 10, 9:18 am, "Venkat Viswanathan" <[EMAIL PROTECTED]>
> > > > > > wrote:
> > > > > > > Hi,
>
> > > > > > > The best way to do this is to loop through the arrayCollection and
> > > > > > perform
> > > > > > > the action required for each of the items in every row. So
> > > > > > > probably you
> > > > > > can
> > > > > > > run a "for each" loop and then do the calculation inside the
> > > > > > > loop. And
> > > > > > after
> > > > > > > completing the loop, do arrayCollection.refresh().
>
> > > > > > > Let me know if this wont work out in your case.
>
> > > > > > > Regards,
> > > > > > > Venkat
>
> > > > > > > On Wed, Sep 10, 2008 at 12:38 PM, jeroen <[EMAIL PROTECTED]>
> > > > > > > wrote:
>
> > > > > > > > On Sep 10, 8:45 am, jeroen <[EMAIL PROTECTED]> wrote:
> > > > > > > > > Hi Guys and Girls
>
> > > > > > > > > Maybe someone can help
>
> > > > > > > > > I have a advanced datagrid lets say with one row with 4
> > > > > > > > > columns,
> > > > > > > > > column 3 data is determined by column 1 data mulplied by 30
> > > > > > > > > for
> > > > > > > > > example....now is easy to do with one row but I have 40 odd
> > > > > > > > > rows of
> > > > > > > > > data, is there a easy way to loop through the data and
> > > > > > > > > calculate this
> > > > > > > > > values on the fly or should each cell be calculated seperatly
>
> > > > > > > > > Thanks
>
> > > > > > > > Here is a sample with calculations...
>
> > > > > > > >http://spreadsheets.google.com/ccc?key=pFk_smnTF1XI7Z5URAX3gAw&hl=en
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Flex
India Community" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/flex_india?hl=en
-~----------~----~----~----~------~----~------~--~---