How do i know which column refer when apply formula refer to that column

Tags: #<Tag:0x00007fee2a66e4f8>

We are trying to implement remove column functionality where we cannot remove those columns that have a date or refer to a formula in handsontable.

Hi @siddhantjain15298

First of all you’d need to create a custom context menu option. Then you can set up a condition based on the cell meta. Example

if(instance.getCellMeta(row, column).type !== 'date'){
//alter() to remove a column

When it comes to the formulas, I’d need to know more cause as I suppose you do not mean formula cells (that can be checked by using slice() on the first element, which is a =).

I think that we can close this thread as there are no additional questions.