The image Aspose.Cell captures does not look like the original excel chart

Aspose.Cells Product Family
81

Hi @JThomas98
In the“PopulatedChart_stnd_main.xlsm” template, the missing asterisk border in the chart has been further optimized( The new output is in the attachment), it will take effect in the next version(24.7).
240620.zip (316.1 KB)

82

@leoluo, this is looking good. Appreciate your quick support!

83

@JThomas98
Thank you for your feedback. You will be notified when the next version v24.7 is released. If you have any questions, please feel free to contact us.

84

Hi Aspose Team,
I noticed another issue when I ran some tests with the latest version of aspose cells.
Test.zip (8.1 MB)

Here, you’ll notice that the labels are missing in the picture aspose captured of the excel range.
Can you let me know if this is something that’s only happening with me or if you can replicate this on your end as well.
Thank you!

85

@JThomas98,

I tested your scenario/case with Aspose.Cells for .NET v24.6 using your template Excel file and the following sample code. It works fine, and the output image (attached) is well-tuned (the labels are not missing).
e.g.,
Sample code:

string filePath = "e:\\test2\\Chart_Test.xlsm";
//Load the Excel file
Workbook workbook = new Workbook(filePath);

// Access the worksheet
Worksheet worksheet = workbook.Worksheets["DetailCharts"];
// Set the print area with your desired range in the worksheet
worksheet.PageSetup.PrintArea = "B73:M111";


// Set all margins as 0 (if you want) to remove extra white space around your range
worksheet.PageSetup.LeftMargin = 0;
worksheet.PageSetup.RightMargin = 0;
worksheet.PageSetup.TopMargin = 0;
worksheet.PageSetup.BottomMargin = 0;
// Set OnePagePerSheet option as true
ImageOrPrintOptions options = new ImageOrPrintOptions();
options.OnePagePerSheet = true;
options.ImageType = ImageType.Jpeg;
// Take the image of your worksheet
SheetRender sr = new SheetRender(worksheet, options);
string dataDir = "e:\\test2\\out1.jpg";
sr.ToImage(0, dataDir);

out1.jpg (169.4 KB)

If you still encounter the issue with the latest version/fix, please share your sample (runnable) code that you are using to reproduce the output image with missing labels. We will investigate it promptly.

86

@amjad.sahi,
I ran the code mentioned here using the test files I shared previously and here is what I’m getting
Out1.jpg (103.4 KB)

87

@JThomas98
We can reproduce the issue by testing it on the latest version v24.6 using sample file and the following sample code. Found chart data loss when converting file to image. Please refer to the attachment. out_net.jpg (114.2 KB)

The sample code as follows:

//Load the Excel file
Workbook workbook = new Workbook(filePath + "Chart_Test.xlsm");

// Access the worksheet
Worksheet worksheet = workbook.Worksheets["DetailCharts"];
// Set the print area with your desired range in the worksheet
worksheet.PageSetup.PrintArea = "B73:M111";

// Set all margins as 0 (if you want) to remove extra white space around your range
worksheet.PageSetup.LeftMargin = 0;
worksheet.PageSetup.RightMargin = 0;
worksheet.PageSetup.TopMargin = 0;
worksheet.PageSetup.BottomMargin = 0;
// Set OnePagePerSheet option as true
ImageOrPrintOptions options = new ImageOrPrintOptions();
options.OnePagePerSheet = true;
options.ImageType = ImageType.Jpeg;
// Take the image of your worksheet
SheetRender sr = new SheetRender(worksheet, options);
sr.ToImage(0, filePath + "out_net.jpg");

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): CELLSNET-56057

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.

88

Thanks, @John.He, for confirming this.

89

@JThomas98
You are welcome. If you have any questions, please feel free to contact us.

1 Like
90

@JThomas98,

I tested your issue using different Aspose.Cells assemblies of the latest version (Aspose.Cells for .NET v24.6 ). When I used the .NET 6.0 assembly in a .NET6 project, it worked fine and the labels were retained in the output image. However, when I used a .NET 4.0 project with the latest .NET 4.0 assembly of Aspose.Cells.Dll, I found the issue you described. Anyways, we already logged a ticket for your issue and we will be looking into it soon.

91

Hi @JThomas98
For the problem of missing datalabel (CELLSNET-56057), we optimized it, and the result is shown in the following figure. This is expected to take effect in version 24.7 and is expected to be released in early July.
240626.jpg (108.9 KB)

92

Thanks @leoluo. This is looking great!

93

@JThomas98,

Thanks for your feedback.

We will notify you once the fixed version is released.

1 Like
94

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

95

Hey Aspose team,
I’m still having issues with the missing label.
Here’s a test I ran:
Test.zip (7.9 MB)

I updated aspose cells to 24.7v.
What I’m noticing is that only a few of the charts are missing the labels. Not every single one of them.
I’ve attached the charts that are missing labels in this test.

96

@JThomas98,

Thanks for the template XLSM file.

After initial testing, I was able to reproduce the issue as you mentioned. I found some datalabels on the chart (second chart) are missing in the output image of the sheet.

//Load the Excel file
Workbook workbook = new Workbook("e:\\test2\\ChartTest.xlsm");

// Access the worksheet
Worksheet worksheet = workbook.Worksheets["DetailCharts"];

// Set all margins as 0 (if you want) to remove extra white space around your range
worksheet.PageSetup.LeftMargin = 0;
worksheet.PageSetup.RightMargin = 0;
worksheet.PageSetup.TopMargin = 0;
worksheet.PageSetup.BottomMargin = 0;
// Set OnePagePerSheet option as true
ImageOrPrintOptions options = new ImageOrPrintOptions();
options.OnePagePerSheet = true;
options.ImageType = ImageType.Jpeg;
// Take the image of your worksheet
SheetRender sr = new SheetRender(worksheet, options);
string dataDir = "e:\\test2\\out_net.jpg";
sr.ToImage(0, dataDir);

out_net.jpg (194.3 KB)

We require thorough evaluation of the 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): CELLSNET-56198

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.

1 Like
97

Hi @JThomas98
We’ve made some further refinements for CELLSNET-56198 and will take effect in 24.8. The optimized results are as follows:
240715.zip (342.1 KB)

98

Hi @leoluo, thanks for the update. I’m assuming the next release is in August? Is there a way I could test a beta version or something? My clients are waiting on this and would really appreciate if I could run a few tests on my end to show them that this is working.

99

@JThomas98,

Yes, your understanding is correct. We will include the fix/enhancement in Aspose.Cells for .NET v24.8, which will be released in the first half of August next month. I am afraid that in normal (free) support forums here, we can only provide results generated by new or upcoming versions and cannot share the fix here. If you need an interim fix, you can consider purchasing Paid Support Services.

100

@amjad.sahi, I understand. Here are some more anomalies I noticed in testing the current version of Aspose Cells (v24.7). Can you use this file to test for missing labels as well as the the other errors I’ve highlighted in the Output?