SaveExcel: File corrupted

SaveExcel: File corrupted

Posted by: mehar.rehill on 11 August 2021, 4:57 am EST

• 

  mehar.rehill

  • Post Options:
  • Link
    Copy

  Posted 11 August 2021, 4:57 am EST - Updated 30 September 2022, 5:38 am EST

  Cannot save macro enabled excel file without corruption. Using 14.45.20213.0.
  
  Originally tried version 11 but the issue isn’t resolved using different version.
  
  

  

  906×146 4.36 KB

• 

  avnish.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 11 August 2021, 4:46 pm EST

  Hi,

  Spread Windows Forms has very limited support for XLSM. The XLSM support is limited to importing the macro content (including all unsupported content in the workbook like pivot tables, VBA content, macros, etc.) and caching it in memory for later exporting to XLSM (possibly with some changes that you have made using the Spread API). Spread cannot return any of the macro content from the API.

  You need to use the DocumentCaching ExcelOpenFlags and ExcelSaveFlags for macros to be preserved while opening and saving Excel.
  
  Please make sure you used it while opening and saving the file and if the issue still persists, please share the excel file so that we can investigate it further at our end.

  https://www.grapecity.com/spreadnet/docs/v14/online-win/FarPoint.Excel~FarPoint.Excel.ExcelOpenFlags.html?highlight=documentcaching%2C

  https://www.grapecity.com/spreadnet/docs/v14/online-win/FarPoint.Excel~FarPoint.Excel.ExcelSaveFlags.html?highlight=documentcaching%2C

  Regards,
  
  Avnish