I’m not sure if it’s a bug in Aspose.Cells or Microsoft Excel but I noticed different behavior for following scenario:
- Define global named range in excel using excel’s offset function as =OFFSET(Sheet1!$A$1,0,0,2,2).
- Verify that this named range points to 2x2 range (2 rows and 2 columns) and identical 2x2 range is returned by Aspose.Cells using following code: workbook.getWorksheets().getNames().get(“offsetrange”).getRange()
- Merge cells A1, A2, A3 into one
- After that Aspose.Cells still returns the same 2x2 range but Excel is now returning 3x2 range (3 rows and 2 columns)