Copy/Paste is failing somewhat randomly

Copy/Paste is failing somewhat randomly

Hi,

In recent times, my copy/pastes sometimes don't work. Most frustrating.

One consistent workaround is to log off from SmartSheet and then log on again and then immediately do the failed copy/paste.

It seems to be triggered by attempting to copy the value in row 1 down to every row in the sheet. Once triggered, even the copy from one cell to just one other also fails. But, it triggers on other attempts to copy/paste as well.

Is anybody else experiencing this behaviour? If so, do you have any other workarounds or fixes?

I am using Chrome 83.0.4103.97 (Official Build) (64-bit) on a MacBook Pro 8 core i9 32GB RAM running macOS 10.15.5 (Catalina), but this same behaviour is being exhibited on other Macs and on Windows.

Thanks

Rob.

Tagged:

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Rob,

    Strange!

    I haven't had any issues.

    Is it the same way in all sheets?

    If you haven’t already, I would also recommend that you reach out to the Smartsheet Support Team.

    I hope that helps!

    Be safe and have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Hi Andrée,

    Yes, it is the same in all of our production sheets. I have raised it with SmartSheet but have received no reply. I try again using the link that you provided.

    Cheers,

    Rob.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @Rob Hagan

    Happy to help!

    Let me know what you find out!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • ibib
    edited 06/30/20

    I'm experiencing the same issue.

    In the developer console it shows the following error:

    "net::ERR_CERT_AUTHORITY_INVALID

    app1_101.1.0.js:1 Uncaught TypeError: Cannot read property 'split' of null

      at GridDependencyManager.NPt (app1_101.1.0.js:1)

      at JscMegaGrid.dus (app1_101.1.0.js:1)

      at JscMegaGrid.wfs (app1_101.1.0.js:1)

      at BackgroundProcess.cycle (app1_101.1.0.js:1)

      at BackgroundProcess.kat (app1_101.1.0.js:1)

      at BackgroundProcessManager.startBackgroundProcess (app1_101.1.0.js:1)

      at <anonymous>:1:26"

  • I have the exactly same issue - tried on firefox and chrome - tried refreshing sheet - dragging the copy box works but not CTRL-V but dragging the formula down more than a few row is a tedious workaround when I need to perform on multiple sheets.

    Have any solutions come to light?

  • Hi all,

    You have no idea just how pleased we are (in a perverse way of course) that others in the community are experiencing the same issue. We thought that we were alone Down Under and that it was a fault in our configuration in some way.

    I hadn't tried dragging down - I guess because it is just so tedious over 1,000 rows. Well spotted IBRIEOG. Thanks ib for your debug info. SmartSheet support may obtain value from that.

    My workaround is to log off and log on again (as per the IT Crowd "Have you turned it off and on again").

    No solution has been communicated back to me, but I have successfully demonstrated the behaviour to a 2nd Level Support Technician so we may get some response soon.

    Chins up all who are afflicted!

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @Rob Hagan

    Thanks for the update!

    IT Crowd 🤣

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Hi there!

    I'm having exactly the same issue. Copy & paste within 1 sheet doesn't work randomly. It always happens if I try to copy & paste multiple cells. Log out and back in fix it but it is very annoying. Glad I'm not alone. If anyone knows how to fix it please let me know.

    Thank you much. :)

    Pavla

  • The two workarounds:

    • Log out and log in again (if you have a password vault or similar assistance then this can be quick)
    • Drag down (which can be tedious for large sheets)
Sign In or Register to comment.