ClosedXML / ClosedXML/ClosedXML.Parser

The sheet name is not properly escaped. char="~"

Open
#29 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
14
Forks
8
PR merge metrics
No merged PRs in 30d

Description

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?

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.