I use ComHelper in classic asp to open XLSX and later save as XLS. When saving as XLS the formulas that were in the original file are lost (replaced with 0). Is this a bug? Is there any way around this?
Hi,
Are you looking at the ExcelFile.Formula or ExcelFile.Value property?
Is it possible that you need to recalculate the workbook?
Nevertheless, can you please send us your XLSX file and the snippet code that reproduces your issue?
Regards,
Mario
This issue is now resolved in the current latest bugfix version:
https://www.gemboxsoftware.com/spreadsheet/nightlybuilds/GBS49v1601Framework.zip
Regards,
Mario