Should worksheet names with periods be quoted in cell references?

[Charlie Clark]

Hi,

recently come across problems relating to the quoting from sheetnames.
According to the specification these need quoting in cell references if
they contain the following special characters:

18.17.2.3 Cell References

sheet-name-special=
sheet-name-start-character-special,
[ [sheet-name-characters-special], sheet-name-end-character-special] ;
sheet-name-start-character-special=
character – (apostrophe | "*" | "[" | "]" | "\" | ":" | "/"
| "?") ;
(* any character, including operator, except ', *, [, ], \, :, /, or ? *)
sheet-name-end-character-special=
sheet-name-start-character-special ; sheet-name-characters-special=
sheet-name-character-special, {sheet-name-character-special} ;
sheet-name-character-special=
apostrophe, apostrophe |
character – (apostrophe | "*" | "[" | "]" | "\" | ":" | "/"
| "?") ;
(* any character, including operator, except ‘ *, [, ], \, :, /, or ? *)

However, it seems that Excel at least also quotes sheetnames with periods
in them: Sheet.1!$A$1 becomes 'Sheet.1'!$A$1.

Does this mean that the specification should be updated to include "." as
sheet-name-character-special?

Furthermore, it looks like Excel struggles with some sheet titles, for
example you cannot add charts to sheets named "an12.103.1". Is this
documented anywhere?

Charlie
-- 
Charlie Clark
Kronenstr. 27a
Düsseldorf
D- 40217
Tel: +49-211-938-5360
Mobile: +49-178-782-6226