We're having a problem processing a spreadsheet using our application. Whilst we can succesfully process several other spreadsheets we get an error on this one that say's....
'Unsupported function in calculation engine - code 59'
@ objWorkBook.CalculateFormula
We assume this means that the spreadsheet we are using has a formula that is unsupported by ASPOSE! It's a very large spreadsheet and I've run a macro that shows all the functions and formula's used throughout the spreadsheet but I can't see one that is not on your list of supported formulas. Could something else stop the spreadsheet from functioning other than a formula/function? Do you have a list of functions that you DON'T support that we could look at in case we've missed something? I would appreciate your help.
Could you post your template file here, we will check it soon.
And here is the list of all the supported functions, so you may check them. If a function is not there in the list, you may assume that the function / formula is yet to be supported. You should also confirm with us too and we will check and try to support it soon for your need:
It’s a very large excel file so I’ve saved the functions/formula report as an web page and posted it onto a server for you to look at. It’s like looking for a needle in a haystack but maybe you can find something obvious quite quickly.
Not sure which version it is but I purchased it in July this year. There's an SKU of 1000352 but I'm not sure what that means.
I tried putting the version of Aspose.cells.dll that you attached into C:\Program Files\Aspose\Aspose.Cells\Bin\Net2.0 and Net1.0 but when I run the application I get a license error. Am I installing it wrong?
There is a PMT function in our spreadsheet which Aspose now supports as you suggest. There's also an IPMT function in there which is not on the Aspose supported function list. I'll keep looking through the spreadsheet to see if I can find any more unsupported functions and let you know.
We have supported IPMT function in the attached fix. We will update the supported function list.
Please check which dll your project refered. If you are sure that you are using the attached version and still get the license error, please mail your lic to nanjing@aspose.com. We will check it soon.
I did put the latest dll that you recomended into the bin folders and I hope that's the right place.
I still get the license error so I've sent off a copy to nanjing@aspose.com as you suggested.
I've been through our spreadsheet and found these functions not currently on your supported function list for .NET... they are PMT, IPMT and ISERROR. From what you're telling me the latest version supports both PMT and IPMT and you're going to update your list. That just leaves ISERROR.
The ISERROR function only occurs in seven places in the spreadsheet so if I can find an alternative to the way it's being used or you can include the ISERROR function in ASPOSE that might solve my problem.
I'm a bit confused and probably doing something wrong with the new Aspose.Cells.dll file that you sent to me...
At the moment I have a fully functioning application that works with ASPOSE on several spreadsheets so my license and dll's are in the correct place. Now that I have introduced a new spreadsheet I get the error message about an unsupported function. You've sent me a new Aspose.Cells.dll which I put into the following directory
C:\Program Files\Aspose\Aspose.Cells\Bin\Net2.0 and Net1.0
When I now run my application (even without the spreadsheet with the unsupported functions) I get this error message
OLE error 80131040, Prog ID: "Aspose.Cells.License"
If I then take the new Aspose.Cells.dll out of those folders and put the original .dll back it works fine again.
Am I putting the dll in the wrong place. Do I need to re-install a full version of AsposeCells that contains this dll so that it gets registered?
The application that we have built is not compiled, it is interpretive. The underlying programming language of the developer tool (SOCRATES, from CINCOM corp) used for my application is Delphi. We notice that on google there are many references to this OLE error 80131040 and Delphi.With the new dll I still get this same error.
Is there something fundamentaly different about the new dll i.e. is it now a .net assembly whereas before it was a regular dll? Something must be different???
Before I added this new dll I had a working application and it's getting to a critical part of my project where I have to deliver...
I believe that when we dragged and dropped the dll into the assembly folder this is the same as doing a gacutil on it, i.e. it put the assembly into the GAC.
We are calling it as a COM object, not a .NET assembly. Do you have specific commands that we need to run to register it correctly for use as a COM object.
I don't know why I'm having such a problem with this but I'm struggling to register this dll with the advice given in the previous replys and I get the following error...
RegAsm: error RA0000: Unable to locate input assembly 'C:\Program Files\Aspose\Aspose.Cells\Bin\Net2.0\Aspose.Cells.dll' or one of it dependencies
Could you possibly supply the exact commands and directries that I need to use to register this dll or even better supply a new Aspose.Cells.msi file to me that contains the latest dll. This will register the new dll in the correct place without me having spend a lot of time trying to find may way around. I've also got to get this new dll onto a server as well as my development PC so a new .msi file would help.
I think you have .net framework 2.x (VS.NET 2005) on your system. Could you try to install VS.NET 2003 (.NET framework 1.1) on your pc and re-try the command to check if it works. Moreover, when you install Aspose.Cells.msi, the component is automatically get registered for com clients. We recommend you to register the latest fix (Which Simon provided for you in his previous rely in this thread) on your system.
Sorry for my mistake, I think you don't need to install VS.NET 2003 (.NET framework 1.1) on your machine as It should work fine for both. Please try the command with the latest fix (which Simon has provided you), you may simple put the Aspose.Cells.dll file into some folder and open the VS.NET command prompt and change dir to that folder and run the command, e.g..,
...regasm Aspose.Cells.dll and press enter. It should register the component.
any news on this because I got a similar problem with version 2.9.3.40605 (the version 2.8.4.0 worked). The only formula on the workbook is (in german):