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

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

  • 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
  • Replied 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.
  • Replied 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
  • Replied 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
  • Replied 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
  • Replied 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
  • Replied 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
  • Replied 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.
  • Replied 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
Need extra support?

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

Learn More

Forum Channels