<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - FILESAVE: XLSX: Sheets name shouldn't exceed 31 characters" href="https://bugs.documentfoundation.org/show_bug.cgi?id=117926#c3">Comment # 3</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - FILESAVE: XLSX: Sheets name shouldn't exceed 31 characters" href="https://bugs.documentfoundation.org/show_bug.cgi?id=117926">bug 117926</a> from <a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> Eike Rathke</a> <pre>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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>