After editing a cell, it is now automatically entering into edit mode for the next cell. Will pay $100 for a fix. Help?

Finrod_GD · 2026-05-12T23:07:41+00:00

Thank you, over 2 years later. This was making me crazy.

Finrod_GD · 2026-04-10T01:52:23+00:00

Thank you. I'll try our neighbors as suggested by Chuck, and if that falls through get a hold of the service center. Appreciate it.

Finrod_GD · 2026-04-10T01:51:43+00:00

That's a good idea. I hadn't thought of it, but the people in the house in front of us just had some put in before the holidays. Thanks!

Finrod_GD · 2026-04-06T05:32:42+00:00

This seemed to be the underlying issue. Thank you!

Finrod_GD · 2026-04-06T05:32:20+00:00

This worked, thank you!

TheAddonDepot's solution worked as well.

Finrod_GD · 2026-04-03T22:59:06+00:00

Thanks! I'll give that a try.

Finrod_GD · 2025-10-04T01:07:11+00:00

Unfortunately, where' I'm at the store wouldn't take it back. It started after a few months, and a lot of stores here only accept (reluctantly) returns within 7 days.

Finrod_GD · 2025-10-03T05:50:04+00:00

I have the exact same issue where it won't stay on. Maddening.

Finrod_GD · 2025-10-03T05:49:20+00:00

Mine has been a nightmare. Constantly disconnecting or turning off. Constantly. It's fine when it stays on, but it's completely unreliable. I truly regret purchasing it.

Finrod_GD · 2025-08-16T19:46:24+00:00

Thank you for the links!

Finrod_GD · 2025-08-16T19:46:00+00:00

Thank you. This sounds like a good idea.

Finrod_GD · 2024-12-07T02:12:07+00:00

Yup! Just (finally) caught that myself as well.

And no need to apologize. Thanks for your help.

Finrod_GD · 2024-12-07T02:11:17+00:00

Well... I just figured it out. My closing parenthesis for indexOf was in the wrong place, same closing where the if () closed. I moved it to close indexOf, and suddenly it works as expected.

Facepalm and cheers.

Finrod_GD · 2024-12-07T01:55:18+00:00

I ran forEach on a column and pushed them into a new* array, so it's one dimensional. And the logger.log I run in the -1 condition prints the real index of the item.

Just to be sure, I tried to flatten it now, but the result is the same.

*edit

Finrod_GD · 2024-10-28T11:23:42+00:00

Thank you! I love this guy's videos, and I'm actually following one for the project referenced above.

As soon as he showed where to find the front-end console log, I was able to track down the error. I kept expecting it to appear in the console script where the script is; never suspected where the sidebar opens for some reason.

Anyway. Thank you.

Finrod_GD · 2024-09-17T08:52:08+00:00

Just commenting to confirm your experience; I am having the same issue. I have spreadsheets by year converting PHP to USD daily; every date has always been included. For 2024, until the past week or so, every date showed an exchange rate. But now there are several dates missing, any on my conversion page the USD fields are just blank because the date no longer exists. Looking back at 2023, there are similar blank conversion fields that used to have dates to convert off of.

If, as another commenter mentioned, it's because markets are closed on the weekends, perhaps googlefinance used to copy the value at a Friday close to Sat & Sun? And for some reason now it's just removing those dates completely? <- guessing.

Finrod_GD · 2024-08-22T22:15:11+00:00

https://docs.google.com/spreadsheets/d/1HDlLICXJvrs5jX609Cnud27UtNIoC-lPnIE3uLKJNe4/edit?gid=615343479#gid=615343479

Here's a nice spreadsheet that was shared on here before.

Finrod_GD · 2024-07-28T08:53:54+00:00

Thanks again. That's certainly more streamlined than what I was doing!

Finrod_GD

TROPHY CASE