Disable dropdowns on spread viewer

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

  • Posted 17 September 2019, 10:19 am EST - Updated 29 September 2022, 3:08 pm 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;

    }

    }

    }

    }

  • Posted 18 September 2019, 8:36 am EST

    okay, thank you

  • Posted 19 September 2019, 4:47 am 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.

Need extra support?

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

Learn More

Forum Channels