Hi,
Is this extension able to calculate cells with formulae?EPPlus has a function to do this: Calculate.
https://epplus.codeplex.com/wikipage?title=About%20Formula%20calculation
Cheers,Eduardo Jauch
Hi Eduardo,
I will evaluate the possibility of adding the Calculate functionality to the component.
Thank you for the request!
CA
Hi again Eduardo,
I've uploaded a new version of the component, with three new actions:
Thank you for your request and hope this helps!
Thanks! It will be useful! :)
Please pardon the noob question... how do i add a formula to a cell?
When i write a formula, it just displays as text in the excel, the calculate function doesn't seem to do anything.
Thanks
Hello Vibhu,
Thank you for this request, I've uploaded a new version of the component, with the ability to write a formula to a Cell identified by index or name.
Thank you.