Hi,
I'm using a new fresh Aspose.Cells (4.7.1.5) license and I have now an Exception:

Unsupported function in formula calculation engine - code 72
Error in calculating cell C1 in Worksheet ...

find attached the simple workbook i'm using.

here the simple code:

      Workbook aWk = new Workbook();
      aWk.Open(@"C:\\Temp\AsposeTest.xls");
      aWk.CalculateFormula();

Thanks for any help.

Paolo

---

Paolo "KingOfPatch" Ducoli
RDB & Open Systems
Brescia - ITALY

Hi Paolo,

Thanks for providing us the template file.

Well, your template file contains formulas e.g MINUTE, SECOND, these formulas are not supported for calculation, check the list of supported formulas: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/supported-formulas-functions.html  Aspose.Cells for .NET can only set these formulas to cells currently. We will analyze these formulas if we can support them soon for your need.

Also, Aspose.Cells for .NET does not support to calculate external referenced formulas as in the case with C1 cell's formula.

 

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

thanks for your fast reply (as usual)
ok for supported function (I will implement them as UDF, if I can ...)

but I don't understand what you say about external referenced formulas, I have no external reference in any cells. In C1 I have only a filename (as string ...)

anyway THANKS !!

Paolo

---

Paolo "KingOfPatch" Ducoli
RDB & Open Systems
Brescia - ITALY

Hi Paolo,

Sorry for the confusion.

Yes, indeed, C1 cell does not have external referenced formula but it corresponds to G1 cell value which consequently refers to E1 and F1 cell values and these two cells have formulas i.e.., "SECOND" and "MINUTE" that Aspose.Cells for .NET does not support to calculate the results.  As I said in my previous post, we will check the feasibility if we can support these formulas soon for your need.

Thank you.

 

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi Paolo,

Please try the attached version, we have supported to calculate "MINUTE" and "SECOND" functions.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

thanks for upgrade, I will try it soon.

why do you released .TLB file too ?
I've never seen it before with aspose.dll ...

Paolo

---

Paolo "KingOfPatch" Ducoli
RDB & Open Systems
Brescia - ITALY

Hi,

We, now, provide .tlb file for our COM users who use Aspose.Cells component in the environment/languages other than .NET's, e.g COM clients......JavaScript, VBScript, VB6.0 etc. The .tlb file is a type library file which describes all the details of the component's types / API etc for the COM clients, they may open it into vs.net and get the details for their need.

And,  you don't need to use this file, if your platform is .NET :)

Have a good day!

Thank you.

 

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us