Support

Private installation steps are in apps-script/README.md. Common questions are answered below.

The SheetFix menu is missing

Reload the spreadsheet tab and make sure the Apps Script project was saved. During private testing, you can also open Extensions → Apps Script, run onOpen once, and reload the spreadsheet.

Google asks for authorization

Authorization is expected during the initial private installation. Review Google's permission screen and approve only the spreadsheet-related access required by SheetFix. A private development project can also show Google's unverified-app warning before public verification.

It says "No safe text cells to update in the selection."

The selected cells may be blank, numbers, dates, booleans, formulas, already in the requested form, or generated formula/spill output. SheetFix deliberately skips cells it cannot safely treat as user-entered text.

Why did SheetFix skip an ARRAYFORMULA result?

Generated ARRAYFORMULA spill-output cells are intentionally protected. Writing directly into one can break the parent array formula, so SheetFix checks Google Sheets cell metadata and leaves generated spill results untouched.

It says "Please select some cells first."

Select a range in the sheet before choosing an operation.

It says the selection is too large

SheetFix refuses selections above 50,000 cells rather than risk a partial or timed-out operation. Work in smaller blocks.

A cell did not change

Formula cells and generated spill outputs are protected. Numbers, dates, booleans and blanks are skipped, and text already in the requested form does not need to be rewritten.