Return
-
Title
With an Export Dataset to Excel file, the number columns have commas on it or are in bold style -
Description
When data needs to be exported to an Excel file and a Template/Style has been defined with Header in Bold Style, the Excel columns with numbers will include commas, if the option “Use only “General” cell format” is unchecked.Vice versa, if “Use only “General” cell format” is checked, all columns with numbers will be in bold format. -
Cause
"Match cell fonts to grid" option is working incorrectly -
Resolution
WORKAROUND:
As a workaround, un-check "Match cell fonts to grid" and that will solve the problem of bolded columns. To do this:
Go through:- View menu- Toad options- Data Grids -> Visual- In active Style Legacy, select Edit Styles- Select Legacy Style -> Edit button- Grid Element - Select Header option- Select the ... button next to Checkbox Font- Change the Font Style to Bold. By default it's on Regular style.- Select OK and apply those changes.- Execute a select statement where you can see some data with numbers- In the datagrid -> Export Dataset -> Export to Excel- Check “Use only “General” cell format”.- Then, open the Excel file.You can leave "General" option checked and you won't get commas in the number columns. It is expected to have commas in number columns if "General" is not checked.
STATUS:
Waiting for fix in a future release of Toad for Oracle
-
Defect ID
TOR-1002