We have noted it down. Let us evaluate the issue(s) and then we can update you on the issues. Once we have an update on any of the issues, we will let you know here.
1 Like
In newer Excel, Excel re-designed the star graphic(Icon Set graphics). We will evaluate to following the new design. If we have any progress, we will update you here.
Screenshot_star_graphic_issue.jpg (264.3 KB)
Thank you. Looking forward to the updates.
Sure, we will keep you informed as soon as the latest updates on the issue become available.
We are pleased to inform you that your issue (logged earlier as “CELLSNET-57742”) has been resolved. The enhancement will be included in the next release (Aspose.Cells v25.3) scheduled for release first half of March (next month). You will be notified once the new version is published.
Can I see an output of the fix?
Sure, we will check if we could provide you the output image generated by the latest fix. We will get back to you soon.
Please check the output Emf image generated by the fix with the following code:
Workbook workbook = new Workbook("Template_Stnd_Type1.xlsm");
// Access the worksheet
Worksheet worksheet = workbook.Worksheets["ExecSummary"];
// Set the print area with your desired range in the worksheet
worksheet.PageSetup.PrintArea = "G25:N38";
worksheet.PageSetup.LeftMargin = 0;
worksheet.PageSetup.RightMargin = 0;
worksheet.PageSetup.TopMargin = 0;
worksheet.PageSetup.BottomMargin = 0;
// Clear any header/footer as they'll be captured when converting the worksheet to image
worksheet.PageSetup.ClearHeaderFooter();
// Set OnePagePerSheet option as true
ImageOrPrintOptions options = new ImageOrPrintOptions()
{
OnePagePerSheet = true,
ImageType = Aspose.Cells.Drawing.ImageType.OfficeCompatibleEmf,
HorizontalResolution = 100,
VerticalResolution = 100,
OnlyArea = true
};
// Take the image of your worksheet
SheetRender sr = new SheetRender(worksheet, options);
sr.ToImage(0, "output_IconSet.emf");
Output_IconSet.zip (11.0 KB)
I can confirm this is looking exactly like excel. This is good. Thank you for sharing this with me.
Hi Aspose Team, I’m seeing another set of issues:
// Access the worksheet
Worksheet worksheet = workbook.Worksheets["Segmentation"];
// Set the print area with your desired range in the worksheet
worksheet.PageSetup.PrintArea = "P1:AR39"; // "P47:AR85"
worksheet.PageSetup.LeftMargin = 0;
worksheet.PageSetup.RightMargin = 0;
worksheet.PageSetup.TopMargin = 0;
worksheet.PageSetup.BottomMargin = 0;
// Clear any header/footer as they'll be captured when converting the worksheet to image
worksheet.PageSetup.ClearHeaderFooter();
// Set OnePagePerSheet option as true
ImageOrPrintOptions options = new ImageOrPrintOptions()
{
OnePagePerSheet = true,
ImageType = Aspose.Cells.Drawing.ImageType.OfficeCompatibleEmf,
HorizontalResolution = 100 /*(int)oldShape.ImageData.ImageSize.HorizontalResolution*/,
VerticalResolution = 100,
OnlyArea = true
};
// Take the image of your worksheet
SheetRender sr = new SheetRender(worksheet, options);
string dataDir = @"C:\Aspose Test\Test_02272025\out_image1.emf";
sr.ToImage(0, dataDir);
You can see that the first bar graph on the right has the value on top either being cropped out or barely visible. And majority of the vertical line to the right of this bar graph is missing.
Test_02272025.zip (856.6 KB)
And this template I have shared also contains another example that can be used to test CELLSNET-57840 - Labels moved for small proportions in Pie chart;
Worksheet: RespDemographics
Chart10
PieChart_Out1.png (8.9 KB)
→ When you compare charts in worksheet QuadrantMap, you’ll notice that the horizontal and vertical axis labels in “R1:AG38”, “R40:AG77” is in a different font and the footer text seems to be really bold (look at comparison2.PNG for reference)
→ And lastly, certain plottings in each quadrant is pointing the wrong way when compared to its excel counter part (look at comparison3.PNG for reference)
Test_02272025_2.zip (869.8 KB)
// Access the worksheet
Worksheet worksheet = workbook.Worksheets["QuadrantMap"];
// Set the print area with your desired range in the worksheet
worksheet.PageSetup.PrintArea = "R1:AG38"; // "R40:AG77"
worksheet.PageSetup.LeftMargin = 0;
worksheet.PageSetup.RightMargin = 0;
worksheet.PageSetup.TopMargin = 0;
worksheet.PageSetup.BottomMargin = 0;
// Clear any header/footer as they'll be captured when converting the worksheet to image
worksheet.PageSetup.ClearHeaderFooter();
// Set OnePagePerSheet option as true
ImageOrPrintOptions options = new ImageOrPrintOptions()
{
OnePagePerSheet = true,
ImageType = Aspose.Cells.Drawing.ImageType.OfficeCompatibleEmf,
HorizontalResolution = 100 /*(int)oldShape.ImageData.ImageSize.HorizontalResolution*/,
VerticalResolution = 100,
OnlyArea = true,
SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality
};
// Take the image of your worksheet
SheetRender sr = new SheetRender(worksheet, options);
string dataDir = @"C:\Aspose Test\Test_02272025_2\out_image1.emf";
sr.ToImage(0, dataDir);
By testing with the latest version v25.2 using the following example code, we were able to reproduce the issue. The top value of the first bar chart on the right has been cropped when converting chart to emf, but the vertical lines were correct. Please check the attachment. out_net.zip (17.9 KB)
Additionally, set the image type to ImageType.Emf can achieve better results. The sample code as follows:
Workbook workbook = new Workbook(filePath + "Chart_TEMPLATE.XLSM");
// Access the worksheet
Worksheet worksheet = workbook.Worksheets["Segmentation"];
// Set the print area with your desired range in the worksheet
worksheet.PageSetup.PrintArea = "P1:AR39"; // "P47:AR85"
worksheet.PageSetup.LeftMargin = 0;
worksheet.PageSetup.RightMargin = 0;
worksheet.PageSetup.TopMargin = 0;
worksheet.PageSetup.BottomMargin = 0;
// Clear any header/footer as they'll be captured when converting the worksheet to image
worksheet.PageSetup.ClearHeaderFooter();
// Set OnePagePerSheet option as true
ImageOrPrintOptions options = new ImageOrPrintOptions()
{
OnePagePerSheet = true,
ImageType = Aspose.Cells.Drawing.ImageType.Emf,
HorizontalResolution = 100 /*(int)oldShape.ImageData.ImageSize.HorizontalResolution*/,
VerticalResolution = 100,
OnlyArea = true
};
// Take the image of your worksheet
SheetRender sr = new SheetRender(worksheet, options);
string dataDir = filePath + @"out_net.emf";
sr.ToImage(0, dataDir);
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-57938
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.
By testing with the latest version v25.2 using the following example code, we were able to reproduce the issue. The position of the pie chart label is incorrect when converting chart to image. Please check the attachment. chat_net.png (9 KB)
Workbook workbook = new Workbook(filePath + "Chart_TEMPLATE.XLSM");
// Access the worksheet
Worksheet worksheet = workbook.Worksheets["RespDemographics"];
Chart chart = worksheet.Charts["Chart 10"];
chart.ToImage(filePath + "chat_net.png");
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-57939
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.
By testing with the latest version v25.2 using the following example code, we were able to reproduce the issue. Horizontal and vertical labels are garbled when converting chart to image. Please refer to the attachment. out_image_R1_AG38.zip (17.5 KB)
Workbook workbook = new Workbook(filePath + "Chart_TEMPLATE.XLSM");
// Access the worksheet
Worksheet worksheet = workbook.Worksheets["QuadrantMap"];
// Set the print area with your desired range in the worksheet
worksheet.PageSetup.PrintArea = "R1:AG38";
worksheet.PageSetup.LeftMargin = 0;
worksheet.PageSetup.RightMargin = 0;
worksheet.PageSetup.TopMargin = 0;
worksheet.PageSetup.BottomMargin = 0;
// Clear any header/footer as they'll be captured when converting the worksheet to image
worksheet.PageSetup.ClearHeaderFooter();
// Set OnePagePerSheet option as true
ImageOrPrintOptions options = new ImageOrPrintOptions()
{
OnePagePerSheet = true,
ImageType = Aspose.Cells.Drawing.ImageType.Emf,
HorizontalResolution = 100 /*(int)oldShape.ImageData.ImageSize.HorizontalResolution*/,
VerticalResolution = 100,
OnlyArea = true,
SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality
};
// Take the image of your worksheet
SheetRender sr = new SheetRender(worksheet, options);
string dataDir = filePath + @"out_image_R1_AG38.emf";
sr.ToImage(0, dataDir);
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-57940
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.
By testing with the latest version v25.2 using the following example code, we were able to reproduce the issue. Certain plottings in each quadrant is pointing the wrong way when converting chart to image. Please refer to the attachment. out_image_R40_AG77.zip (24.3 KB)
Workbook workbook = new Workbook(filePath + "Chart_TEMPLATE.XLSM");
// Access the worksheet
Worksheet worksheet = workbook.Worksheets["QuadrantMap"];
// Set the print area with your desired range in the worksheet
worksheet.PageSetup.PrintArea = "R40:AG77";
worksheet.PageSetup.LeftMargin = 0;
worksheet.PageSetup.RightMargin = 0;
worksheet.PageSetup.TopMargin = 0;
worksheet.PageSetup.BottomMargin = 0;
// Clear any header/footer as they'll be captured when converting the worksheet to image
worksheet.PageSetup.ClearHeaderFooter();
// Set OnePagePerSheet option as true
ImageOrPrintOptions options = new ImageOrPrintOptions()
{
OnePagePerSheet = true,
ImageType = Aspose.Cells.Drawing.ImageType.Emf,
HorizontalResolution = 100 /*(int)oldShape.ImageData.ImageSize.HorizontalResolution*/,
VerticalResolution = 100,
OnlyArea = true,
SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality
};
// Take the image of your worksheet
SheetRender sr = new SheetRender(worksheet, options);
string dataDir = filePath + @"out_image_R40_AG77.emf";
sr.ToImage(0, dataDir);
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-57941
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.
@JThomas98
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-57943
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.
Hi @JThomas98
For the issue of a missing datalabel you mentioned before, we have recorded it as “CELLSNET-57943” and fixed it, the result is as follows, it will take effect in version 25.3.
CELLSNET-57943-fix.png (1.9 KB)
Also, for the area you previously circled in yellow in “KeyDrivers_G1_L17.jpg”, I would like to confirm with you, do you referring to the style of the arrow, which is different from Excel? The Excel arrow seems to be sharper and more slender, which is the problem you want to solve, right?
arrow.png (2.2 KB)
@John.He, you are right about the vertical line being correctly in that particular chart. Please refer range “Segmentation!P47:AR85”. Here you’ll see both the issues happening, vertical line separation is missing as well as the value at the top of the left most bar chart being cropped.
I’ve attached a screenshot for your reference:
Comparison.png (147.3 KB)