Skip to content

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

@asiwjp

Description

@asiwjp

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?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions