Posted 8 September 2017, 1:09 am ESTIs there any way to specify a Paste Option (All, Values, Formatting, Formulas) when pasting from the clipboard? Below are the methods I have tried to use and the reason why they didn't seem to work for this particular application:
- GC.Spread.Sheets.Commands.copy - Successfully pasted fields contained in clipboard, but doesn't appear to provide any Paste Options.
- GC.Spread.Sheets.Commands.clipboardPaste - Provides Paste Options but doesn't appear to provide the ability to set the clipboard as your copyFrom location.
- instance.copyTo - Same issue as clipboardPaste method.
I'm hoping that there may be a different method that would allow us to paste content with a specific Paste Option from the clipboard or perhaps something I'm missing in one of the methods listed above.