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

Rob Sargent <[email protected]> Sun, 31 Oct 2021 09:21:31 -0600

Newsgroups	gmane.comp.jakarta.poi.user
Message-ID	<[email protected]>


> On Oct 31, 2021, at 8:39 AM, Andreas Reichel <[email protected]> wrote:
> 
> 
> 
> 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
Is this really the answer?  Isn’t the 31 character constraint rather archaic, even if long sheet names truly are counter-productive?  Why “31”?