Read only or write protect for the cell

Questions and answers on how to use XLSSpreadSheet.
Post Reply
MaxChan
Posts: 19
Joined: Sat Sep 03, 2016 6:38 am

Read only or write protect for the cell

Post by MaxChan »

Dear Axolot,

How to make the cell readonly or write protect? Not allow user to change the value of specif cell.

best regards,
Max
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Read only or write protect for the cell

Post by larsa »

Hello

Use the OnEditorOpen event. This is fired when the inplace editor is opened.

Example

Code: Select all

  if (FXSS.XLSSheet.SelectedAreas.First.Col1 = 2) and (FXSS.XLSSheet.SelectedAreas.First.Row1 = 2) then
    Value := False;
Lars Arvidsson, Axolot Data
MaxChan
Posts: 19
Joined: Sat Sep 03, 2016 6:38 am

Re: Read only or write protect for the cell

Post by MaxChan »

Got it, Thank you very much!
Post Reply