https://bz.apache.org/bugzilla/show_bug.cgi?id=69637
Bug ID: 69637
Summary: Prevent users from assigning tables an invalid name
Product: POI
Version: 5.4.0-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: cowwoc2...@gmail.com
Target Milestone: ---
XSSFTable.setDisplayName() should throw an exception if the name violates the
rules specified at:
https://support.microsoft.com/en-us/office/rename-an-excel-table-fbf49a4f-82a3-43eb-8ba2-44d21233b114
section "Important notes for names"
Quoting the relevant section:
> Use valid characters — Always begin a name with a letter, an underscore
> character (_), or a backslash (\). Use letters, numbers, periods, and
> underscore characters for the rest of the name.
>
> Exceptions: You can't use "C", "c", "R", or "r" for the name, because they're
> already designated as a shortcut for selecting the column or row for the
> active cell when you enter them in the Name or Go To box.
>
> Don't use cell references— Names can't be the same as a cell reference, such
> as Z$100 or R1C1.
>
> Don't use a space to separate words— Spaces cannot be used in the name.
> Consider how you can write the name using no spaces. Or, use an underscore
> character (_) or a period (.) as word separators. Examples: DeptSales,
> Sales_Tax or First.Quarter.
>
> Maximum 255 characters—A table name can have up to 255 characters.
>
> Use unique table names— Duplicate names aren't allowed. Excel doesn't
> distinguish between upper and lowercase characters in names, so if you enter
> "Sales" but already have another name called "SALES" in the same workbook,
> you'll be prompted to choose a unique name.
Simple mistakes, like including a space in the name, are much easier to debug
at runtime than trying to figure out why Excel complains that the file is
corrupt without providing any details.
Thanks.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
