Toad for Oracle 184.108.40.206.
I was exporting a data set from the editor results grid today, to Excel. I put a question mark (?) in the sheet name, and when Excel loaded the file, it barfed. I was offered the opportunity to “recover the corrupted file” and that worked, but I got a weird ame (recovered sheet 1) for the sheet in question.
It seems that the following are not allowed in a sheet name:
- colon (
- backslash ()
- slash (/)
- question mark (?)
- asterisk (*)
- square brackets ([ or ])
Also, a sheet name of “History” is reserved - but while Excel will load the file, and name the tab History, you won’t be able to rename a tab to history. It appears to be a hidden sheet used for tracking changes, so who knows what might happen if a Toad export with a tab name of “History” is created, and Excel has track changes enabled!
Maybe the sheet name text edit needs a key filter to filter out these invalid characters, and to prevent the use of “History” as a sheet name. (Case is ignored by the way.)