Naming of Worksheets (display of existing worksheet name)
-
- Posts: 37
- Joined: Fri Dec 02, 2016 12:14 am
Naming of Worksheets (display of existing worksheet name)
I can find no rules regarding the naming of worksheets. However, if I have a worksheet named 'A&B' and double-click on that name to edit it, then the Old Name is displayed as 'AB', although'&' displays properly in the New Name field.
-
- SoftMaker Team
- Posts: 127
- Joined: Fri Sep 15, 2017 1:29 am
Re: Naming of Worksheets (display of existing worksheet name)
If you save the file in .pmdx (.pmd) format there don't exist sheet name restrictions. If the file is saved in .xlsx (.xls) format, see the screenshot about restrictions. About symbol "&" I'll ask our developers' team why it is displayed wrongly during renaming.
- Attachments
-
- Sheet_names.png (10.6 KiB) Viewed 6250 times
Re: Naming of Worksheets (display of existing worksheet name)
Doesn't the ampersand switch the name into hexadecimal mode.
So '&20' corresponds to the ' ' space character.
Using the hexadecimal allows you to use characters which would otherwise be disallowed because they are used by the machine for specific purposes ..... for example '\' defines folders.
Please feel free to correct me.
So '&20' corresponds to the ' ' space character.
Using the hexadecimal allows you to use characters which would otherwise be disallowed because they are used by the machine for specific purposes ..... for example '\' defines folders.
Please feel free to correct me.