One Excel sheet protection setting is unchecked after saving

One Excel sheet protection setting is unchecked after saving

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

• 

  yyoshimura

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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[img]https://gccontent.blob.core.windows.net/forum-uploads/file-f2379cc8-ba31-46e7-9dc8-622066b1fad2.png[/img]

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 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.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 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.

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 6 January 2022, 6:55 pm EST

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

  Regards