Product: Spreadsheet
Type: changed
Title: Sheet names can contain almost any character
Posted by: [EMAIL PROTECTED]
Affected: sc
TaskId: i6087
<http://www.openoffice.org/issues/show_bug.cgi?id=6087>
Effective from: cws odff04
CWS:
<http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300/odff04>
CWS status: new
*Flags*
-------
API/ BASIC [ ]
Configuration [ ]
File format change [ ]
Help/ Guide [x]
Performance test [ ]
Translation [ ]
UI relevant [ ]
*Description*
-------------
Sheet names now can contain almost any character, previously they were
restricted to letters, digits, underscore and space. For MS-Excel
interoperability the following characters are not allowed when
renaming sheets or entering new sheet names:
colon :
back slash \
forward slash /
question mark ?
asterisk *
left square bracket [
right square bracket ]
single quote ' if that is the very first or last character of the name
(leading or trailing single quote)
When used in cell references, a sheet name has to be enclosed in
single quotes ' if 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), e.g. a reference to
cell A1 on a sheet named
This year's sheet
would had to be given as 'This year''s sheet'.A1
Send feedback to [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
