Skip to content

Formulas into sheets named like .x or R1C1 references are saved unquoted; Excel can't open the file #2009

Open

Description

@HyakoV3

A formula referencing a sheet named .x, R, C, RC, R1C1 or r2c3 is written to the XLSX without quotes. Excel refuses to open the file and repair fails. Excel writes these as 'R1C1'!A1, '.x'!A1.

Split out of #1458 as requested there. Fixed by #1529.

Activity

  1. ticket-craft commented on Oct 19, 2026

    @ticket-craft

    Possibly related: #1458 and #2011.

  2. Harrison-Booth commented on Oct 26, 2026

    @Harrison-Booth
    Contributor

    Fixed by #1529

    Checked on main d8c5f58 (gridcraft-cli 0.12.1, dev build, Linux) and in Excel (Microsoft 365, Windows, build 16.0.20527).

    Ran: a workbook with sheets named .x, R, C, RC, R1C1, r2c3 (plus A1 and Bob's), and on Sheet1 one formula per sheet, ='<name>'!A1, saved with gridcraft-cli run --script … --out q2.xlsx.

    Result: every formula is saved quoted: '.x'!A1, 'R'!A1, 'C'!A1, 'RC'!A1, 'R1C1'!A1, 'r2c3'!A1, 'A1'!A1, 'Bob''s'!A1.

    Excel: opens the file without an error, and all eight formulas come back with the same sheet names (for example ='R1C1'!A1, ='Bob''s'!A1). With alerts switched off I can't see a repair prompt, but nothing was dropped.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions