It's impossible to convert XLSX document with link to separate tab into PDFA-1B format

Aspose.Cells Product Family
1

I am trying to convert XLSX document with link to separate tab to PDFA-1B format. An error occurs: “Aspose.Cells.CellsException: Length cannot be less than zero.”.
Code :

using (var document = new Workbook(inputFilePath))
{
	document.BuiltInDocumentProperties.Title = "defaultTitle";
    document.BuiltInDocumentProperties.Author = "defaultAuthor";
    document.BuiltInDocumentProperties.Subject = "defaultSubject";
	
	foreach (var worksheet in document.Worksheets)
    {
        worksheet.PageSetup.PaperSize = PaperSizeType.PaperA4;
        worksheet.PageSetup.Orientation = PageOrientationType.Landscape;
        worksheet.PageSetup.FirstPageNumber = 1;
        worksheet.PageSetup.Zoom = 100;
    }
	
	var pdfSaveOptions = new PdfSaveOptions();
	pdfSaveOptions.Compliance = PdfCompliance.PdfA1b;
	
	document.Save(outputFilePath, pdfSaveOptions);
}

Files which error occurs when converting:
Broken conversion.zip (16.2 KB)

2

@uaprogrammer,

Thanks for the template XLSX files.

After an initial testing, I am able to reproduce the issue you mentioned by using your both XLSX files. I found an exception “Aspose.Cells.CellsException: Length cannot be less than zero” when rendering Excel file to PDFA-1B format.

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

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

@uaprogrammer
This is to inform you that your issue (“CELLSNET-56098”) has been resolved. The fix/enhancement will be included in our upcoming release (Aspose.Cells v24.7) which is due in the second week of July this month. You will be notified when the next version is released.

4

Thank you very much.

5

@uaprogrammer
You are welcome. Once the version v24.7 is released, we will notify you promptly.

6

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