Error in converting Excel with image to PDF

[[email protected]]

I am getting following error. I am attaching zip files of pdfs I will send the file separately which containts
Error Occurred |System.IndexOutOfRangeException: Index was outside the bounds of the array.
at spr?.?(String A_0)
at spr?.?(String A_0)
at spr?.?(String A_0)
at Spire.Pdf.PdfDocumentInformation.?()
at Spire.Pdf.PdfDocumentInformation.?()
at Spire.Pdf.PdfDocumentInformation..ctor(spr? A_0, spr? A_1)
at Spire.Pdf.PdfDocumentBase.?()
at Spire.Pdf.PdfDocumentBase.get_DocumentInformation()
at spr?.?()
at spr?.?(Stream A_0)
at Spire.Pdf.PdfDocumentBase.Save(Stream stream, FileFormat fileformat)
at Spire.Pdf.PdfDocument.SaveToStream(Stream stream, FileFormat fileformat)
at AutoNotification.DPDFGenerationOperation.PerformOperation()

[kylie.tian]

Hi,

Thank you for your reply.
I reproduced the problem and posted it to our bug tracking system with the ticket number SPIREPDF-5305. Once the problem is solved or there is any update, I will inform you as soon as possible. Sorry for the inconvenience.

Sincerely,
Kylie
E-iceblue support team

[kylie.tian]

Hi,

Glad to inform that we just released Spire.Office Platinum(Hotfix) Version:7.7.2 which fixed SPIREPDF-5255, you can download it from the following links to test.
Website link: https://www.e-iceblue.com/Download/down ... t-now.html
Nuget link: https://www.nuget.org/packages/Spire.Office/7.7.2

Sincerely,
Kylie
E-iceblue support team

[[email protected]]

Thank you for the update.
There is also open issue SPIREPDF-5305. Please let me know when that s fixed.

Thanks,
Sarvesh

[kylie.tian]

Hi,

Our development team has adjusted your question and it is going to the test stage now. If the test goes well, we will provide a hotfix asap. I will inform you as soon as there is any good news. Thanks for your understanding.

Sincerely,
Kylie
E-iceblue support team

[[email protected]]

Hello,

Any update on the fix?

Thanks,
Sarvesh

[Nina.Tang]

Dear Sarvesh,

Your issue has been fixed and we are going to release a new version which contains the fix of your issue next Monday. Please give us a little more time. Thanks for your understanding.

Sincertely,
Nina
E-iceblue support team

[kylie.tian]

Hi,

Glad to inform that we just released Spire.Office Platinum(Hotfix) Version:7.7.6 which fixed SPIREPDF-5305, you can download it from the following links to test.
Website link: https://www.e-iceblue.com/Download/down ... t-now.html
Nuget link: https://www.nuget.org/packages/Spire.Office/7.7.6

Sincerely,
Kylie
E-iceblue support team

[kylie.tian]

Hi,

Greetings from E-iceblue.
Has your problem been effectively solved now? Could you give us some feedback at your convenience?

Sincerely,
Kylie
E-iceblue support team

[[email protected]]

Hello,

Thank you for checking in. While testing various documents as PDF merge I found another issue with documents ( attached). I am trying to merge multiple pdf documents into one pdf document. I am getting following error for attached document

System.ArgumentOutOfRangeException: Year, Month, and Day parameters describe an un-representable DateTime.
at System.DateTime.DateToTicks(Int32 year, Int32 month, Int32 day)
at System.DateTime..ctor(Int32 year, Int32 month, Int32 day, Int32 hour, Int32 minute, Int32 second, DateTimeKind kind)
at spr?.?(spr? A_0)
at spr?.?()
at Spire.Pdf.PdfDocumentInformation.?()
at Spire.Pdf.PdfDocumentInformation.?()
at Spire.Pdf.PdfDocumentInformation..ctor(spr? A_0, spr? A_1)
at Spire.Pdf.PdfDocumentBase.?()
at Spire.Pdf.PdfDocumentBase.get_DocumentInformation()
at spr?.?()
at spr?.?(Stream A_0)
at Spire.Pdf.PdfDocumentBase.Save(Stream stream, FileFormat fileformat)
at Spire.Pdf.PdfDocument.SaveToStream(Stream stream, FileFormat fileformat)
at AutoNotification.DPDFGenerationOperation.PerformOperation()

[Abel.He]

Hello,

Thanks for your inquiry.
I did reproduce your issue by using the following code1 to test your issue. I have logged it into our bug system with the ticket number SPIREPDF-5478. Our development team will investigate and fix it. Once it is fixed, I will inform you in time. Sorry for the inconvenience caused.

In addition, I didn’t reproduce your issue by using the following code2. I suggest you use the code2 to achieve your requirement before fixing the issue with SPIREPDF-5478.
If you have any issue, just feel free to contact us.

Code1:

Code: Select all

//Pdf document list
            String[] files = new String[]
            {
                   @"..\..\Data\ConstPlan_10140499 Staking Sheet_08-11-2022 105215.pdf",
                   @"..\..\Data\ConstPlan_10143790 Staking Sheet_08-19-2022 090011.pdf",
                   @"..\..\Data\ConstPlan_10146510 Staking Sheet_08-18-2022 013703.pdf"
            };
            //Open pdf documents           
            PdfDocument[] docs = new PdfDocument[files.Length];
            for (int i = 0; i < files.Length; i++)
            {
                docs[i] = new PdfDocument();
                docs[i].LoadFromFile(files[i]);
            }

            //Append document
            docs[0].AppendPage(docs[1]);
            docs[0].AppendPage(docs[2]);

            //Save pdf file
            Stream stream = new MemoryStream();
            docs[0].SaveToStream(stream, FileFormat.PDF);

            //Close
            foreach (PdfDocument doc in docs)
            {
                doc.Close();
            }

Code2:

Code: Select all

String[] files = new String[]
               {
                     @"..\..\Data\ConstPlan_10140499 Staking Sheet_08-11-2022 105215.pdf",
                     @"..\..\Data\ConstPlan_10143790 Staking Sheet_08-19-2022 090011.pdf",
                     @"..\..\Data\ConstPlan_10146510 Staking Sheet_08-18-2022 013703.pdf"
               };
                 
              //Merge files
              PdfDocumentBase doc = PdfDocument.MergeFiles(files);

              //Save and launch
              //doc.Save(@"../../output/MergeFilesByStream_result.pdf", FileFormat.PDF);
              Stream stream = new MemoryStream();
              doc.Save(stream, FileFormat.PDF);     


Sincerely
Abel
E-iceblue support team

[[email protected]]

Hello,

Is there any update on fixing the bug?

Thanks,
Sarvesh

[Abel.He]

Hello,

Thanks for your following-up.
Your issue with the number SPIREPDF-5478 has been in test phase, I have urged our test team to test it. Once the official version fixing your issue is released, I’ll inform you in time.

Sincerely
Abel
E-iceblue support team

[[email protected]]

Hello,

Any update on this last issue?

[Abel.He]

Hello,

Thanks for your following-up.
The issue with the number SPIREPDF-5478 has been solved in thelatest version 8.10.5 of Spire.Pdf, but this fix currently hasn’t been updated to the Spire.Office. Once the Spire.Office including the fix. I’ll inform you in time.

Sincerely
Abel
E-iceblue support team