Join the AMA (Ask Me Anything) with the Firefox leadership team to celebrate Firefox 20th anniversary and discuss Firefox’s future on Mozilla Connect. Mark your calendar on Thursday, November 14, 18:00 - 20:00 UTC!

Avatar for Username

Sök i support

Akta dig för supportbedrägerier: Vi kommer aldrig att be dig att ringa eller skicka ett sms till ett telefonnummer eller dela personlig information. Rapportera misstänkt aktivitet med alternativet "Rapportera missbruk".

Läs mer

Denna tråd har arkiverats. Ställ en ny fråga om du behöver hjälp.

Textexpander in Google Sheets adds a line break upon expansion in Firefox

lp3
lp3
more options

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.

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.

Alla svar (3)

jscher2000 - Support Volunteer
jscher2000 - Support Volunteer
  • Top 25 Contributor
more options

In late 2019/early 2020, there was a known problem where deleting the contents of a Sheets cell caused a line break character to be injected into it: https://support.mozilla.org/questions/1272896

That was supposed to have been fixed long ago, but maybe there's a subtle difference with TextExpander that still triggers that issue?

What if you type =gs.index -- do you get:

  • double == at the beginning of the cell
  • = then line break then =
  • nothing, TextExpander ignores it

I see Smile has a Windows version I could trial, but one never knows whether Windows and Mac software will behave the same.

lp3
lp3 Frågans ägare
more options

Hi there. Thanks for taking the time. Apologies, I did try a search for Google Sheets but didn't unearth this issue.

As per the above, if I type =gs.index, Textexpander doesn't come into play and GS just accepts it which results in #NAME? being displayed as GS doesn't recognise the range.

jscher2000 - Support Volunteer
jscher2000 - Support Volunteer
  • Top 25 Contributor
more options

I was hoping to find time to test TextExpander, but haven't yet. Sorry!