Bug 103027

Summary:	Can't name a sheet starting with the ' [apostrophe] character
Product:	LibreOffice	Reporter:	fcastillousfq
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	CLOSED WONTFIX
Severity:	normal	CC:	jbfaure
Priority:	medium
Version:	Inherited From OOo
Hardware:	All
OS:	All
Whiteboard:	target:6.0.0
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108912

Description fcastillousfq 2016-10-06 06:23:05 UTC

Description:
If I want to named a sheet starting with the ' [apostrophe] character, a dialog showing an "invalid sheet name" shows, stating that the name must not be a duplicate or contain certain characters, which ' [apostrophe] is not listed.
In fact, I can place a ' anywhere in the name as long as is not the first character, and libreoffice doesn't have a problem with it.
As a workaround, I start the name with a space followed by ' [apostrophe] and that does the trick. Nonetheless, this is a bug.

Steps to Reproduce:
1.Rename any sheet
2.Make sure the first character in the name is ' [apostrophe]

Actual Results:  
The "Invalid sheet name" dialog should appear

Expected Results:
The sheet should be renamed without any problems. The ' [apostrophe] character is not an invalid one.


Reproducible: Always

User Profile Reset: Yes

Additional Info:


User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.143 Safari/537.36

Comment 1 Jean-Baptiste Faure 2016-10-06 19:37:09 UTC

Reproducible with master under Ubuntu 16.04. The error message is displayed if the apostrophe is the first or the last character. And, indeed, the apostrophe is not in the given list of invalid characters.

Best regards. JBF

Comment 2 Eike Rathke 2017-09-04 11:26:15 UTC

Apostrophe isn't allowed as first or last character because Excel can't handle it (probably due to the sheet name when used in references can be single quoted and a single ' quote contained is escaped by doubling it '' and they can't cope with that if it's right at the start or end of a single quoted name). Won't change. We may add a hint to the dialog though.

Comment 3 Commit Notification 2017-09-04 11:37:44 UTC

Eike Rathke committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=62c6e17fc03ae54cf3f6b667cf8ba205b92996a5

Apostrophe ' is invalid as first or last character in sheet name, tdf#103027

It will be available in 6.0.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.