One Excel sheet protection setting is unchecked after saving

Posted by: yyoshimura on 1 December 2021, 7:19 pm EST

  • Posted 1 December 2021, 7:19 pm EST

    Hi,

    We have got a sheet which is protected with all settings on and we found that one protection setting(Allow formatting rows) is unchecked after saving the workbook with the library so we cannot show/hide rows with the saved book. Please refer attachment for reproduction. We are using the latest version of library.

    Please help to investigate this issue.
    Thank you.

    Regardsgcexcelperformance.zip
  • Replied 2 December 2021, 8:20 pm EST

    Hello,

    Thank you for reporting this issue.
    We too can observe the issue and escalated this to the development team for investigation. We will let you know as soon as we get any update on this from their end.
    [Internal Tracking ID: DOCXLS-5213]

    Regards,
    Prabhat Sharma.
  • Marked as Answer

    Replied 28 December 2021, 10:16 pm EST

    Hello,
    This issue has been fixed in the latest update of GcExcel 5.0.1. Please update your project to resolve this issue:

    https://www.nuget.org/packages/GrapeCity.Documents.Excel/
    Regards,
    Prabhat Sharma.
  • Replied 6 January 2022, 6:55 pm EST

    We can see that issue is resolved in latest version. Thank you for your support!

    Regards
Need extra support?

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

Learn More

Forum Channels