Why the function in the Excel can't be use in the Aspose.Grid.Web?

Aspose.Cells Product Family
1

Hi Admin:

"ISERR，ISNUMBER" like this function in the Excel, them can't be use in the Aspose.Grid.Web,why!!!???

2

Hi,

Well, these functions (ISERR, ISNUMBER) are not supported by Aspose.Grid.Web formula calculation engine at the moment. Hopefully, we can support it before the end of next week for your need. After we have incorporated the formulas, we will provide the supported version of Aspose.Grid.Web here.

Thank you.

3

Would you mand give me the list of the Excel function which the aspose.grid.web support ?

4

Hi,

Please check the document for supported functions list: http://www.aspose.com/documentation/visual-components/aspose.grid-for-.net/list-of-supported-functions.html The list is not final as there are a few more functions supported by the latest version of Aspose.Grid.Web, we will update it soon.

Thank you.

5

Hi,

Please try the attached version Aspose.Grid.Web v2.0.1.2007, we have supported your desired functions "ISERR" and "ISNUMBER".

Thank you.

6

Thank you very much! I will try it!

7

Hi

It seems there are some bug in the new version of Aspose.Grid.Web(v2.0.1.2007) ;

The same with last version, I set the formula include "ISERR" in the Excel file, but in the aspose.grid.web, "ISERR" can be clear.

e.g: In the Excel "=IF(ISERR(D52),123,D52)" , in the aspose.grid.web "=IF(D52,123,D52)"

the attached is my test view, you can see it.

8

Hi,

Well, we simply checked your formula "=IF(ISERR(D52),123,D52)", it works fine. Please make sure that you are using the latest fix "v2.0.1.2007" Could you post your template file here with all the details and screenshot(s) etc, so, that we can reproduce the issue you have found.

Thank you.

9

I am sure I used the newest version(v2.0.1.2007),but the "ISERR" is vanish in faith.

As I post the picture in my last post ,I don't know I can give your more info.

I just need you help me to resolve this : IF(ISERR(D52),123,D52) => IF(D52,123,D52);the aspose.grid.web can't read the "ISERR" and delete it by itself.

Help me please! It is very important to me!

10

Hi,

Well, we tested "ISERR" is read fine and is not deleted in the formula by Aspose.Grid.Web. We still appreciate if you could post your template file and tell us in which sheet section you find this problem. I think you can use some dummy data to fill your template file and post us here to check the issue. It will help us really to figure out the issue soon.

I think you may check the checkbox i.e. "Keep this post private" while answering this post, now only you and Aspose staff would be able to see/download your attachments. If you still feel some uncertainty, you may post us the template file via mail, please use the steps in the document: http://www.aspose.com/corporate/purchase/faqs/send-license-to-aspose-staff.aspx to post your template file/project.

Thanks for your workaround.