Mouse can't click into cells or right click

Robert K

Hi all, please see my picture

I have been using my keyboard to type into cells, because my mouse can't click on a cell. I also can't use my right click button.

I am the owner of all these sheets - my sub-users have no issues.

I've tried on mutliple computers - only my account doesn't work.

Thank you

a2.jpg

Georgie

Hi @Robert K,

Thank you for bringing this to our attention! We've determined that cells/sheets being unresponsive when sheets are opened is caused by a bug and our Product team is working on a resolution. We are not able to provide a time-frame on how long the resolution could take but we are doing our best in order to have this fixed as soon as possible. In the meantime, you should find that refreshing the page or switching to another view (such as Table view) allows you to click on cells and enter data.

 Thanks,

Georgie

SSFeatures

Hi @Georgie,

I figured out why this bug is happening, while developing some new features for SSFeatures.

The problem happens if the user clicks the page when the "loading…" or "saving your data…" popup is open. If you click when this little popup is open, then the entire page breaks, and it's impossible to click your cells, or click many of the other buttons on the page.

I can reproduce this 100% of the time, here's what I do.

1. Change some data in a cell.
2. Click File > Save (or press CTRL + S)
3. Immediately start spam clicking the left mouse button.
4. Saving the data will cause the popup to appear, and then clicking will cause the page to break.
5. You will not be able to click into any cells, until you fully refresh the page.

Here is a video of me replicating the problem:

https://youtu.be/gq1MpTwvKbA

I figured out in Smartsheet's JavaScript code why this problem is happening.

The problem is in the FormObjectHandler's handleMouseDown function. If you click when the progressIndicator is busy, it sets the isCancelled_mouseDown_ignoreClick variable to true, and there's nowhere in the code where this variable gets set back to false. So the application will continue to ignore all of the clicks until the user refreshes the page.

Here is the code snippet:

e.prototype.handleMouseDown = function(e, t) {
  if (!this.areAllEventsDisabled())
    if (this.progressIndicator.isBusy)
      this.isCancelled_mouseDown_ignoreClick = true;

I hope this helps the Smartsheet team understand and fix the problem!

Darren Mullen

@SSFeatures Impressive! I was experiencing this issue too but it wasn't consistent enough to figure out. I noticed it starting yesterday afternoon and thought it was just me, but then after rebooting and starting fresh, I still encountered it today as well.

Hopefull Smartsheet uses this to short cut their own troubleshooting!

Michael Ortiz

Nice Fix and report out Nathan! It;s a very frustrating bug but now I know what to do to move on. Thanks for providing the workaround to the community.

Robert K

Thanks all I've reached out to support and we tried several things - one thing was changing the mouse and keyboard - and it worked.

The "Reload Settings" came up and I accepted.

Sometimes removing the usb receiver and plugging it back in works also.

But thanks SSFeatures for finding the source of the problem!

I don't save manually though - so it must happen when Smartsheet autosaves…..then it hangs up and I can't click anything.

Georgie

Hi all,

I'm pleased to say this issue has now been resolved!

Cheers,

Georgie

PS. Wow @SSFeatures - nice troubleshooting!!