Enabling/Disabling cells dynamically

Getting help Questions
1

Hi,
I have a requirement that needs to enable/disable certain columns based on content of a column.
I achieved it by creating a custom renderer. It works fine on manual cell edit, But it fails on pasting data from excel. Kindly refer the attached link JSFiddle for demo.
Do you guys have any suggestion on how to solve this issue.

Requirement:

  1. If column A has value then columns B and C should be disabled and empty.
  2. If column B or C has value then column A should be disabled and empty.

Problem Faced:
Cell is disabled after the data is pasted.

2

Hi @alikhodja

I think that the beforePaste callback will come in handy in this situation. However, the following callback has been added in version 1.9.1 so you would need to update the code (I can see that you’ve been using the v1.5.0 in the example attached).
The logic for the callback should be very similar to what you are currently set for the renderer.