405
Views
7
Comments
Solved
[Excel Package] Calculate Formulae
excel-package
Forge component 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

mvp_badge
MVP
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

mvp_badge
MVP

Hi Eduardo,

I will evaluate the possibility of adding the Calculate functionality to the component.

Thank you for the request!

CA

mvp_badge
MVP
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

mvp_badge
MVP

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

mvp_badge
MVP

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

Hello Carlos, do you have any example of setting formula in the excel cell? I tried but it it will display "#value!" calculation error after the excel file is generated. Then, when I open the excel file and click "Enable Editing", the formulas work well.

Any tricks?

Maple Field

Hi Carlos,

Is it possible to read the excel with headers starting from row 12 instead of row 1?


Thanks,

Saicharan

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.