[Libreoffice-bugs] [Bug 136507] New: FILESAVE: Rename Sheet function in Calc is not saving names longer than 31 characters

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 136507
           Summary: FILESAVE: Rename Sheet function in Calc is not saving
                    names longer than 31 characters
           Product: LibreOffice
           Version: 6.4.6.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: trivial
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: martinterry839 at btinternet.com

Description:
After renaming a sheet in an xlsx file with a name longer than 31 characters
the new name was displayed as expected on the sheet tab, but after saving,
closing and re-op 

Steps to Reproduce:
1. Open existing xlsx spreadsheet in Calc.
2. Any sheet - click on Sheet/Rename Sheet
3. Rename Sheet dialog opens 
4. Enter a name longer than 31 characters (screen 1)
5. OK -> sheet name updates in view to show full name that was entered (screen
2)
6. Save
7. Close
8. Re-open and Sheet name displayed is truncated to first 31 chars (screen 3)
9. Click on Sheet/Rename Sheet and only truncated Sheet Name is displayed
10. Checked Insert Sheet and got same behaviour, with name truncated when file
re-opened.


Have attached file showing 3 screen shots
Tried looking through existing bugs but a large number of matches to various
searches makes it difficult. Did find 84874 which is not quite the same but in
the same area.
Only minor issue. Noticed it when my sheet name lost final character.
Not sure what the maximum length of sheet names is, but the Insert and Rename
Sheet dialogs should limit length of name to the maximum. (I realise it could
be a different issue altogether)


Actual Results:
When re-open file the Sheet name displayed is truncated to first 31 chars of
string entered

Expected Results:
Not sure because I don't know what the maximum length of the Sheet Name should
be. Whatever a user can enter in Insert Sheet or Create Sheet dialog should be
preserved through a Save/Close/Reopen sequence  


Reproducible: Always


User Profile Reset: No



Additional Info:
See above

Hope I have provided enough information. Thanks for all your work on the LO
suite. I am a big fan of LO and have used it for several years!

-- 
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/20200906/df183f42/attachment.htm>