disable dropdowns on spread viewer

Posted by: jacob.mendenhall on 17 September 2019, 1:19 am EST

  • Posted 17 September 2019, 1:19 am EST

    I am having an issue with making drop-down boxes "read only", I am looping through each cell on each sheet and locking it but the drop-down cells aren't getting locked.

    I'm locking cells this way:

    foreach (var s in this.Sheets)
    {
    if (s != null)
    {
    s.Protect = true;
    this.Protect = true;
    for (var row = 0; row < s.Rows.Count; row++)
    {
    for (var column = 0; column < s.Columns.Count; column++)
    {
    s.Cells[row, column].Locked = true;
    }
    }
    }
    }

  • Replied 18 September 2019, 7:47 pm EST

    Hello,

    I am able to reproduce the issue at our end. I will escalate the issue to our development team(275911) and inform you once I get any reply from them.

    Thanks.
  • Replied 17 September 2019, 11:36 pm EST

    okay, thank you
Need extra support?

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

Learn More

Forum Channels