LOGEST support

Aspose.Cells Product Family
1

Hi. We are using the .NET version to generate Excel with both LINEST and LOGEST. LINEST works fine but LOGEST does not. According to your doc it's only supported in the Java version. Can this be supported in .NET? See the attached Excel sheet generated by Aspose.

Also, I was under the impression, from previous discussions, that you would just pass through to Excel functions you didn't support. While it's true that the function shows up in the appropriate cell, #VALUE! errors are reported. Is there any way to have Excel recalculate those cells when it reads the file so that we could use functions supported by Excel and not by Aspose? Right now, we have to go to every cell that has an unknown function and do F2 / Enter.

Thanks.

2

Hi,

We will provide you a supported version/fix for the LOGEST function to get/set and calculate the results of the formula very soon.

Thank you.

3

Hi,

Please try the attached version (4.5.1.23), we have supported to get/set and calculate the LOGEST formula.

Thank you.

4

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

This message was posted using Notification2Forum from Downloads module by Laurence.