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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 117926
           Summary: FILESAVE: XLSX: Sheets name shouldn't exceed 31
                    characters
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: xiscofauli at libreoffice.org

Created attachment 142433
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142433&action=edit
sample file with 32 characters in sheet name

Steps to reproduce:
1. Open the attached file in MSO Excel
-> Excel complains about unreadable content.

If we edit the document in LibreOffice and we remove the last 'd' from the
sheet name, it's open correctly in Excel.

Limitation:
https://support.office.com/en-us/article/Rename-a-worksheet-3F1F7148-EE83-404D-8EF0-9FF99FBAD1F9

If the file is saved to .XLS, Excel doesn't complain and only the first 31
characters are used.

Excel limits the number of characters to 31 when editing the name

Reproduced in

Version: 6.1.0.0.beta1+
Build ID: 2a0d8106a558845357d39648656e08ec6f091cf8
CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group threaded

-- 
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/2294aec8/attachment-0001.html>