You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Name Box doesn't read doubled apostrophes as a single apostrophe #2013
Typing or showing a reference like ='Bob''s'!$A$1:$B$2 in the Name Box does not resolve the sheet Bob's; '' must be read as one apostrophe (also in Go To).
Split out of #1458 as requested there. Fixed by #1529.
Fixed by #1529 for Go To (the Name Box text field itself not run)
Checked on maind8c5f58 (gridcraft-cli 0.12.1, dev build, Linux) and in Excel (Microsoft 365, Windows, build 16.0.20527).
Ran: a workbook with a sheet named Bob's, Sheet1 active, then edit.goTo with 'Bob''s'!$A$1:$B$2.
Result: the active sheet becomes Bob's and the selection is A1:B2. 'Bob''s'!A1 and Bob's!A1 also work.
Excel:Application.Goto("'Bob''s'!R1C1:R2C2") activates Bob's and selects $A$1:$B$2; Range("'Bob''s'!A1:B2") resolves to '[q2.xlsx]Bob''s'!$A$1:$B$2. (COM has no Name Box, so I used those.)
Difference / not checked: with a leading = (='Bob''s'!$A$1:$B$2, as written in the issue) edit.goTo says "Reference isn't valid." I didn't check how Excel's Name Box treats a leading =. I ran the edit.goTo command, not the Name Box field in the UI.
Activity
ticket-craft commentedon Oct 19, 2026
Possibly related: #1458, #2012 and #2009.
Harrison-Booth commentedon Oct 26, 2026
Fixed by #1529 for Go To (the Name Box text field itself not run)
Checked on
maind8c5f58 (gridcraft-cli 0.12.1, dev build, Linux) and in Excel (Microsoft 365, Windows, build 16.0.20527).Ran: a workbook with a sheet named
Bob's,Sheet1active, thenedit.goTowith'Bob''s'!$A$1:$B$2.Result: the active sheet becomes
Bob'sand the selection isA1:B2.'Bob''s'!A1andBob's!A1also work.Excel:
Application.Goto("'Bob''s'!R1C1:R2C2")activatesBob'sand selects$A$1:$B$2;Range("'Bob''s'!A1:B2")resolves to'[q2.xlsx]Bob''s'!$A$1:$B$2. (COM has no Name Box, so I used those.)Difference / not checked: with a leading
=(='Bob''s'!$A$1:$B$2, as written in the issue)edit.goTosays "Reference isn't valid." I didn't check how Excel's Name Box treats a leading=. I ran theedit.goTocommand, not the Name Box field in the UI.