Docs: Describe usage of non-ASCII characters in the sheet names

handsontable / hyperformula

HyperFormula is an open-source headless spreadsheet for business web apps. It comes with over 400 formulas, CRUD operations, undo-redo, clipboard support, and sorting.

https://hyperformula.handsontable.com/

Other

1.9k stars 108 forks source link

Docs: Describe usage of non-ASCII characters in the sheet names #1313

Open sequba opened 9 months ago

sequba commented 9 months ago

Page URL

https://hyperformula.handsontable.com/guide/cell-references.html

Improvement description

In HF only some characters are allowed in unqoted sheet names:

[A-Za-z\u00C0-\u02AF0-9_]

If a sheet name contains other characters in must be enclosed in single quotes. E.g.:

=IF('あは'!A2  > 'あは'!A3, "TeamA", "TeamB")