Can we make cell read-only conditionally?

[sankarkumar23]

Can we make a cell read-only conditionally?

[anmcgrath]

Hey @sankarkumar23 not 100% sure what you mean by conditionally?

You should be able to do something like this:

Sheet.Cells[0, 0].Format.IsReadOnly = true;

[sankarkumar23]

Format.IsReadOnly did not work. I am still able to modify the cell
it worked with
Sheet.Cells[rowIndex, 1].Format = new CellFormat() { IsReadOnly = true, BackgroundColor = "#f8f9fa" };

[anmcgrath]

I'll have a look at why my suggestion didn't work, but glad you found a solution.

I saw your previous edit, if you want to conditionally limit the ability to edit cells you can do something like this:

        Sheet.Editor.BeforeCellEdit += (sender, args) =>
        {
            if (args.Cell.ValueType == CellValueType.Number)
            {
                if (args.Cell.GetValue<double>() > 0)
                    args.CancelEdit = true;
            }
        };