[Excel Package] Calculate Formulae

[Excel Package] Calculate Formulae

  
Forge Component
(4)
Published on 11 May by Carlos Alfaro
4 votes
Published on 11 May by Carlos Alfaro

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

Solution

Hi again Eduardo,

I've uploaded a new version of the component, with three new actions:

  • Workbook_Calculate() - calculates all formulas in the Workbook
  • Worksheet_Calculate() - calculates all formulas in one Worksheet
  • Cell_CalculateByIndex() - calculates the formula of a cell, defined by its index

Thank you for your request and hope this helps!

CA

Solution

Thanks! It will be useful! :)

Hi,

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.

CA