We're calling on all EU-based Mozillians with iOS or iPadOS devices to help us monitor Apple’s new browser choice screens. Join the effort to hold Big Tech to account!

Avatar for Username

Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

Hierdie gesprek is in die argief. Vra asseblief 'n nuwe vraag as jy hulp nodig het.

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.

All Replies (3)

jscher2000 - Support Volunteer
jscher2000 - Support Volunteer
  • Top 10 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 Vraag-eienaar
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 10 Contributor
more options

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