Aspose Cells scale of y axis of the bar chart has changed when saving workbook to HTML

Aspose.Cells Product Family
1

We are currently planning the upgrade to the new version of Aspose.Cells and
noticed the following change in creation of HTML from Excel chart:
the scale of y axis of the bar chart has changed from 2000 to 1000.
We can reproduce this issue using Aspose Cells 23.7.2, the attached Workbook (MultiShapeRanges_Bar_and_Line_Charts.zip 38.4 KB)
and the attached sample code.
As shown in the attached output HTML MultiShapeRanges-v_23.7.2.html, the scale on Y-axis (1,000) is different from chart in the input Excel file (2,000).
Is there any workaround for this?
Is there some setting that would allow to set the scale on Y-axis to match the input Excel chart?

This is reproducible in both Windows 10 and Linux 7 OS environments.
Please let us know if you need anything else.
Thank you.
MultiShapeRanges_Bar_and_Line_Charts.7z (38.4 KB)

2

@oraspose,

After an initial test, I am able to reproduce the issue as you mentioned by using your template file. I found y-axis scale of the bar chart is changed when saving workbook to HTML.

We need to evaluate your issue in detail. 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): CELLSJAVA-45548

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.

3

Hi @oraspose
For this issue, the result of our optimization is as follows, it will take effect in the next version(23.8).
230803.zip (7.4 KB)

4

Thank you for the quick turnaround!

5

@oraspose
You are welcome!
If there is any update, we will inform you soon.

6

The issues you have found earlier (filed as CELLSJAVA-45548) have been fixed in Aspose.Cells for Java 23.8.

7

Hello team.
We reevaluated this issue with different type of chart (horizontal bar chart) and it seems the issue exists with X axis tickmarks. In the source excel chart the X-axis marks are at 10,000,000 intervals, and in the generated HTML they are at 20,000,000.
You can reproduce this using Aspose.Cells version 24.2.0, the same original sample code, and attached zip file containing the Excel worksheet BarChart.xlsx , and the output HTML for your inspection.
Please let us know if there are any questions.
Thank you.
HorizontalBarChart_xAxis.zip (32.0 KB)

8

@oraspose
Thank you for the provided resources and we have reproduced the issue. So we 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): CELLSJAVA-45919

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.