Disallow cell editing conditionally

posted on August 9th, 2021

Answered

Akshay Alva asked on August 9, 2021

Hi,

Is there any way to disallow editing of a cell conditionally when the "editing: true" option is enabled.
For example, we want to disallow :

if the value of the cell is a text field
if the cell is representing a year
if the cell value (measure) belongs to a historic data (for ex: May-2021 data)

Thanks in advance.

3 answers

Public

Vera Didenko ⋅ Flexmonster ⋅ August 10, 2021

Hello,

Thank you for your question.

Currently, it is only possible to enable/disable editing for all cells at the same time.
Flexmonster is a tool for a visual representation of the existing data; therefore, it doesn't focus on editing the underlying data set.

Feel free to reach out should other questions arise.

Kind regards,
Vera

Public

Akshay Alva ⋅ August 10, 2021

Hi Vera,

Thanks for your response. An additional question, since calculated total values (row and column totals) are not editable by default, is there a way to color code/highlight these fields so there is a clear differentiation to the user on the editable and non-editable fields in the table?

Warm Regards,
Akshay

Public

Vera Didenko ⋅ Flexmonster ⋅ August 10, 2021

Hello, Akshay,

Thank you for your reply.

Yes, you can add additional CSS styles to specific cells.

Depending on your use case, there are two approaches:

Adding styles by modifying existing elements via CSS:
Here is a JSFiddle for illustration: https://jsfiddle.net/flexmonster/ef4f6ttj/
Adding additional CSS styles via the customizeCell hook:
Through customizeCell, you can get additional details about each cell in the Cell Data Object.
This way, you can add a background color to highlight certain cells based on their type, value, position on the grid, etc.

Please let us know if this helps. Also, could you please specify your data source type?

Thank you, and looking forward to your response.

Kind regards,
Vera

Disallow cell editing conditionally

3 answers

Please login or Register to Submit Answer