Regression in smart markers since Aspose Cells Java 22.5

Hi Aspose Cells team,

Upgrading from 22.4 to 22.5, we noticed the following regression with smar marker “&=$SALES(horizontal)”:
image.png (1.7 KB)

… using Java code:

BigDecimal[] myArray = new BigDecimal[] {BigDecimal.valueOf(10), BigDecimal.valueOf(20), BigDecimal.valueOf(30), BigDecimal.valueOf(40)};
myWorkbookDesigner.setDataSource("SALES", myArray);
  • 22.4: get replaced with 4 cells “10” “20” “30” “40”
    image.png (1.5 KB)

  • 22.5: get replaced with “[Ljava.math.BigDecimal;@4b97c4ad
    image.png (2.1 KB)

Regards,
Jean.

@jeankst,

Thanks for the screenshots and details.

Please notice, I am able to reproduce the issue as you mentioned. I tested using the following sample code with a simple template file (containing a smart marker “&=$SALES(horizontal)”) and found the issue in the output file:
e.g.
Sample code:

        Workbook workbook = new Workbook("f:\\files\\Bk_smartmarkers12.xlsx");
        WorkbookDesigner designer = new WorkbookDesigner();
        designer.setWorkbook(workbook);
        BigDecimal[] myArray = new BigDecimal[] {BigDecimal.valueOf(10), BigDecimal.valueOf(20), BigDecimal.valueOf(30), BigDecimal.valueOf(40)};
        designer.setDataSource("SALES", myArray);

        designer.process();
        workbook.save("f:\\files\\out1.xlsx");

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

Once we have an update on it, we will let you know here.

@jeankst,

This is to inform you that your issue has been resolved. The fix will be included in the next release (Aspose.Cells for Java v22.6) which is scheduled in the second week of June 2022. You will also be notified when the next version is published.

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