https://bz.apache.org/ooo/show_bug.cgi?id=126748

--- Comment #13 from orcmid <[email protected]> ---
Created attachment 85419
  --> https://bz.apache.org/ooo/attachment.cgi?id=85419&action=edit
Confirmation that only sheet name changed by Excel

This is the same Excel session as Attachment 85418, but with the second sheet
selected.  This reveals the full name and confirms that the data has been
preserved.

It appears that Excel will truncate sheet names that exceed its limitation on
their length, but it has a problem if the result is a collision.  The solution
that will applied, when permission is given, is to rename all but one of the
truncation-produced duplicates.  

We can do two things:

 1. Add some caveats around Calc - Excel interop to indicate that sheet names
are truncated via .xls or .ods and should be unique in the first 31 characters.

 2. On saving to .xls, provide some sort of truncation to honor the sheet-name
length constraint.  That may be difficult and will certainly not happen any
time soon.  

In the meantime, this is a confirmed open issue.

-- 
You are receiving this mail because:
You are the assignee for the issue.

Reply via email to