Cell.Locked property

Posted by: aonline-fp on 8 September 2017, 1:56 pm EST

  • Posted 8 September 2017, 1:56 pm EST

    Hello,

     

    When I do

    fpSpread.ActiveSheet.DefaultStyle.Locked=true;

    then all the cells are locked by default.

    But then, how can I check if a cell is indeed locked?

    Checking the property 'Locked' yields a 'false' result.

    The StyleName property is empty, and there are no NamedStyles in the sheet.

    If I set the property 'Locked' to false, then everything seems just the same, yet now the cell is indeed unlocked.

     

    So how to tell if a cell is locked or not?

     

     

    Thanks,

    -Roman

    A-Online development team

  • Replied 8 September 2017, 1:56 pm EST

    Roman,

    You may use the GetCompositeInfo method to get the style information as a composite of settings for the specified cell,
    column, row, or model default. The way to
    check which setting of the StyleModel property a cell is using, you
    can use the GetCompositeInfo method from the StyleModel.

     

    Thanks

  • Replied 8 September 2017, 1:56 pm EST

    Thanks!

     

Need extra support?

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

Learn More

Forum Channels