Excel to PDF producing Postscript coordinates with Infinity

Aspose.Cells Product Family
1

I have a spreadsheet with a chart, and when converting that sheet to PDF, Aspose seems to be producing invalid Postscript in the PDF file. Looking at the file with PDF Inspector, there are move/draw commands that have Infinity in the coordinates:

image.jpg (266.0 KB)

This is causing issues with our downstream PDF processing as this isn’t valid for a PDF, as far as I can tell - the coordinates are supposed to be numeric.

Excel file that’s causing the issue, as well as the PDF-converted file, here: infinity.zip (119.1 KB)

2

@jrf.att
By using sample file for testing, we can reproduce the issue. Found postscript coordinates with Infinity in the pdf file.

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-55297

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.

3

Thanks @John.He ,

Following up, also noticed that Aspose is generating incorrect labels for the graph, both in the PDF conversion and GridJS.

Here’s Excel, notice how the yellow points on the graph are all multiples of 1000, corresponding to the Input Data sheet:

image.png (33.3 KB)

The PDF on the other hand has other values for some of those points, seemingly taking them from the current sheet (though not for all points):

image.png (61.9 KB)

GridJS has the correct values for the yellow points, but the text formatting is wrong for the blue points:

image.png (54.2 KB)

The PDF is the concerning one here because the values are straight-up incorrect.

Files for repro: infinity2.zip (119.9 KB)

4

@jrf.att
Through testing the following sample code on the latest version v24.3, We can reproduce the issue. Found chart rendering error when converting file to PDF.

The sample code as follows:

Workbook wb = new Workbook(filePath + "infinity.xls");
WorksheetCollection sheets = wb.Worksheets;
foreach (Worksheet sheet in sheets)
{
sheet.PageSetup.PrintArea = "";
}
PdfSaveOptions options = new PdfSaveOptions();
options.OnePagePerSheet = true;
wb.Save(filePath + "out_net.pdf", options);

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-55298

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.

5

@jrf.att,

We are pleased to inform you that the issue you reported earlier as “CELLSNET-55297” has been resolved. The fix will be included in the upcoming release (Aspose.Cells v24.4) that we plan to release in the first half of April (next month). You will be notified when the next version is released.

6

Hi @jrf.att
After optimization, the new results are as follows, which will take effect in 24.4.
240321.zip (452.7 KB)

7

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