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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
