C1 Community

I have a problem which my users find extremely annoying with the subtotal feature of C1FlexGrid. I have a fairly large grid that periodically receives updates from the network where each message constitute a row. I have followed the example and samples way of providing this subtotaling feature however as we need if the grid changes (e.g. add date, re-sort, move columns) the subtotal tree will cease to exist and thus must be re-initialized. Thus re-initing the subtotal in the AfterDataRefresh does the job, however, this causes the user's expand/collapse nodes to be lost because a clearing of the subtotal, re-sorting, re-subtotal is unable to persist which nodes were expanded or collapsed. I've even tried to create an invisible columns to hold this information, but it will also go away along with the tree outline.

Do you have any suggestions? Thanks. Running outta time and ideas

I have attached a sample in this msg

1 - click on sort

2- click on subtotal

3 - click on Add

u'll find an added row under Total for Buchanan which doesn't quite make sense, it is highlighted in red, BUT if u do this, restart app

1- click on sort

2 - click on subtotal

3 - click on Clear

4 - click on Add

5 - Click on sort

6 - click on subtotal

u'd find that it adds everything ok and there is a subtotal created for Total for Ban. Problem with doing this i cannot persist the nodes that were expanded or collapsed by the user. PLEASE HELP!!!!!!!!!!