Spread Windows Forms Save .xlsm(Macro Enabled)

Posted by: sivapolepalle on 27 May 2018, 11:52 pm EST

    • Post Options:
    • Link

    Posted 27 May 2018, 11:52 pm EST - Updated 30 September 2022, 5:01 am EST

    Hi

    We are saving file by using below code,

    if (Path.GetExtension(fileName) == “.xlsm”)

    {

    SaveExcel(fileName, FarPoint.Excel.ExcelSaveFlags.DocumentCaching | FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat);

    }

    else

    {

    SaveExcel(fileName, FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat);

    }

    With this code, “.xlsx” files we did not find any issues, but for “.xlsm” we are having problem like if we try to open saved file it is throwing below message. Could you please tell me how can i fix this issue.

    Thanks

    Siva

  • Posted 28 May 2018, 7:35 pm EST

    Hello,

    With the latest version of Spread .NET , the following code works fine to save the xlsm file:

    
    string f;
                f = System.IO.Directory.GetCurrentDirectory() + @"\..\..\empty1.xlsm";
                fpSpread1.SaveExcel(f, FarPoint.Excel.ExcelSaveFlags.DocumentCaching | FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat);
    
    
    

    The error message is shown when the file is opened in Excel, after you click the “Yes” button on the error message it shows, the whole content can show normally.

    I will check with the development team if this behavior can be avoided. Tracking id for this issue is #249862.

    I hope it helps!

    Thanks,

    Deepak Sharma

  • Posted 28 May 2018, 8:53 pm EST - Updated 30 September 2022, 5:01 am EST

    Hi Deepak

    After clicking “Yes” it will again pop up below msg and it is removing comments for few of the cells. We required comments part in our application. Please suggest us way to fix this issue ASAP.

    Thanks

    Siva

  • Posted 30 May 2018, 2:41 pm EST

    Hi Siva,

    This has been identified as a bug and will be fixed in our next Service pack of Spread .NET.

    Thanks,

    Deepak Sharma

  • Posted 30 May 2018, 3:48 pm EST

    Thanks for the update Deepak,

    Could you please let me know approximately how long will it take to get this service pack?

    As we need to deliver major functionality of our product.

    Thanks

    Siva

  • Posted 31 May 2018, 10:36 pm EST

    Hi Siva,

    The next service pack is scheduled to be released in mid July 2018.

    Thanks,

    Deepak Sharma

  • Posted 21 June 2018, 5:40 pm EST

    Hello,

    Please test the issue with the latest build here:

    https://cdn.grapecity.com/SpreadNET/installer/current/offlineDownload_Full.zip

    In case the issue still persists, please provide us your xlsm file for further testing.

    Thanks,

    Deepak Sharma

  • Posted 30 December 2018, 8:01 pm EST - Updated 30 September 2022, 5:02 am EST

    Hi Deepak,

    We have used latest build now below error message not shown for repair that’s good . But there is another issue its completely removing comments from the excel sheet.

    Thanks,

    Srikanth.

  • Posted 30 December 2018, 8:22 pm EST

    Hi Deepak,

    I have attached .xlsm.

    SaveExcel(fileName, FarPoint.Excel.ExcelSaveFlags.DocumentCaching | FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat);

    on save of excel removing comments.

    Thanks

    Srikanth.

  • Posted 14 January 2019, 10:16 pm EST

    Hello,

    This bug is fixed for latest version of Spread i.e. v12, you can download the build from:

    https://cdn.grapecity.com/SpreadNET/installer/12.0.20181.0/offlineDownload_Full.zip

    Thanks,

    Deepak Sharma

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels