Unable to save worksheet with name like a cell range

ClosedXML / ClosedXML

ClosedXML is a .NET library for reading, manipulating and writing Excel 2007+ (.xlsx, .xlsm) files. It aims to provide an intuitive and user-friendly interface to dealing with the underlying OpenXML API.

MIT License

4.79k stars 831 forks source link

Unable to save worksheet with name like a cell range #1586

Open mrunks opened 3 years ago

mrunks commented 3 years ago

Prior versions of ClosedXML use to allow a Cell Name such as Co3 or CR6 and now an exception is thrown indicating that the Sheet name cannot be the same as a cell reference.

I now have to add an underscore to those Sheet names with the latest version of ClosedXML

Version. 0.95.3

Can the functionality be changed in the next version to allow that feature again ?

igitur commented 3 years ago

Complete the full issue template.

JohnRCoder commented 3 years ago

I'm getting a similar error, trying to save a Worksheet with a name of "2021-01" (no quotes). This worked in all prior versions, but suddenly fails with the latest. Also, did a Sanity-check in Excel, 2021-01 is a valid sheet name.