Bug 45285

Summary: Use more revealing error message for not allowed sheet names
Product: LibreOffice Reporter: OfficeUser <norbert.notz>
Component: SpreadsheetAssignee: Albert Thuswaldner <thuswa>
Status: RESOLVED FIXED QA Contact:
Severity: normal    
Priority: medium CC: thuswa
Version: 3.5.0 RC1   
Hardware: Other   
OS: All   
Whiteboard:
i915 platform: i915 features:
Attachments: MS Excel 2007 german.png

Description OfficeUser 2012-01-26 12:41:51 UTC
Created attachment 56204 [details]
MS Excel 2007 german.png

Problem:

When trying to insert or rename a sheet with an already existing name, LibreOffice prints: "Invalid sheet name."

MS Excel uses more revealing error massage. Have a look at the attached screen shot (sorry it's german).

The current message "Invalid sheet name." gives the impression that a chosen sheet name is generally invalid. This is confusing if the document contains many sheets and it is recognizable immediately that the chosen name already exists.

Solution:
Use more revealing error message (like MS Excel) why sheet is not allowed.
Comment 1 Albert Thuswaldner 2012-01-26 13:01:42 UTC
I can have a go at this one. Should we add something like this?

Invalid sheet name. 

The following rules apply:
- cannot be a duplicate of an existing sheet name.
- cannot contain the characters [ ] * ? / \ .
- must be 31 or fewer characters.
Comment 2 OfficeUser 2012-01-27 08:18:46 UTC
It looks good!
Comment 3 OfficeUser 2012-01-30 14:14:05 UTC
Thanks for implementing. Will it be already fixed in 3.5 final?
Comment 4 Albert Thuswaldner 2012-01-31 11:36:15 UTC
(In reply to comment #3)
> Thanks for implementing. Will it be already fixed in 3.5 final?

No sorry it will not be in 3.5, you have to wait for 3.6 for this one. The reason is that 3.5 is in string freeze so that all the translators can keep up.

Hope you are not too down beat by this. Keep filing bugs if/when you find some and maybe help to resolve them, if you want. Your help is appreciated.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.