search

ggreen86 / XLSX-Workbook-Class

VFP Class to Create an XLSX Workbook without Excel Automation or Installed
45 stars 16 forks source link

Allow a sheet to be named "History" #105

Open DougHennig opened 8 months ago

DougHennig commented 8 months ago

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 commented 8 months ago

Doug—

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

image

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"

*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 commented 8 months ago

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