Select a grid control for working with Excel formulas

Hello.
Excuse my ignorance, I'm totally newbie in C# world, but still...
We have a very old (20 years old) project and want to rewrite it in modern manner. Key feature in project is Excel-like table and formula's calculations.
So we are looking for modern gui control (this control is primary, and language\environment is secondary) with similar functionality:
- Operations on cells level (control each cell's style).
- Calculations using Excel-like formulas.
I found several grid in your product list (GridControl and sfDataGrid).
First (GridControl) have all functions what I want, but I don't know how to use it in WPF with MVVM pattern. I don't want to have spagetti from view and data mix. It looks like this component created for Windows Forms. also it's marked as deprecated.
Second (sfDataGrid) don't have what I'm expecting (formulas, cell's properties; only column-level), but it's going in MVVM way and in active development.
So, please, explain: do you have now a gui control for wpf which emulate behavior of Excel spreadsheet?
Thanks.
PS. Also as I understand your grids under JS world also don't have formula support and cell's properties?

1 Reply

DY Deivaselvan Y Syncfusion Team November 5, 2018 06:28 PM UTC

Hi Sergey, 

Thanks for using Syncfusion products. 

Please find the below attached sample for GridControl with MVVM pattern. 

Sample link: 

SfDataGrid does not have support for Excel-Like formulas. If you want to add the formulas, use it as expression for unbound columns.  
Please refer the below UG for more details, 

UG Link: 

Regards, 
Deivaselvan 


Loader.
Up arrow icon