restrict users from copying data from farpoint excel.

Posted by: lier on 8 September 2017, 2:07 pm EST

  • Posted 8 September 2017, 2:07 pm EST

    <P>hii,</P>
    <P> i need to restrict users from copying data from farpoint excel. i am using the operatinal mode as read only and loked the cell but still  user can copy the data.</P>
    <P>kindly help!!</P>
  • Replied 8 September 2017, 2:07 pm EST

    <P>Hello Liar,</P>
    <P>To restrict the user form copying data from fpSpread, you can set</P>
    <P>fpSpread1.SelectionBlockOptions = FarPoint.Win.Spread.SelectionBlockOptions.None;<BR>fpSpread1.ActiveSheet.OperationMode = FarPoint.Win.Spread.OperationMode.ReadOnly;</P>
    <P>Hope this will help.</P>
    <P>Thanks,</P>
Need extra support?

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

Learn More

Forum Channels