IFClite TypeScript API
    Preparing search index...

    Function guardSpreadsheetFormula

    • Neutralise spreadsheet formula injection in one cell, WITHOUT CSV quoting.

      Split out for writers whose container does its own escaping — the XLSX writer needs the guard but must not gain CSV quotes. CSV writers want escapeCsvCell, which is this plus RFC 4180 quoting.

      NON-DESTRUCTIVE: it looks past any leading invisibles rather than deleting them, so the apostrophe lands in front of a payload that hid behind a BOM while a benign " Wall A" keeps its spaces.

      Parameters

      Returns string