After importing the data from work sheet along with formula's , Can we apply the formula's from excel to win grid. Is there any other control which will work like this ?
Hi,
There's no way to just hook this up automatically or convert the Excel formulas into grid formulas. You might be able to achieve what you want by reading the Excel data into a DataTable and then translating the formulas yourself, but this would be extremely difficult - it's not an easy or simple task.
You can Submit a Feature Request if you like, and perhaps this can be added in a future release. But frankly, I'm not sure if it's even possible to translate Excel Formulas into grid formulas.