Is there a way to set a workbook to read-only?

4 posts, 0 answers
  1. Chanan Zass
    Chanan Zass avatar
    63 posts
    Member since:
    Aug 2012

    Posted 21 Sep 2018 Link to this post

    We're looking for a simple way to turn a workbook to read-only.

    Since the workbook includes some 11 sheets, each with a different number of rows and columns we cannot use the spreadsheet range setting (range.set_enabled(false)).

    We tried using the workbook.Protected parameter in code-behind, but the "Protected" parameter is somehow not accepted.

    Any tips would be appreciated.

  2. Peter Milchev
    Admin
    Peter Milchev avatar
    661 posts

    Posted 21 Sep 2018 Link to this post

    Hello Chanan,

    Please check the following KB that describes the same scenario: Load Excel file into a read-only Spreadsheet.

    Regards,
    Peter Milchev
    Progress Telerik
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
  3. Chanan Zass
    Chanan Zass avatar
    63 posts
    Member since:
    Aug 2012

    Posted 21 Sep 2018 in reply to Peter Milchev Link to this post

    Thanks again, Peter.

    We'll try this and be back to you.

  4. Chanan Zass
    Chanan Zass avatar
    63 posts
    Member since:
    Aug 2012

    Posted 22 Sep 2018 in reply to Chanan Zass Link to this post

    This works properly with "normal" Excel files (we tested it with a large file).

    However, in our case, with our non-standard file, it doesn't. We can still double-click a cell and edit its content.

    No big deal, actually, as we do not offer any possibility of saving the file. If required to export, we'll export the original (unedited) file.

    Thanks again.

     

Back to Top