Chart to Image/PDF - wrong output with Waterfall type

Aspose.Cells Product Family
, , ,
1

Hello,
I am trying to output a waterfall chart from Excel to a jpg file using the ToImage function. I am experiencing an issue that the data labels are not shown on the chart columns. I do see them in Excel.
Attached my code, as well as the Excel and the wrong image. I tried converting to PDF - same issue.
I am using .NET 21.4 (tried with 21.3 as well).
waterfall_wrong_output.zip (163.5 KB)

static void Main(string[] args)
{
	var dataDir = @"c:\temp\";

	// Creating a file stream containing the Excel file to be opened
	using (var fstream = new FileStream(dataDir + "waterfall_chart.xlsx", FileMode.Open))
	{
		// Instantiate a Workbook object that represents the existing Excel file
		var workbook = new Workbook(fstream);
		var chart = workbook.Worksheets["Sheet1"].Charts[0];

		chart.ToImage(dataDir + "1.jpg", new ImageOrPrintOptions
		{
			TextRenderingHint = TextRenderingHint.ClearTypeGridFit,
			VerticalResolution = 300,
			HorizontalResolution = 300,
			OnlyArea = false,
			ImageType = ImageType.Jpeg
		});
	}
}
2

@eyalmolad,

Please notice, I am able to reproduce the issue as you mentioned using your template file. I found data labels on the Waterfall chart is not shown in the output image. I have logged a ticket with an id “CELLSNET-47986” for your issue. We will look into it soon.

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

3

@eyalmolad,
Please try our latest fix v21.4.2:

Aspose.Cells21.4.2 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.4.2 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.4.2 For .NetStandard20.Zip (5.5 MB)

Your issue should be fixed in it.
Let us know your feedback.

4

Hello,
This works for me!
Is the update available for Java as well? When could we expect the released version in Java?
Thanks

5

@eyalmolad,

Could you please try our latest Java fix: Aspose.Cells for Java v21.4.2:

aspose-cells-21.4.2-java.zip (7.3 MB)

Let us know your feedback.

6

Thanks - this works in Java as well.

7

@eyalmolad,

Good to know that the Java fix fixes the issue as well. In the event of further queries or issue, feel free to write us back.

8

Sure, thank you. When the fix is going to be available via Maven?
Thanks

9

@eyalmolad,

Our next official release, i.e., Aspose.Cells for Java v21.5 will be published in the second half (probably in the third week of May, 2021) of May, 2021, so you have to wait a bit for it. This release will also include your fix. Please note, only official releases are published on Maven repos. and Downloads section.

10

The issues you have found earlier (filed as CELLSNET-47986) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao