ClosedXML / ClosedXML/ClosedXML.Parser

Name quotes

Open
#2 0 comments 0 reactions 0 assignees View on GitHub
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.