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

> On Oct 31, 2021, at 10:27 AM, Andreas Reichel <[email protected]> wrote:
> 
> Greetings.
> 
>> On Sun, 2021-10-31 at 09:21 -0600, Rob Sargent wrote:
>> Is this really the answer?  Isn’t the 31 character constraint rather
>> archaic, even if long sheet names truly are counter-productive?  Why
>> “31”?
> 
> This is not on POI, but solely Microsoft UI programming.
> As far as I understand, the file format supports longer sheet names and
> better programs also are able to use those -- but MS Excel UI would
> throw problems and also silently trim the names (when entered or read
> from file?).
> 
> Also: the problem was not about the trimming itself, but rather on
> trimming SILENTLY and with COLLISIONS.
> 
> Warm regards
> Andreas

Thanks for the clarification.