Apps Script `createTextFinder` returns incorrect object [384765605]

Assigned

Bug

Status Update

No update yet.

Description

un...@gmail.com

created issue #1

Dec 18, 2024 08:54AM

The createTextFinder method is supposed to return a TextFinder object as usual, but instead, it is returning an object called FindReplaceText.

function test() {
  const ss = SpreadsheetApp.openById(SPREADSHEET_ID);
  const sheet = ss.getSheetByName('Users');
  const v = sheet.createTextFinder('U001',);
  console.log(v);
}

▼Expected Log

{ toString: [Function],
  startFrom: [Function],
  matchCase: [Function],
  matchEntireCell: [Function],
  useRegularExpression: [Function],
  matchFormulaText: [Function],
  ignoreDiacritics: [Function],
  findNext: [Function],
  findPrevious: [Function],
  getCurrentMatch: [Function],
  replaceAllWith: [Function],
  replaceWith: [Function],
  findAll: [Function] }

▼Actual Log

FindReplaceText

Comments

bl...@google.com <bl...@google.com> #2Dec 18, 2024 09:12AM

Assigned to jp...@google.com.

Automated by Blunderbuss job workspace-devrel-public-issue-tracker-blunderbuss-autoassigner for config assign for component 191640.

wi...@airbus.com <wi...@airbus.com> #3Dec 19, 2024 07:49PM

Same issue

jp...@google.com <jp...@google.com> #4Dec 19, 2024 08:37PM

Verified with:

const SPREADSHEET_ID = "1llnOlPeUuNAq2xwXw9q3ryubX8H098e9r-XjyZWG_1A";

function test() {
  const ss = SpreadsheetApp.openById(SPREADSHEET_ID);
  const sheet = ss.getSheets()[0];
  const v = sheet.createTextFinder('a');
  console.log(Object.getOwnPropertyNames(v));
}

jp...@google.com <jp...@google.com> #5Dec 19, 2024 08:40PM

I have reported this to the engineering team and future updates will be shared here. Thank you for your patience.

un...@gmail.com <un...@gmail.com> #6Jan 22, 2025 01:08AM

As of January 22, 2025, the same error persists.

https://docs.google.com/spreadsheets/d/1AhgwZyGSIz5sfJwS9avG2ofvOqvgWmzJgNx6_0C0un0/edit?gid=0#gid=0

When running the GAS script attached to this spreadsheet, I encounter the error: “TypeError: Cannot read properties of undefined (reading ‘indexOf’).”

However, when I share this spreadsheet with another account and run the GAS script from the shared account, it works without any errors.

I have attached images for both cases.

Bug of createTextFinder

image-1737508027803.png

895 KB

View

Download

image-1737508038733.png

787 KB

View

Download

ko...@gmail.com <ko...@gmail.com> #7Mar 23, 2025 09:41AM

Comment has been deleted.

Message last modified on Mar 23, 2025 09:42AM

ko...@gmail.com <ko...@gmail.com> #8Mar 23, 2025 09:43AM

It's been about three months since the problem started, what progress has been made?