From ed893b7a8c47e2b5fe712b73966324e4c44e41d5 Mon Sep 17 00:00:00 2001 From: Seth Chaiklin Date: Tue, 8 Dec 2020 14:34:28 +0100 Subject: Related to: tdf#138662 improve help for renaming Calc sheets * move and to better location * move prefix explanation to better location with own

- drop links to page that does not give any help about prefixes and add menu command sequence to get to the relevant place. * Revise explanation about naming (drop select, add double click) + add explanation about single quote restrictions. - drop warning about WindowManager (which was added in 2006) + add to restricted characters + add new

headings to clarify page content * convert one "note" to a paragraph under a new heading * where paragraphs were changed, add as apppropriate * update to ,,

Change-Id: I8a0e97b871331e0e3300a68252ae4096500aeeb1 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/107380 Tested-by: Jenkins Reviewed-by: Seth Chaiklin Reviewed-by: Ilmari Lauhakangas (cherry picked from commit 13cd181da4668aba0ba1e60c928d91c4892754db) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/107491 Reviewed-by: Adolfo Jayme Barrientos --- source/text/scalc/guide/rename_table.xhp | 53 +++++++++++++++----------------- 1 file changed, 25 insertions(+), 28 deletions(-) diff --git a/source/text/scalc/guide/rename_table.xhp b/source/text/scalc/guide/rename_table.xhp index 0cebc5bcf2..dd03da71ec 100644 --- a/source/text/scalc/guide/rename_table.xhp +++ b/source/text/scalc/guide/rename_table.xhp @@ -1,6 +1,5 @@ - - Renaming Sheets @@ -31,16 +29,15 @@ sheet tabs;renaming tables;renaming names; sheets -mw made "renaming sheets" a two level entry. -Renaming Sheets - -Setting sheet names is an important feature to produce readable and understandable spreadsheets documents. To rename a sheet in your document: + +

Renaming Sheets +

+Setting sheet names is an important feature to produce readable and understandable spreadsheets documents. +The name of a sheet is independent of the name of the spreadsheet. You enter the spreadsheet name when you save it for the first time as a file. +To rename a sheet in your document: - Click on the sheet tab to select it. - - - Open the context menu of the sheet tab and choose the Rename Sheet command. A dialog box appears where you can enter a new name. + Double-click the sheet tab or open its context menu and choose Rename Sheet. A dialog box appears where you can enter a new name. Enter a new name for the sheet and click OK. @@ -48,46 +45,46 @@ Alternatively, hold down the Option key Alt key and click on any sheet name and enter the new name directly. - +The document can contain up to 10,000 individual sheets, which must have different names. +

Sheet Naming Restrictions

Sheet names can contain almost any character. Some naming restrictions apply, the following characters are not allowed in sheet names: - colon : + colon : - back slash \ + back slash \ - forward slash / + forward slash / - question mark ? + question mark ? - asterisk * + asterisk * - left square bracket [ + left square bracket [ - right square bracket ] + right square bracket ] - single quote ' as the first or last character of the name + single quote ' as the first or last character of the name - In cell references, a sheet name must be enclosed in single quotes ' when the name contains other characters than alphanumeric or underscore. A single quote contained within a name has to be escaped by doubling it (two single quotes). - For example, you want to reference the cell A1 on a sheet with the following name: - This year's sheet - The reference must be enclosed in single quotes, and the one single quote inside the name must be doubled: - 'This year''s sheet'.A1 - The name of a sheet is independent of the name of the spreadsheet. You enter the spreadsheet name when you save it for the first time as a file. - The document can contain up to 10,000 individual sheets, which must have different names. - You can set a prefix for the names of new sheets you create. See this page of Calc options. +The single quote is Unicode U+0027, also known as apostrophe. Other single-quote characters, similar to apostrophe, are allowed, such as ʼ ‛ and ‚. +

Using a Default Prefix for Sheet Names

+ You can set a prefix for the names of new sheets you create. Choose %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME Calc - Defaults and enter the prefix name in Prefix name for new worksheet. +

Referencing Sheet Names with Special Characters

+ In cell references, a sheet name must be enclosed in single quotes ' when the name contains other characters than alphanumeric or underscore. A single quote contained within a name has to be escaped by doubling it (two single quotes). + For example, you want to reference the cell A1 on a sheet named This year's sheet. + + The reference must be enclosed in single quotes, and the one single quote inside the name must be doubled: 'This year''s sheet'.A1
- New sheet names prefixing.
-- cgit v1.2.3