Posted 21 November 2022, 2:49 pm EST
On my application, user can Cut/Copy cell and paste to another cell.
I’m using default options of SpreadJS, so all data objects (including values, formatting, and formulas) is pasted.
But i want to paste only value, so i setting:
sheetInitData.options.clipBoardOptions = GC.Spread.Sheets.ClipboardPasteOptions.values;
After that, Copy/Paste is working well. But Cut/Paste is still paste formula & formatting.
Do you have any option to prevent Cut/Paste formula & formatting ?
If not, please suggest to me how to customize Cut/Paste to prevent it ?