Missing values on x-axis on bar chart compared to original Excel file

Aspose.Cells Product Family
1

Hello,
we have an issue with an Excel sheet (sheet: Lead Time). Everything is converted fine except bar chart

  • values and bars KW36 - KW39 are missing.
  • wrong bar is colored, maybe some kind of follow-up issue, not sure

Here is how it looks in Excel:
expected.png (58,9 KB)

That is how it looks after conversion:
actual.png (97,1 KB)

Excel file:
missing_values.zip (83,8 KB)

Thank you in advance!

2

@FM123,

Thanks for the template XLSX file and screenshots.

After an initial test, I am able to reproduce the issue as you mentioned (via screenshots) by converting your template XLSX file to PDF. I found some values are missing on x-axis on bar chart compared to the chart in original Excel file.
e.g.
Sample code:

Workbook workbook = new Workbook("f:\\files\\missing_values.xlsx");
workbook.save("f:\\files\\out1.pdf");

We need to evaluate your issue thoroughly. 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 support policies.

Issue ID(s): CELLSJAVA-45524

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

3

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

4

Hi @leoluo,
looks fine, thank you very much!

5

@FM123,

Thanks for your feedback.

The fix will be included in an upcoming release (Aspose.Cells v23.8) that we plan to release in the first half of August 2023. You will be notified when the next version is released.

6

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