[Libreoffice-bugs] [Bug 117926] FILESAVE: XLSX: Sheets name shouldn't exceed 31 characters

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=117926

--- Comment #3 from Eike Rathke <erack at redhat.com> ---
Artificially limiting doesn't make much sense, though we could limit to 31
characters when manually renaming a sheet.

ODF doesn't limit the length, so any file opened as ODF and saved as Excel
could suffer the same. Also importing CSV creates a sheet name from the file
name, which may be longer. When saving to Excel maybe the name could be
truncated, but care would have to be taken that no duplicate names would be
created that way. Writing references all would have to use an extra mapping,
also structures and functions using sheet names as literal strings like
INDIRECT() addressing would then break. I'd avoid fiddling with sheet names
when exporting.

We should rather warn or even refuse to save the file in alien formats that are
known to have this limit, so the user can rename the sheet as appropriate.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180531/59d0a5e3/attachment.html>