Layout Issues When Using 2D Bar Charts with GridJs (XLSX/XLSM)

Aspose.Cells Product Family
1

Hi Aspose team,

We are encountering several layout-related issues when working with Excel files (both .xlsx and .xlsm) containing 2D bar charts using Aspose.Cells.GridJs (v25.*) in a .NET environment.

:white_check_mark: Common issues with both .xlsx and .xlsm files containing 2D bar charts:

  1. Layout is broken when the Excel file is converted and displayed in the GridJs web interface.
  2. After editing in the GridJs interface and downloading via File → Download As XLSX, the layout in the resulting Excel file is also broken.
    → In short, the layout breaks during both the Excel → GridJs and GridJs → Excel transitions when 2D bar charts are involved.

:warning: Additional issue with .xlsm files (with charts and images):

When editing an .xlsm file in GridJs and downloading it using File → Download As XLSX, we noticed that:

  1. All chart and image areas in the resulting Excel file are completely misaligned or broken.

Are these known issues? If so, could you please provide any workaround or guidance to address them?

Thank you in advance for your support.

3

@anhh
can you provide the sample files

4

After conducting additional tests, I have confirmed that the layout issues I am experiencing occur regardless of the file format (.xlsm or .xlsx).

I have attached a test Excel file that contains both a chart and an image. The issues I am encountering are as follows:

  1. The layout of the 2D bar chart is broken after converting the Excel file using GridJS.
  2. When the file is downloaded back as an Excel file via GridJS, the layout of the image and the 2D bar chart is also broken.

You can reproduce the issue by opening the attached file, converting it with GridJS, and then downloading it again as an Excel file. The layout discrepancy will be clearly visible.

Please review the attached file and advise on any solution or workaround.

Thank you for your assistance.
2d_bar_chart_layout.7z (541.3 KB)

5

@anhh
Thanks .
Now we can reproduce this issue.
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSGRIDJS-1739

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.