Cut/Paste without formula & formatting

Cut/Paste without formula & formatting

Posted by: ngocnguyen09910060 on 21 November 2022, 2:49 pm EST

• 

  ngocnguyen09910060

  • Post Options:
  • Link
    Copy

  Posted 21 November 2022, 2:49 pm EST

  Hi teams,

  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 ?

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 22 November 2022, 3:49 pm EST

  Hi,

  You can change sheet.options.clipBoardOptions property to only values so that only values are pasted.

  You can create a custom command that only pastes values from the source range to the target range when pasting after a cut operation. The source range, target range, source sheet, and other information can be found in the arguments of ClipboardPasting Event. You can override the default behavior by setting the cancel property of handler args to true and using command manager to execute your custom command instead.

  Please refer to the following sample that I have created for you: https://jscodemine.grapecity.com/share/DSaU3iSKgk2fsNwRIjAC3Q/

  References:

  ClipboardPasting Event: https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Sheets.Events#clipboardpasting

  CommandManager register method: https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Commands.CommandManager#register

  CommandManager execute method: https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Commands.CommandManager#execute

  Regards,

  Ankit

• 

  ngocnguyen09910060

  • Post Options:
  • Link
    Copy

  Posted 22 November 2022, 9:43 pm EST

  Hi ankit.kumar,

  On your sample:

  1. Select D3:D4 and press Ctrl + X => Dash line is displayed on D3:D4.
  2. Select E3 and press Ctrl + V => Data in D3:D4 is cleared but dash line is still displayed.
  3. Select F3 and press Ctrl + V => Dash line is removed.

  => I want to remove dash line at step 2. How can i do it ?

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 27 November 2022, 2:52 pm EST

  Hi,

  To cancel the input and clear the cut/copy indicator, use the ‘cancelInput’ command. Please see the modified sample below.

  Sample: https://jscodemine.grapecity.com/share/F9RKpDBhg0iDOvLt9iZTvA/

  References:

  cancelInput command: https://www.grapecity.com/spreadjs/api/modules/GC.Spread.Sheets.Commands#cancelinput

  setSelection method: https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Sheets.Worksheet#setselection

  Regards,

  Ankit