Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Fri Jan 13, 2023 10:43 am

Hi,

Thank you very much for replying to my question!
I load from excel file then export pdf file, everything is normal if I don't set orientation to vertical. It will get stuck at the SaveToFile command, causing the memory to overflow.
Code: Select all
  Workbook workbook = new Workbook();
  workbook.LoadTemplateFromFile(pPath);
  MemoryStream stream = new MemoryStream();
  workbook.SaveToStream(stream);
  Workbook wbExport = new Workbook();
  wbExport.LoadFromStream(stream);
  wbExport.CalculateAllValue();
  wbExport.SaveToFile(strReportPath, Spire.Xls.FileFormat.PDF);

info Spire.Xls:
<Name>Spire.XLS Pro Edition</Name>
<Version>11.8</Version>

truongpq
 
Posts: 3
Joined: Fri Jan 13, 2023 9:31 am

Mon Jan 16, 2023 8:57 am

Hi,

Thanks for your inquiry.
Could you please provide us the following messages to help us do a further investigation? You can send them to us via email (support@e-iceblue.com) or attach them here, thanks for your assistance.
1) your full code and input file that can reproduce your issue.
2) your application type, such as Console App .NET Framework 4.8.
3) your test environment, such as OS info (E.g., Windows 10 64 bit) and device’s memory.

Sincerely,
Triste
E-iceblue support team
User avatar

Triste.Dai
 
Posts: 999
Joined: Tue Nov 15, 2022 3:59 am

Tue Jan 17, 2023 10:24 am

Thanks for your spec request!
Spec:
1) Your full code and input file that can reproduce your issue:
code:
Code: Select all
       /// <summary>
        /// Report template
        /// </summary>         
        /// <param name="pPath">path file</param>
        /// <param name="pObjReportReq"></param>
        /// <returns>true</returns>
        private async Task<string> ExportPdfTemp(string pPath, ReportExportDTO pObjReportReq)
        {
            string strReportPath = string.Empty;

            if (File.Exists(pPath))
            {
                _Worksheet = null;
                Workbook workbook = new Workbook();
                // path file: BUG-0228-02-Suginami-ku_NG.xlsx
                workbook.LoadTemplateFromFile(pPath);
                MemoryStream stream = new MemoryStream();
                workbook.SaveToStream(stream);
                workbook.Dispose();
                Workbook wbExport = new Workbook();
                wbExport.LoadFromStream(stream);
                stream.Flush();
                stream.Dispose();
               
                // export pdf
                strReportPath = $"{strPathExportPdf}/Template12_{DateTime.Now.Ticks}.pdf";
                wbExport.CalculateAllValue();
                wbExport.SaveToFile(strReportPath, Spire.Xls.FileFormat.PDF);
            }
            return strReportPath;
        }

input file:
File: BUG-0228-02-Suginami-ku_NG.xlsx
(position error: AY56, BA56, BA71, BA90, BA106 orientation to vertical).
Spec:
2) Your application type, such as Console App .NET Framework 4.8:
Application type: Console Application.
Target framework: .Net Core 3.1.
Spec:
3) Your test environment, such as OS info (E.g., Windows 10 64 bit) and device’s memory:
Environment: Windows 10 64 bit, Intel(R) Core(TM) i3-9100 CPU, 16.0 GB RAM.
Attachments
BUG-0228-02-Suginami-ku_NG.zip
(107.55 KiB) Downloaded 157 times

truongpq
 
Posts: 3
Joined: Fri Jan 13, 2023 9:31 am

Wed Jan 18, 2023 10:25 am

Hi,

Thanks for your inquiry.
I did a test with your xlsx file and code, I reproduced the issue you mentioned, I have logged this issue into our bug tracking system with the ticket number SPIREXLS-4420, our developers will investigate and fix it, sorry for the inconvenience caused. Once the issue is fixed, I will inform you asap.

Sincerely,
Triste
E-iceblue support team
User avatar

Triste.Dai
 
Posts: 999
Joined: Tue Nov 15, 2022 3:59 am

Thu Jan 19, 2023 1:45 am

Thanks for the support!

Sorry can you tell me, how can i track the SPIREXLS-4420 ticket?

truongpq
 
Posts: 3
Joined: Fri Jan 13, 2023 9:31 am

Thu Jan 19, 2023 6:36 am

Hi,

Thanks for your inquiry.
We don't have the status of the issue in public, it's just an internal system. Our development team has started investigating this issue. Once there is any important update, I’ll inform you in time.

Sincerely,
Triste
E-iceblue support team
User avatar

Triste.Dai
 
Posts: 999
Joined: Tue Nov 15, 2022 3:59 am

Fri Feb 17, 2023 4:46 am

Hi,

Thanks for your patience!
Glad to inform you that we just released Spire.XLS 13.2.4 which fixes the issue with SPIREXLS-4420.
Please download the new version from the following links to test.
Website download link: https://www.e-iceblue.com/Download/download-excel-for-net-now.html
Nuget download link: https://www.nuget.org/packages/Spire.XLS/13.2.4

Sincerely,
Triste
E-iceblue support team
User avatar

Triste.Dai
 
Posts: 999
Joined: Tue Nov 15, 2022 3:59 am

Return to Spire.XLS