Column data is misaligned when copying from data grid and pasting to Excel (4301787)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Column data is misaligned when copying from data grid and pasting to Excel
Description

When copying data from data grid by selecting all, then CTRL-C | select 'Include headers, tab separated text'
then pasting into Excel 2007 worksheet, some of the column data becomes misaligned. i.e. data from one column gets pushed into another column
Sending to Excel using Quick Export | Excel File, the data is aligned correctly.
Cause

Tabs in the data being interpreted as column separators
Resolution

WORKAROUND
Use Quick Export | Excel File if data contains tabs.
STATUS
Waiting for fix in a future release of Toad for Data Analysts

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title