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)
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
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.
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
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)
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.
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.
@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?
- The arrows/bullets that point at the intersection of the different sections of the chart is somehow not pointing at the intersection. It’s a little off.
- A couple of the charts are missing labels.
- The check marks in the charts are pushed further to the right when it’s supposed to be closer to the box with the value.
- One chart is missing an outline border.
Here’s the test file:
Test2.zip (1.5 MB)
Thank you for providing us with the template Excel file and MS Word documents to demonstrate the issues.
We were able to reproduce the issues you mentioned (as per the screenshots in the Word document you attached) by directly converting your template Excel file to PDF (while setting the printable area of the DetailCharts sheet to “B73:M1405”).
e.g.,
Sample code:
string filePath = "e:\\test2\\ChartTest.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:M1405";
workbook.Save("e:\\test2\\out1.pdf");
We have logged separate issues (as following) for each of the mentioned issues.
– The arrows/bullets that point at the intersection of the different sections of the chart is somehow not pointing at the intersection. It’s a little off. (CELLSNET-56278)
– A couple of the charts are missing labels. (CELLSNET-56280)
– The check marks in the charts are pushed further to the right when it’s supposed to be closer to the box with the value. (CELLSNET-56282)
– One chart is missing an outline border. (CELLSNET-56283)
Once we have an update on any of the issues, we will let you know.
You are welcome. And, sure, we will keep you posted with updates on the logged issues (once available).
Hi @JThomas98
For CELLSNET-56280 (missing x-axis) and CELLSNET-56278(arraw not pointing at the intersection), we have made the optimization, the results are attached(I marked them with a red circle), the rest of the problem we are dealing with, as soon as there is progress, we will inform you.
240724.zip (1.4 MB)
You are welcome. We will keep you posted with updates once they are available on the remaining issues.
For the border line missing issue in Page 10, it is the cell boder. Take Cell M470 for example, Cell M470 doesn’t have the right border, the border displayed is the left boder of Cell N470. You can use the following code to check it.
Worksheet worksheet = wb.Worksheets["DetailCharts"];
Cell M470 = worksheet.Cells["M470"];
Console.WriteLine(M470.GetStyle(false).Borders[BorderType.RightBorder].LineStyle);
Cell N470 = worksheet.Cells["N470"];
Console.WriteLine(N470.GetStyle(false).Borders[BorderType.LeftBorder].LineStyle);
But the print area doesn’t inlude column N, so the boder is missing.
If you printview the source file in Excel, you will find the border is also missing in Excel printview.
Hi @JThomas98
For CELLSNET-56282, we optimized the location of check marks as shown in the figure below, This will take effect in Aspose.Cells 24.8.
240727.png (44.4 KB)