In the sheet name, characters that require escaping with quotation marks are not escaped.
The problematic character is "~"
For example, the problem occurs in the following case:
When setting a sheet name like "ABC~" in the ClosedXML body:
sheet.Name = "ABC~"
Impact:
When opening the file using Excel, a report indicating corruption is displayed.
Suspected cause:
In NamedUtil.EscapeName, are the bits in the "QuoteNext" and "QuoteFirst" bitmasks not set?
Question:
Is such a strict bitmask even necessary?
Unless you're an Excel developer, you wouldn't know the patterns that require quotation marks, so wouldn't this result in unstable software?
In the sheet name, characters that require escaping with quotation marks are not escaped.
The problematic character is "~"
For example, the problem occurs in the following case:
When setting a sheet name like "ABC~" in the ClosedXML body:
sheet.Name = "ABC~"
Impact:
When opening the file using Excel, a report indicating corruption is displayed.
Suspected cause:
In NamedUtil.EscapeName, are the bits in the "QuoteNext" and "QuoteFirst" bitmasks not set?
Question:
Is such a strict bitmask even necessary?
Unless you're an Excel developer, you wouldn't know the patterns that require quotation marks, so wouldn't this result in unstable software?