ClosedXML / ClosedXML/ClosedXML.Parser
Name quotes
- Dominant language
- C#
- Stars
- 14
- Forks
- 8
- PR merge metrics
- No merged PRs in 30d
Description
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](https://github.com/ClosedXML/ClosedXML.Parser/files/12448522/ident-sheet-first.txt)
[ident-sheet-next.txt](https://github.com/ClosedXML/ClosedXML.Parser/files/12448523/ident-sheet-next.txt)
Create a serialization logic to respect the expected quotes, so Excel can eat it.
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by reading the grammar and the attached ident-sheet-first.txt and ident-sheet-next.txt results. Compare the observed Excel formula behavior for first and subsequent sheet-name characters with the current grammar rules, then trace the serializer entry point. Done means serialized sheet identifiers use quotes exactly where Excel expects them.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- csharp
- Domain
- compilers
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100