I've come across a problem with using Textexpander in Google Sheets in Firefox.
Say I have a snippet that expands to =INDEX(B2:B,MATCH("green",A2:A,0),1)
Now if I expand… (Lesen Sie mehr)
I've come across a problem with using Textexpander in Google Sheets in Firefox.
Say I have a snippet that expands to =INDEX(B2:B,MATCH("green",A2:A,0),1)
Now if I expand that by just typing the abbreviation shortcut, i.e. gs.index, it gets expanded, but has a line break before it within the cell so it doesn't get recognised as a formula. I have to manually delete the line break out.
However, if I use the global keyboard shortcut to search for the snippet and select it from the list, when entered, it goes into the cell without a preceding line break and gets registered as a formula.
Is there anyway to overcome this issue that you know of? I'm using Firefox 85.0.2, mainly because I'm on High Sierra and Safari cannot be updated beyond 13.1.2. Incidentally, I don't get this problem when using Safari.
I've raised this with the guys at Smile Software too, but asking here as it does seem to be a Firefox-specific issue.
Thanks.