Showing questions tagged: Show all questions
  • Archived

Google Sheets - using + or * signs don't move the cursor, so previous cell address is overwritten in the formula

[Added an attachment to simplify the explanation] Suppose that I want to write the formula A1+A2 (or A1*A2). If I click A1 and then use the '+' sign. The sign it appears … (read more)

[Added an attachment to simplify the explanation]

Suppose that I want to write the formula A1+A2 (or A1*A2). If I click A1 and then use the '+' sign. The sign it appears right after the cursor, so the cursor it's now between the A1 and the '+' sign, and the A1 text in the formula remains -I would say- selected as if nothing was written. So whatever I write or click afterwards overwrites the A1 cell reference making it impossible to write a formula.

I'm in Win10 with Firefox v69.0, both latest versions in English with a Spanish Intl. keyboard and layout. Checked in a couple of spreadsheets including a blank one.

Things that I have already tried:

- Disabled all add-ons on all tests

- Tried doing the same on Chrome, Opera, Edge (edgeHTML), Safari and FF for Mac. Only happens in FF both Mac and Win.

- It only happens when the previous cell was introduced using the mouse or the arrow keys, not if it was written.

- Only happens when using the '+' (or '*') from the regular keyboard, not the one from the numerical keypad.

- Switched to Spanish Windows and Firefox. Doesn't work either.

- Tested old Firefox versions, including, ESR.

- Changed the keyboard layout. With some of them it works (US, UK, US_Intl, FR, PL programmers) and with others doesn't (ES, DE, IT, FI and serbian). Moreover, few of them (FR and FI) works for one sign (+ or *) but not for the other.

Any ideas? Thanks

Asked by Coriscow 8 months ago

Last reply by jscher2000 8 months ago