Export Dataset - Excel File - Unable to select new location

Toad for Oracle
1

TOAD for Oracle 17.1.717.3711

In Export Dataset options window, if I select Excel File for the Format, the small button to the right of the current location/filename is grayed out and not selectable. The only way to change the location and/or filename is to type it in. Is this a bug?

2

Hi Hillarie,

I cannot reproduce this. For me the button is enabled. Maybe there is a bug here, but I don't know of any. Can you give me a screen shot and provide some details about from where you launched the Export Dataset window?

-John

3

Hi John. It doesn't seem to matter if I click Export Dataset from the toolbar from the Schema Browser or from the Editor after running a query. But for example, below, I click on the GUI icon from a table.

image

It's a little subtle to see, but when I pick Excel File for the format, it's defaulting to last file I saved and the button to change is grayed out (circled with highlighter). I thought it could be that I didn't have a G drive but I checked and still have a drive mapped to G. (Image will be in the next reply)

4

image
image434×696 22.1 KB

Example Export Dataset dialog with File button disabled

5

Hi Hillarie,

Thanks for the screen shot. I've looked at the code, and the only time that button should be disabled is when you are exporting to the "Excel Instance" format, or if you are exporting one of the other formats to clipboard.

What's also interesting in your screen shot is that the "Unix style save" option is enabled. That should be DISabled in the "Excel File" format, because it doesn't apply to this format.
These options should become enabled/disabled when the window is displayed and when you change the export format.

So, two questions:

  1. Were there any errors displayed when the window opened? If so, please give some info about that. It may have prevented the code from running which enables this button.
  2. If you change the export format to something else, and then back to Excel File, does the button become enabled?

-John

6
  1. No other errors were noticed.
  2. I tried that - My Export Dataset was opening with Excel Instance set first and I was switching to Excel File. So I switched to Delimited Text and noticed that I could not change the File location there, either. It was disabled the same as Excel File. But, I switched to Clipboard, hit OK to export, and then went back into Export Dataset. Now when I switch to Excel File, the File selection button is enabled. And, the Unix style save option is disabled.

Solved my problem and hopefully helps you diagnose underlying bug. Thanks!

7

Hi Hillarie,

I tried:

  • In Editor, run a select with F9
  • Right-click in grid and choose Export Dataset
  • Export to "Excel Instance" format
  • Right-click in grid in grid and choose Export Dataset again
  • It opened with "Excel Instance". I changed to "Excel file"
  • For me, the problem still does not occur. The '...' button is enabled.

I played with the clipboard setting too, but couldn't get it to happen. If you can modify my steps above so I can make it happen, I will fix it.

Thanks.

8

Unfortunately, that's the steps I take to recreate the problem.

9

I am having the same issue. By default I have the export dataset come up with "Delimited Text" and output clipboard with file browse grayed out.

After Switching to [FILE] output from Clipboard

image
image445×692 21.4 KB

When I switch to the [FILE] radio button the browse does not become enabled and this looks to be the issue at least for me. When I switch to Access, Excel, ODBC Database, or XLS regardless of the output method the browse is available.

While having the format Delimited Text when I switch the output method to file and then switch to another format only then does the browse button become available.

My guess is that the activation of the [FILE] radio button isn't resetting that button. Only when switching format and having a file output does it get initialized. At least that has been my experience.