All,
Does anybody know how to better couple the WebCalcManager and ASP.NET data grids, similar to how FarPoint Spread does it?
Currently, we have to load data & formulas from the DB into the Calc Manager and then retrieve the values from the Calc Manger to show them in the WebDataGrid. After a user makes updates, we must get the updated values from the WebDataGrid cell by cell and put them back in the WebCalcManager to allow it to do the calculation. Then, the values have to be moved from the WebCalcManager back to the UI WebDataGrid.
According to your site, "The WebCalcManager™ adds the full power of Microsoft® Excel formula support to ASP.NET controls including data grids..."
Please let me know how better to integrate the WebCalcManager into data grids to allow an experience closer to FarPoint spread.
Thanks,
JM
Hello ,
There are samples about UltraWebCalcManager and UltraWebGrid integration:
http://samples.infragistics.com/2009.2/WebFeatureBrowser/contents.aspx?showCode=true&t=WebCalcManager/GridSummaries/GridSummaries.aspx~srcview.aspx?path=../WebFeatureBrowserVB/WebCalcManager/GridSummaries/GridSummaries.src~srcview.aspx?path=WebCalcManager/GridSummaries/GridSummaries.src
http://samples.infragistics.com/2009.2/WebFeatureBrowser/contents.aspx?showCode=true&t=WebCalcManager/DentalProducts/DentalProducts.aspx~srcview.aspx?path=../WebFeatureBrowserVB/WebCalcManager/DentalProducts/DentalProducts.src~srcview.aspx?path=WebCalcManager/DentalProducts/DentalProducts.src
You can read more about how to implement this in the online documentation:
http://help.infragistics.com/Help/NetAdvantage/ASPNET/2010.1/CLR3.5/html/WebCalcManager_Creating_Running_Totals_in_WebGrid.html
Regarding the WebDataGrid this calculating /summary /.. functionality will be implemented in the 2010.2 version.
It is not recommended to mess Aikido with the ASP controls.
The description which you have provided is the way to make WebDataGrid and WebCalcManager work together.
Regarding the export and excel formula I can recommend you to read the following :
http://help.infragistics.com/NetAdvantage/ASPNET/2010.1/CLR3.5/?page=ExcelEngine_Calculating_Order_Totals.html
http://help.infragistics.com/NetAdvantage/ASPNET/2010.1/CLR3.5/?page=ExcelEngine_Getting_the_value_of_a_Formula_from_an_Excel_File.html
http://help.infragistics.com/NetAdvantage/ASPNET/2010.1/CLR3.5/?page=Web_Use_Formulas_in_Excel_Worksheets_Whats_New_20073.html
Let me know if you need more assistance regarding this.
Literally every link provided is broken...