Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Name quotes #2

Open
jahav opened this issue Aug 27, 2023 · 0 comments
Open

Name quotes #2

jahav opened this issue Aug 27, 2023 · 0 comments

Comments

@jahav
Copy link
Member

jahav commented Aug 27, 2023

Add a logic to serialize sheet identifiers with a quotes. Sheet names sometimes require quotes and sometimes don't. There is some stuff in the grammar, but that is wildly inaccurate. As far as I can tell, there is no reasonable rule, like unicode categories. The only thing is that any character after Unicode 5.1 needs a quote.

I made AutoHotKey script to rename a sheet with all character from base material plane and checked a formula, if the renamed sheet name had a quote. That was done for first char and next char:

ident-sheet-first.txt
ident-sheet-next.txt

Create a serialization logic to respect the expected quotes, so Excel can eat it.

jahav added a commit that referenced this issue Oct 28, 2023
…all types of names, sheet, defined name, table names...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant