Aspose.cells : formula NORMDIST not working

dear support.


thank you for this great product.
I have however a problem with drawing an XY ( or scatter ) plot.

Please find attached the source excel file

The data in column A and B is retrieved dynamically.
In cell F3 and F4, I calculate the average and standard deviation.




dear support,


apologies for the above post.
there was a copy paste error


I investigated the problem a bit further.

It seems that the formula NORMDIST is not working in the WebGrid.

Apologies for the confusion, but I am calculating excel files using aspose.cells and am then showing the results using Webgrid, so it was a bit complicated to figure out where the problem is.

So, bottomline, NORMDIST is not working inside webgrid.

guido

Hi Guido,

Thanks for your posting and using Aspose.Cells for GridWeb.

We were able to observe this issue.Formula NORMDIST is not working in GridWeb. We have logged this issue in our database for investigation. We will look into it and fix this issue if possible. Once, we have fix or some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-42418.

I have attached the screenshot highlighting the issue for a reference.

C#


string filePath = @“F:\Shak-Data-RW\Downloads\SPC.xlsx”;


this.GridWeb1.WebWorksheets.ImportExcelFile(filePath);


Screenshot:

Hi Guido,

Thanks for using Aspose.Cells for GridWeb.

The NORMDIST function was not supported in the previous version, so we have added the implementation of this function in the newer version. We will provide you a fix soon.

Hi Guido,

Thanks for using Aspose.Cells for GridWeb.

We have fixed this issue.

Please download and try the latest version: Aspose.Cells
for GridWeb v6.0.1.2001
and let us know your feedback.


The issues you have found earlier (filed as CELLSNET-42418) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.