Google Sheets Formula not working after update

  • I use the Google Sheets add-on to write a formula to Google Sheets.
    =SUBSTITUTE(XXXXXXX)
    Its used to work before the update but now it writes an inverted comma before the equals sign like this
    ‘=SUBSTITUTE(XXXXXXX)
    This disables the formula in Google Sheets unless I remove the inverted comma.

    I am assuming this is a bug or that I have overlooked something.
    I have not been able to find any thing in the forums or anywhere else.

    Please help

Viewing 1 replies (of 1 total)
  • Plugin Author Alex Agranov

    (@alexagr)

    This is actually by design – you don’t want user input to be able to execute code in your Sheet due to security reasons. Hence all input is formatted as text.

Viewing 1 replies (of 1 total)
  • The topic ‘Google Sheets Formula not working after update’ is closed to new replies.