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.
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.