Pasting a formula across workbooks only pastes value and not formula

Posted by: mwyatt on 8 June 2021, 5:41 am EST

  • Posted 8 June 2021, 5:41 am EST

    Used Ctrl + C → Ctrl + V to paste a formula from one workbook to another. In Excel it pastes the formula, in SpreadJS it pastes the actual value of the formula.

    Can this be fixed to match Excel?
  • Replied 8 June 2021, 9:32 pm EST

    Hi,

    Pasting among the different workbooks is currently not supported with SpreadJS because of the limited access to the clipboard.

    Excel desktop has the access to the internal clipboard and they share the same clipboard among the different workbooks that are for formula is got pasted properly.

    Excel 365 online paste action is performed as a serverside action because of that it is able to paste the formula correctly.

    Hope this clarifies the issue. Please let me know if you have further queries regarding this case.

    Regards
    Avinash
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels