Was support for XLS files removed in .NET 6 "C1FlexGrid.SaveExcel"?

Posted by: wknauf on 19 February 2022, 11:35 pm EST

    • Post Options:
    • Link

    Posted 19 February 2022, 11:35 pm EST

    Hi C1,

    could you confirm this? It seems “C1FlexGrid.SaveExcel” does not support creating “XLS” files in the .NET 6 versions any more?

    This is OK for me, I just need the confirmation.

    Is there any comparisons between the different versions? I also noticed that “C1.Win.C1FlexGrid.IC1EmbeddedEditor” was changed to “C1.Win.IEmbeddedEditor”.

    Best regards

    Wolfgang

  • Posted 20 February 2022, 12:14 am EST

    The “SaveExcel” does not complain if the target file has the extension “.xls” - it just created an “.xslx” file anyway, which results in an excel error when opening it. So I suggest to add some check to prevent this error.

  • Posted 20 February 2022, 8:08 pm EST

    Hi,

    We have escalated the issue to the development to get their insights on it. We will let you know as soon as we have an update.

    As per the method comment, C1.Win.C1FlexGrid.IC1EmbeddedEditor is now deprecated and you can use C1.Win.IEmbeddedEditor instead. We are also getting in touch with the development to get information on the changes and will let you know as soon as we have an update.

    [C1WIN-26838] [C1WIN-26837]

    Regards.

    Avnish

  • Posted 24 February 2022, 9:13 pm EST

    Hi Wolfgang,

    As per the development team, .NET 6 C1FlexGrid only supports exports to XLSX excel files. Even if you provide any other file extension in the SaveExcel method, it will be saved in xlsx format.

    Regards

    Avnish

  • Posted 24 February 2022, 9:34 pm EST

    OK. But you should raise an error if an extension “xls” is specified, as excel refuses to open such a file.

    The list of changes in the .NET6 version is still underway?

    Best regards

    Wolfgang

  • Posted 27 February 2022, 2:35 pm EST

    Hi Wolfgang,

    We have forwarded your feedback to the development team regarding the XLS saving behavior.

    We have asked the development team for an update regarding the NET6 changes. We will let you know as soon as we get any information.

    Regards

    Avnish

  • Posted 27 February 2022, 7:58 pm EST

    Hi Wolfgang,

    As per the development team, You can refer to the NET5 and NET6 changelog and you will find all the breaking changes.

    Some of the major changes provided by the development team are as follows:

    • Marked the IC1EmbeddedEditor interface as obsolete, use the IEmbeddedEditor interface instead
    • C1Icon is used for glyphs instead of images.
    • Excel export uses Grapecity.Documents.Excel library instead of C1.C1Excel.

    Regards

    Avnish

  • Posted 2 August 2022, 7:13 am EST

    Could you please tell me where this was listed in the change log? I’m looking at all versions posted here https://www.grapecity.com/componentone/docs/win/online-releasehistory/releasehistory.html and I can’t find anything that matches what you have.

  • Posted 4 August 2022, 3:11 am EST

    Hi,

    The changes we mentioned were breaking changes in the NET5 and were included in the NET5 changelog that was included with the release. We have attached the changelog since NET5 controls are in maintenance mode and will not be included starting the 22v2 release.

    We were able to see that the changes are not included on the online release history and have notified the concerned team and they will update it as soon as possible.

    Regards

    Avnish

    C1NET5Changeloh.zip

  • Posted 19 December 2022, 4:24 pm EST

    Hi,

    The development team has included the NET5 changes in the NET6 changelog. Please refer to the updated changelog in the 22v3 release.

    Regards

    Avnish

  • Posted 5 July 2023, 9:16 pm EST - Updated 5 July 2023, 9:47 pm EST

    Just for the records: support for XLS was reintroduced by .603 (and caused a bit of trouble for me, because I had to add the code again that applies “FileFlags.OpenXml” to “C1FlexGrid.SaveGridExcel (Stream, …)” when creating XLSX files).

    Best regards

    Wolfgang

  • Posted 6 July 2023, 6:42 pm EST

    Hello Wolfgang,

    Apologies for the inconvenience casued.

    Actually, the XLS support has been added in the 2023v1HF builds for backward compatibility.

    Regards,

    Prabhat Sharma.

Need extra support?

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

Learn More

Forum Channels