Re: Sheetnames no longer distinct, when adding one with more than 31 characters

Andreas Reichel <[email protected]> Sun, 31 Oct 2021 21:39:41 +0700
Newsgroups gmane.comp.jakarta.poi.user
Message-ID <a380c82ac175ce3f5ae26c32ae237130934e5c0b.camel@manticore-projects.com> 

On Sun, 2021-10-31 at 09:31 +0000, PJ Fanning wrote:
> Seems reasonable to me. An exception should only thrown if the
> truncated name matches an existing sheet name.

There you go: https://github.com/apache/poi/pull/273

Exceptions only on collisions, but I would like to warn at least when
trimmed.
(For example, I created formulas with references to long sheet names
before I created the sheet itself and then wondered why the formula did
not work.)

Cheers
Andreas