CTRL + D and CTRL + R not copying formulas

Posted by: mwyatt on 1 October 2021, 1:32 pm EST

    • Post Options:
    • Link

    Posted 1 October 2021, 1:32 pm EST

    If I copy and paste a cell that contains a Formula, the formula is copied as expected but if I use CTRL + D or CTRL + R, the value of the formula in the cell is what is copied as text but not the formula itself

  • Posted 4 October 2021, 5:08 am EST

    Hi,

    SpreadJS does not provide the ctrl+D and ctrl+r shortcuts but you could create the customCommand for the same. Please refer to the following sample that demonstrates how we could create these shortcuts and let me know if you face any issues.

    sample: https://codesandbox.io/s/friendly-snyder-3miqq?file=/index.html

    Regards

    Avinash

  • Posted 8 October 2021, 10:40 am EST

    Hello Avinash.

    Thank you for your response.

    We are using SpreadJS v14.2 and Crtl + D and Ctrl + R is showing as part of that

    https://www.grapecity.com/spreadjs/docs/v14/online/keyboard.html#i-heading-additional-keyboard-shortcuts

    Just a bit confused. Sorry.

  • Posted 11 October 2021, 6:37 am EST - Updated 3 October 2022, 9:07 am EST

    Hi,

    Thanks for the information but we are unable to replicate the issue at our end. We have used shortcutkeyExtension project and it worked as expected. Please refer to the following gif of observation and attached and let me know if we missed any steps.

    Regards

    Avinash

    SpreadJS.Shortcuts.Extension.14.2.0.zip

  • Posted 12 October 2021, 10:22 am EST

    Hello Avinash,

    When doing what you are showing above (highlighting the cell with the formula and then dragging to where they want ctrl r and ctrl d) this is indeed working.

    Where we are seeing the issue is when you are just in the cell to the right or the cell below the formula you want and press ctrl r or ctrl d, it should also copy the formula like Excel but that is still just copying a static number

    Thank you

  • Posted 13 October 2021, 7:43 am EST

    Hello,

    Thanks for the information. we are able to replicate the issue at our end hence we have escalated the issue to the concerned team for further investigation. We will update you regarding this issue as we get any information from the team. The internal ID for this issue will be SJS-10360.

    Regards,

    Avinash

  • Posted 10 August 2022, 8:54 am EST

    hi,

    Any update on above issue. Still facing this in v15

  • Posted 10 August 2022, 8:57 am EST

    HI,

    The mentioned issue has been fixed in the latest version that 15.1.4. Please update and let me know if you still face any issues.

    Regards,

    Avinash

  • Posted 12 August 2022, 7:22 am EST

    hi,

    still facing this issue.

  • Posted 17 August 2022, 1:40 am EST

    Hi,

    We are sorry but we are unable to replicate the issue on our end. We have tested the following attached shortcut build and it worked (hitting ctrl+d is filling the formulas)

    Regards,

    Avinash

    SpreadJS.Shortcuts.Extension.15.0.3.zip

Need extra support?

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

Learn More

Forum Channels