Function RSQ() not supported in Asposce-cells-8.5.0?

Aspose.Cells Product Family
1

Hi Team,

When our team developed on aspose-cells 8.5.0 version, we found a issue related to RSQ() formula in Excel.

Eg. =RSQ((B1:B35-A1:A35),A1:A35)*100 is not able to get result after we apply workbook.calculateFormula();

I attached the example here for reference (Summary!D3 formula not calculated). I disable the excel auto calculate to avoid mess up.

Best,
David

2

Hi David,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue by executing the following code with the latest version: Aspose.Cells for Java 8.5.2 using your source excel file and found RSQ value in cell D3 was not calculated correctly.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSJAVA-41450 - Function RSQ is not calculated correctly

I have attached the output pdf generated after calculating the formulas using Aspose.Cells for a reference.

Java

String filePath = “F:\Shak-Data-RW\Downloads\correlationTest_new.xlsx”;


Workbook workbook = new Workbook(filePath);

workbook.calculateFormula();


workbook.save(filePath + “.out.pdf”);

3

Hi Aspose Team,

Base on response, both RSQ and STEYX formula are not supported by Aspose cells latest version.

Function STEYX() not supported in Apose library aspose-cells-8.5.0

Our company daily research reports are all using Aspose library. Could you give ETA for reliable version. Thanks!

David

4

Hi David,

Thanks for your posting and using Aspose.Cells.

Mostly, such issues are fixed in couple of weeks. However if the issue is difficult to be fixed, then it might take more weeks. Please spare us a week or so and once we will have some fix or other news for you, we will share it with you asap.

5

Hi,

Thanks for using Aspose.Cells.

This is to inform you that we have fixed your issue CELLSJAVA-41450 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

6

Hi,

Thanks for using Aspose.Cells for Java.

Please download and try this fix: Aspose.Cells for Java v8.5.2.3 and let us know your feedback.

7

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

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