Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
No formatting - stop formatting query results (Read 2401 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
No formatting - stop formatting query results
29.08.07 at 08:07:41
 
No formatting - stop formatting query results
 
Question:
The data returned is all on blue (header) or yellow (data) background and I haven't found in the help any way to disable this. We need to use our own formatting.  
 
Answer:
You can set the default formatting in the Formatting Preferences
 
Related topic:
Preferences menu item
http://www.oraxcel.com/projects/sqlxl/help/menu%20items/preferences.html
 
You can also switch of formatting. In the resultset options dialog you can opt to not format the data. In the program preferences you can set the default value for the format data checkbox.
 
Related topics:
Format Output checkbox (Resultset options dialog)
http://www.oraxcel.com/projects/sqlxl/help/dialogs/resultset_options/format_outp ut_checkbox.html
Preferences menu item
http://www.oraxcel.com/projects/sqlxl/help/menu%20items/preferences.html
 
If you use macros in VBA or VB you can set the following property of the target Excel:
Targets(litExcel).FormatData = False
Back to top
 
« Last Edit: 30.08.07 at 07:38:47 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1