^ power operator is not working

Aspose.Cells Product Family
1

Hi,
We have the power function with ^ operator in our excel template. It is working fine in excel but does not work in aspose calculate-function.

Example : =(-27)^(1/3) – aspose calculate function gives Nan and excel gives -3
=POWER((-27),(1/3)) – both excel and aspose calculation gives correct result.

we are using aspose java version 21.5

Please advise
thanks
Puva

2

@cgkrish,

Please notice, I am able to reproduce the issue as you mentioned by using the following sample code with a simple template file (attached). I found power operator “^” is not working for formula calculations in Aspose.Cells for Java:
e.g.
Sample code:

Workbook workbook = new Workbook(“E:\test2\Bk_poweroperator1.xlsx”);

    workbook.calculateFormula();

    Cell cell = workbook.getWorksheets().get(0).getCells().get("A1");
    String cellValue = cell.getValue().toString();
    String CellValue2 = cell.getStringValue();
    System.out.println(cellValue);//#NUM! //Error
    System.out.println(CellValue2);//#NUM!//Error

    cell = workbook.getWorksheets().get(0).getCells().get("A2");
    cellValue = cell.getValue().toString();
    CellValue2 = cell.getStringValue();
    System.out.println(cellValue);//-3.0
    System.out.println(CellValue2);//-3

I have logged a ticket with an id “CELLSJAVA-43583” for your issue. We will look into it soon.

Once we have an update on it, we will let you know here.
files1.zip (5.2 KB)

3

Thanks
could you please provide the ETA for this fix.

4

@cgkrish,

Your issue is “In Progress”. We are working over your issue and hopefully it will be figured out soon. Moreover we include more test cases for calculating POWER operator and function, so such an issue may not occur next time.

Once we resolve it or have some other updates, we will let you know.

5

@cgkrish,
This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

6

Thanks.
please let us know when it completed. Our team will contact you to get latest version.
please provide estimated release date
thanks
puva

7

@cgkrish,
It will be released in a couple of days. You will be notified here automatically.

8

The issues you have found earlier (filed as CELLSJAVA-43583) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi