https://help.libreoffice.org/Calc/Renaming_Sheets The reference must be enclosed in single quotes, and the one single quote inside the name must be doubled: 'This years sheet'.A1 Operating System: Windows 8 Version: 4.0.2.2 release
confirmed. Wikihelp doesn't properly quote the example at the bottom of the page in <url> This year's sheet quoted as a cell-reference becomes 'This year<italics>s sheet</italics>' instead of 'This year''s sheet' (it puts it like that into the source, but it it is interpreted by mediawiki)
Adding Kendy and Andras, who maintain the wikihelp
Andras Timar committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/help/commit/?id=9c6ee8419cc4e7ff0d5b3cfbd9fc0e538e78f8ab fdo#64205 escape '' in help text with <nowiki> tag 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.
I fixed https://help.libreoffice.org/Calc/Renaming_Sheets manually, and I fixed the generator script. Localizations will be fixed by the next wikihelp update (within a month).
Andras Timar committed a patch related to this issue. It has been pushed to "libreoffice-4-0": http://cgit.freedesktop.org/libreoffice/help/commit/?id=d8f46055f562917e857c4395601138f0515e71d0&h=libreoffice-4-0 fdo#64205 escape '' in help text with <nowiki> tag It will be available in LibreOffice 4.0.4. 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.