Showing totals for each subrow category in the first row and then move it to another table

[abab...@gmail.com]

Hello,

I'm trying to find out how to create a table that its first row contains the totals of its corresponding column, and the totals of each subcategory row as you can see here

http://jsfiddle.net/SBRvZ/21/

Then move it will move each total column to the upper table, I've been able to do the second thing but not the first one

I don't know if this it's possible to do this on Handsontable 0.9.19

Could someone help me??

[Paweł Smoleński]

Check out this topic. It seems to address a very similar problem:
https://groups.google.com/forum/#!searchin/handsontable/total/handsontable/eacwCpPA4cA/oH-dqunrNeUJ

Regards
Pawel


W dniu 06.11.2013 18:35, abab...@gmail.com pisze:

[abab...@gmail.com]

El jueves, 7 de noviembre de 2013 09:13:44 UTC+1, Paweł Smoleński escribió:
> Check out this topic. It seems to address a very similar problem:
>
> https://groups.google.com/forum/#!searchin/handsontable/total/handsontable/eacwCpPA4cA/oH-dqunrNeUJ
>
>
>
> Regards
>
> Pawel
>
>
>
>
>

> W dniu 06.11.2013 18:35, Andres pisze:

>
> > Hello,
>
> >
>
> > I'm trying to find out how to create a table that its first row contains the totals of its corresponding column, and the totals of each subcategory row as you can see here
>
> >
>
> > http://jsfiddle.net/SBRvZ/21/
>
> >
>
> > Then move it will move each total column to the upper table, I've been able to do the second thing but not the first one
>
> >
>
> > I don't know if this it's possible to do this on Handsontable 0.9.19
>
> >
>
> > Could someone help me??
>
> >

Yes, indeed it's similar but no the same, I can't work with spare rows and the first column contains text, not numbers, that's why I can not use that similar solution.

I would be great that Handsontable group could add somekind of functionality in which you could set a cells that autocalculate a range of rows or columns based on its changes.

Thanks for the answer anyway

[Paweł Smoleński]

So add an empty row at the beginning of your data source and set
renderers, that sum values in corresponding column, for each cell in
this row, except for the first one.

Regards
Pawel

W dniu 08.11.2013 08:39, abab...@gmail.com pisze:

[abab...@gmail.com]

El viernes, 8 de noviembre de 2013 09:20:57 UTC+1, Paweł Smoleński escribió:
> So add an empty row at the beginning of your data source and set
>
> renderers, that sum values in corresponding column, for each cell in
>
> this row, except for the first one.
>
>
>
> Regards
>
> Pawel
>
>
>

> W dniu 08.11.2013 08:39, andres pisze:

>
> > El jueves, 7 de noviembre de 2013 09:13:44 UTC+1, Paweł Smoleński escribió:
>
> >> Check out this topic. It seems to address a very similar problem:
>
> >>
>
> >> https://groups.google.com/forum/#!searchin/handsontable/total/handsontable/eacwCpPA4cA/oH-dqunrNeUJ
>
> >>
>
> >>
>
> >>
>
> >> Regards
>
> >>
>
> >> Pawel
>
> >>
>
> >>
>
> >>
>
> >>
>
> >>
>
> >> W dniu 06.11.2013 18:35, Andres pisze:
>
> >>
>
> >>> Hello,
>
> >>> I'm trying to find out how to create a table that its first row contains the totals of its corresponding column, and the totals of each subcategory row as you can see here
>
> >>> http://jsfiddle.net/SBRvZ/21/
>
> >>> Then move it will move each total column to the upper table, I've been able to do the second thing but not the first one
>
> >>> I don't know if this it's possible to do this on Handsontable 0.9.19
>
> >>> Could someone help me??
>
> > Yes, indeed it's similar but no the same, I can't work with spare rows and the first column contains text, not numbers, that's why I can not use that similar solution.
>
> >
>
> > I would be great that Handsontable group could add somekind of functionality in which you could set a cells that autocalculate a range of rows or columns based on its changes.
>
> >
>
> > Thanks for the answer anyway
>
> >

What happen if I have to obtain that row first (on load) from database? I need that row to exist when I do this operation :S