Excel to Emf - waterfall chart has missing number labels

Aspose.Cells Product Family
1

Hi,

I noticed that the conversion of my waterfall chart from xlsx to emf has missing number labels.

Code:
var workbook = new Workbook("./Test.xlsx");
var options = new ImageOrPrintOptions { ImageType = ImageType.Emf };
Worksheet sheet = workbook.Worksheets[0];
sheet.Charts[0].ToImage("./Test.emf", options);

I’ve attached the test files and a screenshot for your reference. Could you please look into that?

image.png (49.5 KB)
Test.zip (19.2 KB)

Thanks,
N

2

Hi,

Quick update on the issue.
It looks like it’s caused by the min attribute in the valScaling tag
<valScaling max=“10000” min=“5000” />

If I reduce it to 1000, the labels start appearing, but are not on the right place (see picture). If I set it to 0, they look fine.

image.png (6.2 KB)

Thanks,
N

3

@ServerSide527,
Could you please confirm if the latest version Aspose.Cells for .NET is used for testing. I have tried this scenario in Windows environment but could not observe any issue. Please share your environment details and try this scenario with the latest version if not done already.

Test2.emf.zip (4.3 KB)

4

Hi,

Thank you for the quick response. I tested it on the latest Aspose.Cells version and the issue is no longer there.

Thanks,
N

5

@ServerSide527,
Good to know that your issue is sorted out. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.