ExcelSaveFlags.SaveAsViewed spread 15 too much handle

ExcelSaveFlags.SaveAsViewed spread 15 too much handle

Posted by: danilo.mario on 25 September 2024, 2:38 am EST

• 

  danilo.mario

  • Post Options:
  • Link
    Copy

  Posted 25 September 2024, 2:38 am EST

  I have a list with 53 sheets
  
  when i saved in excel spread create 10000 handle in windows and the program crash
  
  If i use ExcelSaveFlags.Dataonly all run correctly
  
  Visual basic Visual Studio 2022
  
  Spread version 15.0.20211.0

• 

  nitin.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 26 September 2024, 8:02 am EST

  Hi,

  We are unable to replicate this issue at our end. Could you please provide a stripped sample? So, we can investigate this issue and assist you better.

  Regards,
  
  Nitin

• 

  ramona.arnoldi

  • Post Options:
  • Link
    Copy

  Posted 26 September 2024, 8:18 am EST

  the attachment list when running have 52 sheets like sheet(1)

  [code]
  
  Try

                      Lista.SaveExcel(Nomefile, FarPoint.Excel.ExcelSaveFlags.SaveCustomColumnHeaders Or FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat Or FarPoint.Excel.ExcelSaveFlags.DataOnly)
                  
                  Catch ex As Exception
  
                     
                  End Try
  

  [/code]

• 

  nitin.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 27 September 2024, 5:23 am EST - Updated 27 September 2024, 5:35 am EST

  Hi,

  We apologize for the inconvenience. We are still unable to replicate the issue at our end. Please refer to the attached working sample containing your code to save as Excel file with 53 Sheets: SpreadVB.zip
  
  Is there anything you are doing with Spread, that causing this issue? You can update the attached sample to replicate this behavior and send it back to us. So, that we can replicate this issue and assist you accordingly.

  Regards,
  
  Nitin