Can the cell type be defined independent of the column in pe:sheet?

Question

I am prototyping with pe:sheet to represent different type of cells within a sheet. However my requirements are to have different cell types within one column. Is there a possibility to do this with pe:sheet?

I have a successful prototype using what was written down in the pe:sheet showcase. I can use the component and have different cell types based on the column type definition.

I would like to define individual cell type instead of column type.

Answer 1

Unfortunately I believe this is a limitation of the underlying Handsontable where the cell type is defined at the column level.

https://handsontable.com/docs/7.0.0/demo-numeric.html

There may be a way to do it with raw Handsontable but I am not aware of such a way but it may exist. But I can definitively say it cannot be done with the current pe:sheet.