Copy Paste formulas from/to Google Spreadsheet

Copy Paste formulas from/to Google Spreadsheet

Posted by: k.szabariova on 23 August 2021, 3:59 am EST

• 

  k.szabariova

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 23 August 2021, 3:59 am EST

  Hello, user would like to be able to migrate an Excel and GoogleSheet tables (or selections of cells) into SpreadJS. These tables contain formulas, which don’t get copied.
  
  For example if cell in Google Spreadsheet is ‘=5+5’, what is copied is just a result number (10), not the formula itself. Same goes for formulas such as =SUM().
  
  I tried using clipBoardOptions but it seems to only affect copying between SpreadJS sheet’s, not between different products.

  How do I enable copying & pasting formulas between SpreadJS and Google Sheets / Excel?

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 24 August 2021, 6:26 am EST

  Hi,

  That is by design, the cell attributes like formulas take effect when pasting action executing. And it only takes effect on the internal pasting behavior,

  for example

  1.Copy A1’s cell in SJS workbook

  Result:

  Internal Copy marked A1 as the copied source range.
  
  The A1’s text will be set to external clipboard.
  
  2. Paste in workbook1.

  Result:

  Handled as internal paste, and clipboard options take effect, the A1’s value “0” will be pasted into the target range.

  3. Paste outside, like a notepad or excel or another workbook or google sheets.

  Result:

  Handled as an external paste, the system’s clipboard content will be pasted to target. the content in the system’s clipboard came from Step1 that is nothing but text. and at this time.

  That is the reason when copying the formula from google sheets and pasting outside of the google sheets pasted only the text

  You may also try this with excel and google sheet.

  Hope this clarifies the issue.

  Regards
  
  Avinash