Print Thread
Setting default font for Copy to Excel
#47153 05/30/13 02:21 PM
Joined: Apr 2008
Posts: 3
Newton, Mass
D
Member
OP Offline
Member
D
Joined: Apr 2008
Posts: 3
Newton, Mass
Is there any way to control the font that is used when the Copy to Excel option is used to dump data to an excel file? I have set the Excel default for new worksheets but the Excel files created by PL/SQL Developer are all created with Calibri font which I find hard to read. I used version 9.06.

Thanks

Re: Setting default font for Copy to Excel
Don Keyes #47158 05/31/13 09:00 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
The Excel sheet is created with grid font. You can go to Tools > Preferences > Fonts and change the grid font accordingly.


Marco Kalter
Allround Automations
Re: Setting default font for Copy to Excel
Marco Kalter #47258 06/10/13 01:05 PM
Joined: Apr 2008
Posts: 3
Newton, Mass
D
Member
OP Offline
Member
D
Joined: Apr 2008
Posts: 3
Newton, Mass
Sorry, mine doesn't work like that. I double checked that the font was set to Verdana in the preferences but when I copy the data to excel it is formatted with Calibri Font. I am using version 10.0.3 now.

Re: Setting default font for Copy to Excel
Don Keyes #47268 06/11/13 09:20 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
I tested this, and with xls export it shows up as Verdana and with xlsx export it shows up as Calibri. We'll fix it.


Marco Kalter
Allround Automations
Re: Setting default font for Copy to Excel
Marco Kalter #53576 05/31/16 09:06 AM
Joined: Apr 2007
Posts: 12
Glasgow
S
Member
Offline
Member
S
Joined: Apr 2007
Posts: 12
Glasgow
Sorry to resurrect this one but was it ever resolved? If Yes, How?

Using version 11.05

Last edited by StevenRowe; 05/31/16 09:07 AM.
Re: Setting default font for Copy to Excel
StevenRowe #53577 06/01/16 09:30 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
In the 32 bit version:

Copy as XLS will use the grid font as defined in the preferences.
Copy as XLSX will use Calibri.

In the 64 bit version:

Copy as XLS will use the grid font as defined in the preferences.
Copy as XLSX will use the grid font as defined in the preferences.



Marco Kalter
Allround Automations
Re: Setting default font for Copy to Excel
Don Keyes #64400 01/24/23 10:09 AM
Joined: Jan 2005
Posts: 19
Utrecht, The Netherlands
F
Member
Offline
Member
F
Joined: Jan 2005
Posts: 19
Utrecht, The Netherlands
Hi Marco,

I would like to have the default font for Excel files separate from the grid font.
Can you add that to the list of enhancements?


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.089s Queries: 15 (0.036s) Memory: 2.5192 MB (Peak: 3.0377 MB) Data Comp: Off Server Time: 2024-03-29 09:53:40 UTC
Valid HTML 5 and Valid CSS