Ovo će web mjesto raditi na ograničen način, dok obavljamo održavanje stranice. Ako neki članak ne riješi tvoj problem i ako želiš postaviti pitanje, naša zajednica za podršku spremna je pomoći na Twitteru @FirefoxSupport i na Redditu /r/firefox.

Avatar for Username

Pretraži podršku

Izbjegni prevare podrške. Nikad te nećemo tražiti da nas nazoveš, da nam pošalješ telefonski broj ili da podijeliš osobne podatke. Prijavi sumnjive radnje pomoću opcije „Prijavi zlouporabu”.

Saznaj više

Ova tema je arhivirana. Postavi novo pitanje ako trebaš pomoć.

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.

Svi odgovori (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 Vlasnik pitanja
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!