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
Forums Home / Spread / SpreadJS
Posted by: mwyatt on 1 October 2021, 1:32 pm EST
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
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