When setting up automation and a Select to File task, it is set to export results to an Excel file. The Export Options page has the option to 'Auto fit columns'. When hovering the cursor over the 'Auto fit columns' option, the following description is displayed 'First row of file will have column names as data'. This is incorrect, and relates to the option above it, 'Use column names for a header row'.
When trying to run the task, with the 'Auto fit columns' option checked, the expectation is that the Excel file created sizes the columns automatically to the larges value (whether the header or the data). But it does not auto fit and the columns/data are hard to read in the Excel.
WORKAROUND:
The columns need to be manually adjusted after it's been created.
STATUS:
Issue fixed in version 3.1 and 3.2. The latest version of Toad for Oracle can be downloaded here.
