This content has been marked as final. Show 2 replies
If your comments appear within the query (not above or below it) and are enclosed in /* */ (not prefixed with --), then they will appear in the query's worksheet.
Regarding font formatting, Microsoft provides a mechanism for setting the default:
The only problem is, SQL Developer does not do a very good job of respecting the default settings. For example:
1. After switching to Arial, a new workbook opened initially with Excel 2007 renders both numbers and letters in Arial.
2. After switching to Arial, a SQL Developer export to .xls (then open in Excel) renders numbers in Dialog and letters in Arial.
3. After switching to Arial, a SQL Developer export to .xlsx (then open in Excel) renders numbers in Dialog and letters in Calibri.
This seems to be a good candidate for a feature request on SQL Developer Exchange.
SQL Developer Team
To clarify and correct my comments about default font settings -
1. SQL Developer uses the java.awt.Font defaults of (DIALOG, PLAIN, 12) when it calls the API that writes out the Excel files
2. How a specific version of Excel displays a file with such defaults (plus any user adjustments to the Excel options) is its business.
So, again, a feature request on our Exchange for a Font/Style/Size preference would make sense.