You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2025/03/28 17:20:19 UTC
[Bug 69637] New: Prevent users from assigning tables an invalid name
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: cowwoc2020@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-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 69637] Prevent users from assigning tables an invalid name
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=69637
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Severity|normal |enhancement
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 69637] Prevent users from assigning tables an invalid name
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=69637
Matafagafo <ma...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
CC| |matafagafo@gmail.com
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org