The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
We recently purchased your UI suite and I''d like some direction, please.
Scenario:
We''d like to be able to load a GDBG from a database via a DataTable and also have one or multiple unbound formula columns whose computed values we''d like stored back in the DataTable as well as displayed in the grid alongside the bound columns.
We''d also like the ability to export this grid to an Excel file (along with formulas/computed values) to allow a user to verify the formulas we''re using.
How might I accomplish this scenario? I''ve become somewhat familiar with your object model and we have full source for your components. Thanks.
ADAdministrator Syncfusion Team August 23, 2005 10:02 PM UTC
The simplest way to do this is to add Expression columns to your DataTable if they will handle the type of formulas you want to allow your user to enter.
If you need to use Excel-Like formulas (where cells in one row can refer to cells in another row) as opposed to Expression type formula where the formula is restricted to use values in the same row), then you will have to do additional work if you want to use such formulas in a GridDataBoundGrid. Here is a KB discussing the work you have to do. http://www.syncfusion.com/support/kb/grid/Default.aspx?ToDo=view&questId=104
Another option might be to just put the data from the datatable in a GridControl. This would simplify the Excel-Like formula use tremendously. Depending upon the size of your datatables, this may not be to costly either.
Once you decide on the type you need, getting the information into either a CSV or Xls file should be straight forward. If you will provide more details about your formula requirements, we can try to give more specific advice.
