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

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