From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- .../source/text/scalc/guide/rename_table.xhp | 91 ++++++++++++++++++++++ 1 file changed, 91 insertions(+) create mode 100644 helpcontent2/source/text/scalc/guide/rename_table.xhp (limited to 'helpcontent2/source/text/scalc/guide/rename_table.xhp') diff --git a/helpcontent2/source/text/scalc/guide/rename_table.xhp b/helpcontent2/source/text/scalc/guide/rename_table.xhp new file mode 100644 index 000000000..dd03da71e --- /dev/null +++ b/helpcontent2/source/text/scalc/guide/rename_table.xhp @@ -0,0 +1,91 @@ + + + + + + + Renaming Sheets + /text/scalc/guide/rename_table.xhp + + + +renaming;sheets + sheet tabs;renaming + tables;renaming + names; sheets + +

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: + + + 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. + + + 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 : + + + back slash \ + + + forward slash / + + + question mark ? + + + asterisk * + + + left square bracket [ + + + right square bracket ] + + + single quote ' as the first or last character of the name + + +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 +
+ +
+ + -- cgit v1.2.3