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