Error pasting multiple cells if locked cell is included

Posted by: grapecity on 24 August 2018, 6:25 am EST

    • Post Options:
    • Link

    Posted 24 August 2018, 6:25 am EST

    In changing from Spread.NET 10 to Spread.NET 11, we found some of our code broke with respect to pasting. If I select a row (by clicking on the row header) or any other range of cells, copy, and then paste, it works just fine. The exception is if one of the target cells- where the content should be pasted- is locked, in which case NONE of the copied values are pasted.

    This worked before we migrated to 11. Is there anything I can check or change to fix this?

  • Posted 27 August 2018, 9:01 pm EST

    Hi,

    This is the design behavior with v11, earlier locked cells allowed pasting values in it.

    Now if the pasting range has a locked cell the pasting will fail.

    Thanks,

    Deepak Sharma

Need extra support?

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

Learn More

Forum Channels