Page 1 of 1

Read only or write protect for the cell

Posted: Thu Jan 12, 2017 10:47 am
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

Re: Read only or write protect for the cell

Posted: Mon Jan 16, 2017 8:20 am
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;

Re: Read only or write protect for the cell

Posted: Mon Jan 16, 2017 8:48 am
by MaxChan
Got it, Thank you very much!