Posted 11 August 2021, 4:57 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.
SaveExcel: File corrupted
Posted by: mehar.rehill on 11 August 2021, 4:57 am EST
-
mehar.rehill
Originally tried version 11 but the issue isn't resolved using different version.
-
avnish.kumar
Replied 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
