Excel chart has inconsistencies when printed - Bug-1296712-Excel-Content-Formatting-Affected.xlsx

Aspose.Cells Product Family
1

Dear Aspose.
As you can see from example.

When Worksheet is printed there are inconsistencies in the output:
1 - Pink box is lower and hides the value in orange rectangle
2 - Black text in bracket is lower and mess with pink box
3 - White (2) is lower - should be in pink box
4 - Black text in bracket is much lower, white text should be in pink box

Attaching image demonstrating the difference in output:
Bug-1296712-Excel-Content-Formatting-Affected.xlsx-Difference.png (217.6 KB)

Attaching sample application demonstrating the issue:
Bug-1296712-Excel-Content-Formatting-Affected.zip (244.7 KB)

We have used Windows and latest Aspose.Cells 25.4 to produce the results.

Best Regards
Pavel

2

@ottap

Could you please provide more details about the specific inconsistencies you are observing when printing the Excel chart? Additionally, what steps have you taken to troubleshoot this issue?

3

List of inconsistencies according to attached image and provided sample application:
When Worksheet is printed there are inconsistencies in the output:
1 - Pink box is lower and hides the value in orange rectangle
2 - Black text in bracket is lower and mess with pink box
3 - White (2) is lower - should be in pink box
4 - Black text in bracket is much lower, white text should be in pink box

4

@ottap
By testing on the latest version v25.4 using sample files and the following code, we can reproduce the four issues mentioned. Please refer to the attachment. out_net.zip (4.5 KB)

Workbook workbook = new Workbook(filePath + "Bug-1296712-Excel-Content-Formatting-Affected.xlsx");
Worksheet worksheet = workbook.Worksheets["Sheet1"];

worksheet.PageSetup.PrintTitleRows = null;
worksheet.PageSetup.PrintTitleColumns = null;
worksheet.PageSetup.ClearHeaderFooter();
worksheet.PageSetup.LeftMargin = 0;
worksheet.PageSetup.RightMargin = 0;
worksheet.PageSetup.TopMargin = 0;
worksheet.PageSetup.BottomMargin = 0;
worksheet.PageSetup.Zoom = 100;

var imageOptions = new ImageOrPrintOptions
{
    OnePagePerSheet = true,
    ImageType = ImageType.Svg,
    SVGFitToViewPort = true,
    OnlyArea = true,
};

var sheetRender = new SheetRender(worksheet, imageOptions);
sheetRender.ToImage(0, filePath + "out_net.svg");

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-58229: Pink box position error when saving file to svg
CELLSNET-58230: Black text in bracket and pink box mixed together when saving file to svg
CELLSNET-58231: White text is not in pink box when saving file to svg
CELLSNET-58232: The positions of black text in bracket and white text in pink box are incorrect when saving file to svg

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.