Looks like undo/redo plugin works with cell values, but not cell meta data.
If I run the following:
hot.setDataAtCell(0, 0, 1);
hot.setCellMetaObject(0, 0, {
type: "numeric",
numericFormat: { pattern: "$0,0.00", culture: "en-US" }
});
hot.render();
hot.undo();
I would expect the undo
action to revert my last operation (revert the cell type from numeric
to text
), but instead it removes the cell value but keeps the cell type as numeric.
I tried the same sequence in Excel and Google Sheets and both have this behaviour.