CellArea class failed with $ in cell address like $A$1

Aspose.Cells Product Family
1

Hi,

I am using $A$1 instead of A1 as cell address but it is not working. Same thing i tried in Excel sheet it is working fine. Like = sum($A$1:$B$4) and =SUM(A1:B4) both sum formulas are working.

I am using Aspose.cell.jar (Version: 7.5.1.0).

Below is the example:

public static void main(String[] args) {
String startCell = “$A$1”;
String endCell = “$C$1”;
CellArea ca = CellArea.createCellArea(startCell, endCell);
}

Below is the Exception:-

Exception in thread “main” com.aspose.cells.CellsException: Invalid cell name
at com.aspose.cells.CellsHelper.a(Unknown Source)
at com.aspose.cells.CellArea.createCellArea(Unknown Source)
at TestAspose.main(TestAspose.java:16)

I am attaching excel sheet also.

It will be great if you will look into this problem and provide me some help or some pointer so that i can resolve this issue. If need anything else please let me know.

Thanks in advance.
2

Hi,

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

Well, you will have to use the cell name without $ sign. Anyway, we have logged your issue in our database for investigation. We will look into it and advise you. Once, there is some update for you, we will let you know asap.

This issue has been logged as CELLSJAVA-40579.

3

Hello,

Microsoft Excel support cell reference with $ symbol as well. This is used for absolute cell reference.

Please read:-

Cell Reference Types
Reference Type Formula What Happens After Copying the Formula
Relative =A1 Both the column letter A and the row number 1 can change.
Absolute =$A$1 The column letter A and the row number 1 do not change.
Mixed =$A1 The column letter A does not change. The row number 1 can change.
Mixed =A$1 The column letter A can change. The row number 1 does not change.

Ref:

http://www.dummies.com/how-to/content/using-absolute-and-relative-references-in-excel-21.html

Thanks,

Muhammed

4

Hi,

Thanks for your additional information and using Aspose.Cells.

We have already logged your issue. We will look into it and advise you. Once, there is some update for you, we will let you know asap.

5

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

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