Allow a sheet to be named "History"

[DougHennig]

I commented out this code in CheckSheetName to allow a sheet to be named "History":

*** DH 2023-07-14: allow History as a sheet name
*IF UPPER(lcSheetName) == "HISTORY"
*	RETURN .NULL.
*ENDIF

[ggreen86]

Doug—

When I try to rename a sheet in Excel 2016 to ‘History’ I get an error message that History is a reserved name.

Based on this I would not recommend using this name as I don't know what side-effects that might occur.

Greg

From: Doug Hennig @.> Sent: Sunday, December 24, 2023 9:25 AM To: ggreen86/XLSX-Workbook-Class @.> Cc: Subscribed @.***> Subject: [ggreen86/XLSX-Workbook-Class] Allow a sheet to be named "History" (Issue #105)

I commented out this code in CheckSheetName to allow a sheet to be named "History":

*** DH 2023-07-14: allow History as a sheet name

*IF UPPER(lcSheetName) == "HISTORY"

•   RETURN .NULL.
  

*ENDIF

— Reply to this email directly, view it on GitHubhttps://github.com/ggreen86/XLSX-Workbook-Class/issues/105, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AGWB33KOE2VN6PVZPGEFAYDYLA3MVAVCNFSM6AAAAABBBSFKYOVHI2DSMVQWIX3LMV43ASLTON2WKOZSGA2TKMJRG43DOMA. You are receiving this because you are subscribed to this thread.Message ID: @.@.>>

[DougHennig]

You can't rename a sheet to History but you can create a sheet named History. That seems weird!