Toad
If exporting a data grid with Numbers or Integers to an Excel file, TOAD will always include the thousand separator, even if the "Use only 'General' cell formatting" option is checked.
STEPS TO REPRODUCE:
- Create this table and data:
CREATE TABLE EXCEL_TEST
(
INTEGER_COLUMN INTEGER
);
/
insert into EXCEL_TEST (INTEGER_COLUMN) Values (99999);
/
- Open up Schema Browser, Tables tab, Data Tab for this table
- Right click in the Data Grid, Save As
- Select "Format = XLS File" and Options: "Use only "General" cell formatting"
- Choose a file and hit OK
- Open up the file in Excel
- Notice that the numbers are shown as:
99,999
whereas if they are in "General" format, they get shown as:
99999
WORKAROUND
Use Excel's formatting feature to apply general cell formatting to the columns that have number and integer data types.
STATUS
This issue was fixed in Toad for Oracle 7.6.0.11. The latest version of Toad for Oracle can be downloaded at: http://support.quest.com/support_download/Downloads.asp.
